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

Once upon a time there was a database. The database was perfectly designed with beautiful tables and views accompanied by good-looking...

SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended...

24 Hours of Pass is tomorrow. If you haven’t registered yet, now is a good time. I expect to: Have little to no sleep time See some cool...

It’s important to write the right code on the right server, since each mistake can be very expensive in this area. Below are a few common...

Imagine the following scenario: After a very nice weekend, you get up in the morning with a smile on your face, get to work and drink...

Cursors (and partially while loops) have a really bad reputation in the SQL Server world. Basically, there are three good reasons that...

Before I became a SQL Server DBA, I used to be a web developer in ASP3. Since then, I sometimes maintain the websites I still have. Fix...

Dynamic Search Queries SQL Injection is a widely known issue with databases that work as back-ends for websites and applications. In the...