SQL Server 2016 helps with Best Practices
In order for your SQL Server instance to run optimally, there are many SQL Server best practices that you need...
2017-08-03 (first published: 2017-07-19)
4,763 reads
A Discussion of SQL Server-Related Topics
Combating SQL Injection
Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common?...
2017-06-21
786 reads
Weaning yourself off of SQL Profiler (Part 2)
In a prior post, I shared a script that will take a running trace and show you the XE events...
2017-05-17
554 reads
Weaning yourself off of SQL Profiler (Part 1)
In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting...
2017-04-25 (first published: 2017-04-19)
3,303 reads
Automating DBCC DBTABLE – obtaining the disk Sector Size
I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of...
2017-04-04 (first published: 2017-03-22)
10,219 reads
Working with SQLSaturday SpeedPASSes
SQLSaturday SpeedPASSes
I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every...
2017-03-09
445 reads
Identifying a row’s physical location
While you may not need to worry about the physical location of a row very often, every so often the...
2017-03-08
497 reads
Automating DBCC PAGE – Part 3 (Is a Clustered Index physically sorted on disk?)
In several of my last few blog posts, I’ve shared several methods of getting internal information from a database by...
2017-02-22
410 reads
T-SQL Tuesday #87 – Beware the Shiny New Toys
Today is yet another T-SQL Tuesday – the monthly blogging party started by Adam Machanic (b|t) to get everyone in the...
2017-02-14
441 reads
Automating DBCC PAGE, part 2 – determining object names on pages
In a prior blog post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option....
2017-01-18
399 reads
Blogs
Unused Indexes in SQL Server: Find them, vet them, and drop them safely
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
T-SQL Tuesday #191 Round Up
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Come See Me at the PASS Data Community Summit
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Managing unused indexes
While doing some housekeeping activity on several old but large production databases, I come...
Cloud Performance Considerations
How important to SQL Server is the speed of the SSD and network latency?...
Question of the Day
Striped Backup File Limits
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers