How to Measure IO Latency for Database Files in SQL Server
In order to get information about the amounts of PHYSICAL reads we perform on database files, SQL Server exposes a...
2015-04-08
1,362 reads
Can Log Shipping Work Without Shipping the Log?
When you configure log shipping, there are 4 SQL Server Agent jobs that are set up:
Backup: Performs a backup log...
2015-04-02 (first published: 2015-03-30)
6,891 reads
SQLRally and SQLBits Slides and Demos
It’s been a great a busy week.
On Wednesday, I presented my session, “Query Progress Tracking in SQL Server” at SQLRally...
2015-03-06
602 reads
How to Fix Latch Problems when Working with Ascending Keys in SQL Server
Traditionally, we want our Clustered Index to have the following attributes:
Narrow: So that our clustered index and the non-clustered indexes that point...
2015-03-03
666 reads
Speaking at SQLBits and SQLRally
Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and...
2015-02-24
456 reads
The Data Loading Performance Presentation
This Monday, at SQLSaturday Israel, I presented my new session, “The Data Loading Performance Presentation”.
I worked on the session a...
2015-01-21
552 reads
What to Expect When Transitioning from DBA to Consultant
Last week, Boris Hristov (b|t), the organizer of #SQLHangout, invited William Durkin (b|t) and me to a SQL Hangout about transitioning...
2015-01-15
543 reads
Things I Learned in 2014
2015 is here!
Last year I wrote about what I had learned in 2013, and I try to make it a...
2015-01-06
756 reads
Rebuilding and Reorganizing Clustered Columnstore Indexes
Clustered Columnstore Indexes, as well as “regular” indexes, support the Rebuild and Reorganize operations. However, the meaning of those operations...
2014-12-16 (first published: 2014-12-11)
6,753 reads
Tracking Progress of SQL Server Index Builds and Rebuilds
Let’s say you build or rebuild an index in SQL Server. Your users and boss are anxious to know when...
2014-11-11 (first published: 2014-11-06)
8,373 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers