Another productivity tool in my toolbox that I use on a daily basis. This time related to the file search. Everything will help you find… well, everything.

Here are the chronicles of my struggles to add a large Clustered index to a View without causing an outage.

Taking a short break from SQL topics, I wanted to share some of the tools I use to boost my productivity. Greenshot is a screengrabbing tool with many useful features.

In this longest post in the series, I’ll show you how you can fix the problems with Scalar UDFs.

This month’s T-SQL Tuesday’s invitation is from Deborah Melkin. The topic is to rant about anything you want.

Continuing the series, we’ll examine how Scalar functions are terrible for performance.

Have you ever encountered a situation where you mark the constraint as trusted, but the next day, it’s back to untrusted again? This blog post will help you find the cause.