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....

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...

PASS Keynote–Dr. Rimma Nehme

I missed the PASS welcome, but I did arrive to see Cloud Databases from Dr. Rimma Nehme.
We begin with a...

PASS Summit 2014: WIT Luncheon with Kimberly Bryant

Kimberly Bryant, founder of Black Girls Code
When Kimberly Bryant began studying programming at college, she found that there were few...

Summit 2014

It’s hard to believe it’s over.  It felt like a whirlwind while I was in Seattle for my 7th PASS...

How to pause execution for particular time or interval ? TIP #71

 
Suppose, We are working on a stored procedure in which some complex operation is going. We are fetching some value...