Some very important qualitative questions your company needs to ask itself to be sure you are complying with this new regulation.
Aaron Bertrand announces the recipient of his second annual Community Influencer of the Year award.
For this T-SQL Tuesday, I talk about a few of the difference makers in my career.
Tip : Overview of Database Engine Changes in SQL Server 2017
In this tip, I dig into some of the inner workings of resumable index rebuilds.
For this T-SQL Tuesday, I describe a few of my experiences from the 2000s, from both sides of interviews.
For T-SQL Tuesday #92, I show one trick I use to prevent errant DML from running in production.
Tip : Dealing with the single-character delimiter in STRING_SPLIT function
I illustrate why you should be very careful about oversizing varchar / nvarchar columns.
In this tip, I explain a simple trick to prevent accidental updates or deletes.
I recount the way I implemented database changes in a distributed SQL Server system a decade ago.
Tip : Performance Impact of SQL Server 2016 Row-Level Security
I show a "redundant" non-clustered index outperforming the clustered index with the same key.
I start a new series around disproving prevalent myths regarding SQL Server performance.
For T-SQL Tuesday #87, I talk about two shiny new toys in SQL Server: STRING_SPLIT() and STRING_AGG().
I show how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.
In an effort to make leading wildcard searches sargable, I play around with a trigram-type implementation in SQL Server.
I show that DISTINCT and GROUP BY are usually interchangeable, but there are cases where one performs better than the other.
For T-SQL Tuesday #86, I highlight a few of my favorite bugs and feature requests on Connect (RIP).
I start digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.
Aaron Bertrand announces the first annual Community Influencer of the Year award.
I take an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.
For both T-SQL Tuesday and #BackToBasics, I provide information about SQL Server backups, and why your restores can be just as important.
I explain a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.
I describe my steps for setting up a development stack, with VS Code on Mac, managing SQL Server on Ubuntu, inside a Docker container.
Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.
After a conversation online, I show where excessive comments in your stored procedures might have an impact on performance.
We've all accidentally placed objects in master. In this tip, I show how you can clean it up a little.
I refreshed the demo kit that helps you learn (or teach!) the ins and outs of SentryOne Plan Explorer.
I explains why I code defensively – matching the case of data type names, even when it is irrelevant.
I run some tests to challenge the notion that CHARINDEX is always faster at pattern matching than LEFT and LIKE.
I talk about two core issues to consider when choosing a standard for stored procedure names.
I continue a series on widening an IDENTITY column, showing how I would attack the problem directly.
I take a look at one of the classic debates in SQL Server: whether to support Unicode.
Tip : Beware of Side-Channel Attacks in Row-Level Security in SQL Server 2016
I show a few different ways to download SQL Server 2016 Developer Edition, which is a bit harder to obtain than it should be.
I submit a wish list item for the 80th T-SQL Tuesday: CREATE OR REPLACE, a cleaner way to deploy objects without losing permissions.