How to enable SQL Server trace flags
DBAs can control many aspects of SQL Server’s behavior with trace flags. In this article, Robert Sheldon explains how to enable SQL Server trace flags.
2021-07-30
DBAs can control many aspects of SQL Server’s behavior with trace flags. In this article, Robert Sheldon explains how to enable SQL Server trace flags.
2021-07-30
Level up your skills with Redgate’s latest competition. Redgate is giving you the chance to win a 3-month subscription to Pluralsight, the technical skills platform. To enter, visit the Redgate Forums and answer the question ‘What’s your favorite Redgate tool and why?’
2021-07-30
Grant Fritchey discusses the relationship between microservices architecture and database deployment and how these two important pieces of the DevOps puzzle, can work together, or against each other in the future.
2021-07-28
How do you include blob storage in reports? In this article Dennes Torres explains how to query blob storage with SQL using Azure Synapse.
2021-07-28
A PowerShell function that will compare two SQL formatting styles, saved in JSON, and produce a report showing the differences between the options they use to lay out your SQL code.
2021-07-26
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
The SQL Server transaction log must be managed to keep a database running and performing well. In this article, Greg Larsen explains how to manage the transaction log size.
2021-07-23
How to use PowerShell cmdlets, such as Select-String, to glance at the contents of the application logs, or use them in conjunction with Regular Expressions to sift through log files in detail looking for particular types of error.
2021-07-23
When comparing databases, save your standard options and filters to a single project file, and then use PowerShell to script them out to the command line. This allows you to reuse the same project file across multiple comparison operations.
2021-07-21
Monitoring SQL Server for performance is a critical part of a DBA’s job. In this article, Edward Pollack explains some of the SQL Server performance monitor data and how to collect it.
2021-07-21
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers