Building blocks of Extended Events data collection
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.
2021-10-04
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.
2021-10-04
To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.
2021-07-09
SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains 9 best practices for performance tuning.
2021-06-16
In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.
2021-06-14
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,712 reads
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
1,836 reads
Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.
2020-09-14
There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.
2020-08-28
No discussion about storage is complete without thinking about security of the data. In this article, Robert Sheldon explains what must be considered to protect data in today's world.
2020-08-10
Brent shows us how to Install Azure Data Studio to Work with SQL Server.
2020-08-05
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone...
I've been exploring various methods to monitor and alert for long-running queries in SQL...
Hi everyone I need to find the last business of the week. In most...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers