Capture Index Usage Statistics for Better Analysis
Starting with SQL Server 2005, Microsoft introduced Dynamic Management Views to help DBAs see what's going inside of SQL Server....
2012-10-23
2,526 reads
Patrick
- Twitter: @patrickkeisler
- Website: https://www.patrickkeisler.com
- LinkedIn: https://www.linkedin.com/in/patrickkeisler/
Which SQL Instance is Killing Your CPU?
You have 5 instances running. How do you know which one is killing your CPU?
As you can see from Windows...
2012-10-16
552 reads
Grant Execute Permission on All Stored Procedures
Right out of the box, SQL Server makes it pretty easy to grant SELECT, INSERT, UPDATE, and DELETE to all...
2012-10-10
13,001 reads
How to Make SQL Server Listen on Multiple Ports
Have you ever needed an instance of SQL Server to listen on multiple TCP/IP port numbers but didn't know how...
2012-10-05
1,177 reads
Use Powershell to Manage Idera SQL Diagnostic Manager
Idera SQL Diagnostic Manager (or as I call it "SQLdm") is a great monitoring and performance tuning tool that I...
2012-09-28
2,731 reads
Welcome to Everday SQL
My name is Patrick Keisler and I have been a Microsoft SQL Server DBA for over 12 years. During that...
2012-09-22
349 reads
Blogs
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
The PASS Data Community Summit 2025 Recap
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
Microsoft Post-Quantum Crypto APIs Are Now Generally Available
By Brian Kelley
I mentioned this in my talk on Quantum Computing at the PASS Data Community...
Forums
Find all the tables in a database containing particular column value
Hi, I want to find all the tables name under a database where tables...
The Ending Substring
Comments posted to this topic are about the item The Ending Substring
Done is Better than Good
Comments posted to this topic are about the item Done is Better than Good,...
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers