Two Important ‘ONLINE’ Column-Level Operations in SQL Server
Today Kendra talks about two of the online options used when working with indexes.
2020-01-14
366 reads
Database Administration
How Does Accelerated Database Recovery Work?
Accelerated Database Recovery is new with SQL Server 2019 and Azure SQL Database and used to decrease the time for rolling back large operations and database recovery. In this article, Forrest McDaniel explains how it works.
2019-12-12
How to Use SQL Audit and Azure Log Analytics to Comply with Audit Rules
You can use SQL Audit to record changes to security, access to tables, and more to help you meet compliance requirements. In this article, Joshua Feierman explains how to set up the audit and collect the data in Azure Log Analytics when running SQL Server in an Azure VM.
2019-09-26
An Alert Philosophy
Many of you reading this will be responsible in some way for managing a system. This might be a test/development system or a production one, but often you want to know how well the system is working. Or maybe you want to know if the system is working at all. Even developers care if their […]
2019-06-19
255 reads
Execute SQL Scripts via SQLCMD on Multiple SQL Servers and Save Output as CSV Files
As a part of SQL Server production support and day to day tasks we usually come across situations where we get requests to run a T-SQL script against multiple servers. Sometimes the request is to not only to run the script, but save the output too
2019-05-31
5 Questions to Ask When You Upgrade SQL Server
Whether you’re looking to go cutting-edge and hop on SQL Server 2019 as soon as it’s available, or whether you’re just trying to evacuate from SQL Server 2008 to anything that’s going to be supported after this summer, you’re probably doing upgrade projects. This is a good time to ask yourself 5 questions...
2019-05-31
Things SQL Server Setup Doesn’t Do – And Should
Brent Ozar on questions that SQL Server setup wizard should ask you, by default, to help you protect the data
2019-05-31
SQL 2016 Won’t Sent Mail
One of the more challenging components to configure on SQL Server is SQL Mail. I don’t know how many times I have had to try it multiple times before...
2019-05-14
Automating Log File Expansion
Max Vernon shows how you can automatically expand log files to optimize VLF counts: SQL Server Database Log file expansion can be fairly tedious if you need to make...
2019-05-14
Spring Cleaning Your Tables – And Forgetting Your Indexes. A Story of Compression
Anyone who has been either a kid or a parent has probably heard this story before. The child is sent to clean their room, which to your eyes looks...
2019-05-11
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers