Availability Group Read-only Routing

This morning at a customer site I was researching an issue where Availability Group read-only routing was not working correctly. Quickly I was able to determine the issue was...

new LinkedIn article

Hi everyone,
I just published a new LinkedIn article entitled “Let It Go”. Please check it out!
https://www.linkedin.com/pulse/let-go-chuck-boyce

Profiling Entity Framework 6 Queries

Entity Framework 6 introduced some API hooks that you can use to monitor log queries that Entity Framework is generating...

SQL Script to find the missing indexes

Performance tuning in SQL is important exercise and index creation is an important part of it. Below script will help in finding the...

SQL SERVER - Data types

In relational database, we store data in tabular form where data is divided into columns. Each column has a name...

Compress that database

When you have to compress a database you'd better first see the considerationfor the compression.This is a script that I...

Script for compressing a database

When you have to compress a database you’d better first see the consideration for the compression.
This is a script that...

Script for compressing a database

When you have to compress a database you’d better first see the consideration for the compression. This is a script that I use for compressing databases. Of course you...

Script for compressing a database

When you have to compress a database you’d better first see the consideration for the compression. This is a script that I use for compressing databases. Of course you...

SQL Server - Convert() function

Convert () function in SQL Server to convert an expression from one data type to another data type

Syntax for CONVERT function
CONVERT ( data_type [ ( length ) ] , expression...