What is a data warehouse and why do I need one?

While the data warehouse isn’t a new concept, many are left wondering – what is a data warehouse? And why do I need one? I’m sad to tell you...

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

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

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 Database Mirroring to ensure that everything is working...

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

SQL Server Table Partition Example

Why Use a SQL Server Table Partition
Data warehouses and data repositories often have tables that store millions of records and...

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

SQLPASS Summit 2014 is here, The largest SQLServer Conference !

November is not the right time to visit Seattle (Blame the rain!), but I kinda like November because that’s when...

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