The 3AM Meltdown - New DBA Team Article
Where do you start fixing a SQL Server crash when there isn’t a single clue? The DBA Team had better find out quick, or they’re not going to get any sleep tonight. Find out how it all goes.
Performing Azure SQL Database Management Tasks by Using PowerShell with REST API
Recently, we have been exploring the ability to administer Azure SQL Database by leveraging REST APIs invoked from PowerShell-based scripts. Such an approach offers more flexibility, facilitating functionality that is not directly exposed in the PowerShell cmdlets. In this article Marcin Policht shows the benefits when dealing directly with Azure SQL Databases.
SQL Azure Point-in-Time Restore
Point-in-Time Restore is a new feature of the SQL Azure Service Tiers
Database Deployment Problems Survey
Red Gate is looking to build tools and features to help reduce the risk of database deployment. In order to achieve this, we need to get a better understanding of the most common deployment problems you are encountering when moving changes from development to production. Please help by filling in our two-page survey.
Questions about Primary and Foreign Keys You Were Too Shy to Ask
It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.
SQL Monitor Custom Metric: Buffer Pressure
Trying to determine if you have pressure in your buffer allocations can be difficult. This metric reliably indicates if you have a buffer problem using the memory dump from DBCC MEMORYSTATUS() and comparing Target Committed to the Current Committed allocations. If you hit negative numbers you are looking at a buffer issue.
Document, then Install
Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.
Fine Products for the Modern Drudge
As working hours in tech trend upwards, we look at some ways to make life easier.
Linked server creation to MySQL Server
Here is a step by step procedure to create a linked server to MySQL from SQL Server.
PASS Summit, Seattle, WA
Join the world's largest gathering of SQL Server and BI professionals in Seattle on November 4-7. PASS Summit is your conference – planned by and for the SQL Server community. Red Gate will be exhibiting, so drop by their booth and say hello. Register while space is available.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers