(Larry Leonard) This script will change an Operator’s name and update all three notification option types the Operator has.

(Kenneth Fisher) T-SQL TuesdaySo I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it would make a fun topic for this month. I’d actually written this post before I wrote my hosting post for T-SQL Tuesday but it fit so well I couldn’t bring m

(Prashanth Jayaram) We can directly access a CSV file using T-SQL.

(Marcin Policht) In general, Microsoft Azure provides two types of SQL Server based relational data services. So far, we have been focusing on this forum on Azure SQL Database Platform-as-a-Service (PaaS) offering.

(Greg Larsen) In my last article I discussed the GROUP BY clause. This article will expand on the GROUP BY topic by discussing the ROLLUP, CUBE and GROUPING SETS operators. These operators are used with the GROUP BY clause and allow you to create subtotals, grand totals and superset of subtotals.

(Dennes Torres) How often do you check your query plans during development to see if they contain any warnings? If you’re missing them, it means that you’re not getting all those hints about missing indexes, join predicates or statistics. Is the query optimiser trying to tell you about implicit conv

(Pinal Dave) What happens when you try to copy a large file from different hard disks? The operating system tries to see if the destination location has enough space available for the copy to be successful.

(Steve Endow) I recently learned two interesting things about SQL Server backups from the esteemed Victoria Yudin.

(Tim Smith) I frequently run into SQL Server administrative and development tasks, as well as being asked by other administrators and developers, for certain tasks to be performed. In this tip, we cover 6 PowerShell scripts that make these tasks much easier.

(Pinal Dave) As part of learning I get inspiration from the activities we do daily and see how it can be mapped to SQL Server. This in a way many say is an obsession for the subject I love – SQL Server. But I think it is part of how we laterally think.