T-SQL Regular Expressions: SUBSTRING, PATINDEX and CHARINDEX
In my previous article about T-SQL regular expressions, I have explained the LIKE operator, its...
Basics of SQL Server Task Automation
This is an introductory article about automation in SQL server primarily focused on the basic concepts. We will discuss some standard...
Transact-SQL: Working With Strings
Microsoft SQL Server has many built-in functions that can be used to format the output and represents it in the desired format. In this...
Create Indexed Views in SQL Server
Introduction You would have already heard about views in databases. We create views for a number of...
How to Update SQL Server Statistics for Big Tables
In my previous article, I have briefly covered database statistics, its importance, and why statistics should be updated. Moreover, I have...
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...
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 format for the purpose of something...
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,...
AlwaysOn Availability Groups: Quorum
SQL Server AlwaysOn Availability Groups is Microsoft’s latest technology for addressing the High...
