Stored Procedures – Common Security Practice

In SQL Server a good practice is to access the data via calls through stored procedure.  Have a look at...

The Barking Dog Analogy

The Barking Dog Analogy
Maggie and Woody

A discussion started today on Twitter about CXPacket waits. There had been a heated debate...

T-SQL Tuesday #22 Round-Up - Data Presentation

T-SQL Tuesday #22 is history, and I was pleased by the many posts and participants in this month’s September blog...

Updated Data Migration Assistants (5th Version Already) & Project Template to Help with Your Upgrades

 
After having spent much time attempting to settle a point regarding my favourite pastime of provincial politics, it has come...

Building a Visual Studio project from an existing SSAS database

Imagine you join a company, and there is an existing SSAS database that contains a few cubes that are working nicely.  You...

Column Level Permissions

Did you know that you can grant permissions down to the column level in SQL Server?   Well, if you didn’t know that – you do now. It is...

Column Level Permissions

Did you know that you can grant permissions down to the column level in SQL Server?   Well, if you didn’t...

Database Snapshot as a Reporting Solution – Some Realtime Issues and Answers

One of Our production database is used by lots of Reporting users. Mirroring is enabled on this database. But no one is...

Father of SQL Server?

“I love SQL Server. SQL Server has given me good career, salaray and life”
“Be loyal and dedicated with SQL Server....

Getting Excited: SQLBits is Coming!

Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling...