Book Review: Instant Creating Data Models with PowerPivot How-to
I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot...
2013-06-13
599 reads
Printing the Report Parameters on SSRS
I'm surprised there isn't an option in the Report Manager for allowing you to include on the print out of...
2013-06-17 (first published: 2013-06-13)
6,212 reads
Why should we upgrade off of SQL Server 2000?
A good many companies still have servers chugging along on SQL Server 2000 (or even, as some of us noted...
2013-06-13
905 reads
Update Your Audit Queries for SQL Server
I was working with an auditor today who is working through a system with an external audit agency. The external...
2013-06-13
2,136 reads
Virtual SQL Playground Adventure: Introduction
Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may...
2013-06-13
1,486 reads
xVelocity Columnstore Indexes in SQL Server 2012
With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in...
2013-06-12
1,436 reads
Centralized SSIS solution to monitor failed SQL Server Agent Jobs across the enterprise
SQL Server Agent Jobs are crucial to any SQL Server environment as they are created and scheduled to perform critical business...
2013-06-12
884 reads
SQL Server Transactions and Locking (Part 2)
Checkout the part-2 of my two part article series on SQL Server Transactions and Lockinghere, in which you will learn...
2013-06-12
598 reads
SQLCMD – Explicit and Implicit calls – Examples
The scripting variables can be defined explicitly by using the setvar command or implicitly by using the sqlcmd -v option....
2013-06-12
1,875 reads
SQL Server Database Backups and Recovery Models – (Part 1)
Whether caused by hardware failure, software errors or malicious actions, there is always a possibility of data loss. You should...
2013-06-12
700 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