TSQL Tuesday #60: Something New Learned – What permissions does have?

What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to...

Using Bookmarks in SQL Server Management Studio

In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine...

#SQLPASS #Summit14 Day 2 Keynote Highlights !

This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day...

Add Witness to Existing SQL Server Database Mirroring

1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2....

Add Witness to Existing SQL Server Database Mirroring

1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2. Click Configure Security, Configure Database Mirroring Security...

Expected Variables–T-SQL Testing

After I wrote about creating tables that contain the results I expected, I wondered if I could do the same...

How explicitly insert default value ? TIP #72

 
Suppose, sometimes you just need  entry in the table with all the default values.
For example you have a Student...

Last Weeks Top “Reading” Links #108

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Let’s get started

Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to...

Monitoring BI Performance: Scripts and Slides

I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing...