When STRING_SPLIT() falls short
SQL Server’s STRING_SPLIT() has limitations; here are the gaps to consider when splitting strings.
Continue readingBrowse the archive
Bugs
Deadlock when creating a database - A Query Store bug
Earlier tonight, I sat down to install Reporting Services on my laptop. I haven’t played with SSRS 2017 yet, so I figured I’d poke around some. Much to my surprise, the configuration failed when creating the ReportServer database, reporting a deadlock. When I …
Continue reading
Configuring Replication with Availability Groups
Configure SQL Server replication with availability groups and understand its supported publisher and subscriber roles.
Continue reading
DROP TABLE Bug on Filestream Garbage Collection
FILESTREAM is not a particularly popular feature of SQL Server–if you’re using it, you are in the minority. If you have a database with filestream in an Availability Group, then you’re REALLY in the minority. At my 9-5, this is being done, and it’s apparent …
Continue reading
Really Long Descriptions on SQL Agent Jobs
WARNING: Silent truncation ahead Have you ever tried to enter a really long description on a SQL Agent job? Maybe you were trying to put some sort of warning to people who might be trying to edit the job, or triage info for when the job fails. (Ok, so this …
Continue reading