Two weeks ago I delivered a presentation called “Things You Can Find In The Plan Cache” to the israeli SQL Server user group. Among the...

Photo credit: Digitalnative About a year ago, I came across an online deal for a car stereo system with a USB port. After the purchase, I...

I read this awesome post by Joe Sack, titled “Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats”. I was amazed by the...

Usually, a database is meant to serve some kind of application, and .Net applications have a few possible ways to query the database. In...

One of our customers is implementing a very large consolidation project in which they enable users to create their own databases through...

Last week I delivered a seminar in the Expert Days 2012 event by the name of “40 Things You didn’t Know About SQL Server”. The seminar...

Today I’ll show you a special script which will let you “take a snapshot” of your table’s data, and apply it on an identical table...

Here’s what is going to happen today: we’re going to bring a bunch of objects to life, and then we’re going to kill them. Woah, why all...

I remember when SQL server 2008 was first released and I have examined some of its features, when I came across Compression, I was very...

For your convenience, below is a download link to get the presentation and relevant materials for the SSIS Tips & Tricks presentation by...