Guide to SQL Server Table Indexes (Part 1)
One of the most important tasks for every database administrator (DBA) is to ensure that query times are consistent with...
2013-07-15
1,391 reads
Blog Posts
Last Weeks Top “Reading” Links #41
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-07-15
616 reads
Microsoft SQL Server security best practices checklist
SQL Server is a repository of sensitive information for organizations, and that is why it is important to ensure that...
2013-07-15
3,424 reads
New Hebrew SQL Server Podcast
Five months ago, I wrote a post about my love for Podcasts.
At some point, I started to think about starting...
2013-07-15
1,083 reads
Ordering steps in a SQL Agent job
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...
2013-07-15 (first published: 2013-07-08)
2,203 reads
SQL Server – SELECTing/Displaying Top N rows from a table
To SELECT only top N rows from a table we can use TOP clause in SELECT statement. Using TOP clause...
2013-07-15
868 reads
SQL Server Database Backups and Recovery Models – (Part 2)
Checkout the part-2 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which you’ll learn...
2013-07-15
934 reads
SQL Server Database Backups and Recovery Models – (Part 3)
Checkout the part-3 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which I discussed...
2013-07-15
742 reads
SQL Server Needs Tempdb
I saw a post recently where someone noted they had moved tempdb like this:
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev,...
2013-07-15
1,205 reads
Understanding SQL Server Database Restore Process
Data is a critical asset for an organization to keep information about their customers, inventory, products, purchasing, and financial stocks....
2013-07-15
701 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers