SQLSaturday Portugal Porto 2014 Recap

Incredibly as it sounds, it took us 2 years of work to get the 18th of October. It took a...

5 things to know about Databricks

Databricks is now available in both AWS and Azure so it’s getting a lot of buzz! Let’s discuss 5 things you should know about Databricks before diving in. 1.    ...

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