Force only certain values to be unique

I thought of something rather interesting the other day while answering a question asking for help with some table structures....

How to copy table structure only from a SQL Query ? Tip #69

 
Recently , one of my friends shared that some interviewer asked him a question “How to copy table structure only from...

Implementing Tabular Data Models: Microsoft Virtual Academy

 
Implementing Tabular Data Models

Date: November 11, 2014

Time: 9am?5pm PST

Where: Live, online virtual classroom:
http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models

Cost: Free!

Register today! (linkto: http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models)

What will you do...

Interview questions for database developer

Technical Round Database Interview Questions

1) What are the different types of Trace flags which we used for detecting the Deadlock?
2)...

Last Weeks Top “Reading” Links #107

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

My DTS Package won’t load with the error “here were errors loading package”

You are trying to open a DTS package (yes some people still use DTS packages) and receive the following error:
Error...

PASS Summit 2014 Diary – Day 1

Today is the first day of official activities for the week.  The PASS Summit hasn’t yet started, but I’ll be...

PowerPivot Saga: Scheduled Refresh more than once a day

PowerPivot data models in Excel is a great way to quickly pull data from various sources, build relationship between different...

Setting Expectations–T-SQL Testing

I don’t know who started this pattern, as I’ve seen it in a few places. It could have been Sebastian...

SQL Server Database Mirroring Monitoring

SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of...