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,788 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
2,028 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
I had been meaning to post this, so as I finished a piece that...
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
The post Lukáš Karlovský: I got the green light from management and built Fabric...
Comments posted to this topic are about the item The Pervasive Nature of Open...
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding...
What is wrong (if anything) with this code?
SELECT * FROM Sales.SalesOrderHeader AS soh WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS C WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)See possible answers