SQL Server Code,Tips and Tricks, Performance Tuning

Another year is almost over. As the last post of this year I decided to share with you the 15 most popular posts in 2016. I just used Googl...

You didn't go to the PASS summit this year, but you would still want to watch the sessions?  There is a way now, you can buy the USB ...

A nice holiday present for you all has just arrived: SQL Server next version Community Technology Preview 1.1 Here is what is new in ter...

Here are some interesting articles I read and tweeted about this past week, I think you will like these as well. If you are bored this week...

One of our database on the development went in suspect mode today. This database was the default for a bunch of logins.  These people could...

Here are some interesting articles I read and tweeted about this past week, I think you will like these as well. If you are bored this week...

Here are some interesting articles I read and tweeted about this past week, I think you will like these as well. If you are bored this week...

Today, I decided to see how I can change the port SQL Server is listening on To see what port SQL Server is listening on, you can use...

I was working on a post about the new columns sql_memory_model, sql_memory_model_desc columns in DMV sys.dm_os_sys_info. These columns all...

You have a DBA that you want to get something for this holiday season, but you have a hard time figuring out what to get him? Here are 3 ch...

I blogged about this before but someone ran into this issue again at work so I thought it made sense to revisit this. I prefer to use BUL...

Here are some interesting articles I read and tweeted about this past week, I think you will like these as well. If you are bored this week...

I decided to play around with installing SQL Server vNext on Linux today. I decided to pick the Ubuntu distribution. I created a VM in Vi...