(Jeremy Kadlec) Users are reporting issues accessing one of our critical production databases. I see that the database is not loading properly in the application and in SQL Server Management Studio.
Tag: sql server
(Pinal Dave) Some concepts are so good in SQL Server, they keep on coming back to me one way or another way. After reading my recent blog posts about CHECKPOINTS lots of people wanted to see the demonstration of the same.
(Hannes du Preez) Avoid using NOT IN whilst comparing nullable columns.
(Ben Richardson) SQL Server CASE statement is equivalent to the IF-THEN statement in Excel.
(Greg Robidoux) One of the main functions of a DBA is to maintain indexes. There have been several tips written about different commands to use for index rebuilds and index reorgs as well as the differences between index maintenance with SQL Server.
(Marcin Policht) While the most common methods of interacting with Azure Cosmos DB involve programmatic access, there are times when you might want to perform a quick change or take a peek at some of documents in a collection.
(Denny Cherry) There are people out there that love SQL CLR, and there are people that hate SQL CLR. I have a slightly different opinion, which is that I hate how most people use SQL CLR.
(Jack Vamvas) Question: Do you have a powershell script allowing me to dynamically create a drive – pointing to a network share , and then start an unattended install of SQL Server patching?
SQL SERVER – Automatic Seeding of Availability Database ‘SQLAGDB’ in Availability Group ‘AG’ Failed With a Transient Error. The Operation Will be Retried
(Pinal Dave) Earlier I have written few blogs about automatic seeding feature. In this blog we would learn how to fix error: Automatic seeding of availability database ‘SQLAGDB’ in availability group ‘AG’ failed with a transient error.
(blobeater) While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis for the Query Store reports within SSMS.