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

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

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

How I Got Here: 5 Years At Pragmatic Works

I recently celebrated my 5 year anniversary at Pragmatic Works. Boy, how time flies by. It feels like just the...

Unit tests help document your code!

I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for his Google Hangouts series, catch the video here
One of...

Unit tests help document your code!

I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for...