(Kenneth Fisher) For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL triggers. I’m talking about plain old ordinary DML triggers.

(Scott Murray) Often, as a SSRS developer, you will find that you have to be creative in order to get a report to display your data in just the exact way the report consumers want. Unfortunately, getting the data in the format needed is never easy and often times, getting the actual data is only a s

(David Dye) I frequently see posts in the MSDN forums requesting assistance in removing duplicate values from a source, other than SQL, to be entered into a SQL Server destination. There are several options to accomplish this, but this post is meant to address the easiest and most straight forward.

(Chris Webb) Recently I was asked an interesting question by Ondra Plánièka in the comments of a blog post: how can you handle errors caused by unavailable or missing data sources in Power Query?

(Chris Yates) Being engrossed with the daily tasks at hand I completely missed this month’s T-SQL Tuesday is being brought to you by Sebastian Meine Blog | Twitter.

(Dwain Camps) Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase ‘Quirky Update’ tricks to perform the many permutations of running totals in SQL Server. One of these related problems is the ‘Data Smear’. Do win

(Ayman El-Ghazali) Welcome to Part 1 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. This first video describes how to setup a baseline for your system using the PAL tools.

(Adam Kreul) A while back I had written a post about why I’m excited about Hekaton (now called ‘In-Memory OLTP’ – not sure why, Hekaton is much more fun to say), and while I am certainly still excited about this new feature, it does have some significant barriers to entry. Here’s a quick hit list o

(Kenneth Fisher) Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this little trick.

(David Dye) If you are just beginning SQL Server database administration then you might not be familiar with the different types of database backups that are available and exactly what they backup.