Create Indexed Views in SQL Server
Introduction You would have already heard about views in databases. We create views for a number of...
10 Best MySQL GUI Tools
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...
Microsoft Azure Vs Amazon Web Services: What’s your Ultimate Choice?
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...
How to Update SQL Server Statistics for Big Tables
In my previous article, I have briefly covered database statistics, its importance, and why...
Report Builder Basics for Power Users and IT Professionals
This is an introductory article about the Microsoft Report Builder tool which is used to build and manage paginated reports. Additionally,...
T-SQL Regular Expression: LIKE Operator and Its Use-Cases
A Regular Expression (Regex) is a rule defining how characters can appear in an expression. In essence, it is a sequence of characters or...
Switching Out Table Partitions in SQL Server: A Walkthrough
Introduction A few years ago we were tasked with a business requirement for card data in a specific...
Creating Professional SSRS Report based on Stored Procedure
This article talks about creating a professional SSRS report based on a stored procedure to meet the business specification. Additionally,...
Hosting Package on Chocolatey
In this article, we will take a brief look at the key stages of Chocolatey package creation. Prerequisites Before getting started with the...
AlwaysOn Availability Groups: Quorum
SQL Server AlwaysOn Availability Groups is Microsoft’s latest technology for addressing the High...