Create Indexed Views in SQL Server

SQL Server

Introduction You would have already heard about views in databases. We create views for a number of...
Read More

10 Best MySQL GUI Tools

MySQL, Tools & technologies, Utilities & Extensions

MySQL is among most widely-used and popular database technologies, so quite a lot of tools have been created in order to make the processes...
Read More

Microsoft Azure Vs Amazon Web Services: What’s your Ultimate Choice?

AWS, Cloud

Have you heard the term cloud computing? Do you wish to try your hands on cloud platforms? Well, if you seem to be a newbie to this new...
Read More

How to Update SQL Server Statistics for Big Tables

Database development, Tables

In my previous article, I have briefly covered database statistics, its importance, and why...
Read More

Report Builder Basics for Power Users and IT Professionals

Tools & technologies

This is an introductory article about the Microsoft Report Builder tool which is used to build and manage paginated reports. Additionally,...
Read More

T-SQL Regular Expression: LIKE Operator and Its Use-Cases

Languages & Coding, T-SQL • One Comment

A Regular Expression (Regex) is a rule defining how characters can appear in an expression. In essence, it is a sequence of characters or...
Read More

Switching Out Table Partitions in SQL Server: A Walkthrough

Database development, Tables

Introduction A few years ago we were tasked with a business requirement for card data in a specific...
Read More

Creating Professional SSRS Report based on Stored Procedure

Business intelligence, SSRS

This article talks about creating a professional SSRS report based on a stored procedure to meet the business specification. Additionally,...
Read More

Hosting Package on Chocolatey

Automation, Tools & technologies, Utilities & Extensions

In this article, we will take a brief look at the key stages of Chocolatey package creation. Prerequisites Before getting started with the...
Read More

AlwaysOn Availability Groups: Quorum

Availability Groups, Database administration

SQL Server AlwaysOn Availability Groups is Microsoft’s latest technology for addressing the High...
Read More
Close