Using a SSRS Report to run SQL Agent Jobs
Data Warehouse latency is often a complaint I have heard from end users when trying to access data via either...
2009-11-11
6,596 reads
Blog Posts
And the Winner is........
DB Audit Challenge #1
And the Winner is….
First, I want to thank everyone that participated in the DB Audit Challenge, and...
2009-11-10
814 reads
Article of the Week – Sanjay Mirsha (Data Compression)
Data Compression was introduced in SQL Server 2008. This feature helps compress data inside the database, thus potentially reducing the...
2009-11-10
722 reads
Looking Back – PASS Summit 2009 Day 2
Tuesday started early for me because I had to be at the bloggers table in time for the opening remarks...
2009-11-10
638 reads
PASS Summit 2009 – Overall Event
I thought that we got a great Summit from PASS in 2009. This week I’ll be looking back at some...
2009-11-10
699 reads
SQL Connections
I’m flying off to the SQL Server Magazine Connections part of DevConnections in Las Vegas later this afternoon. I’m presenting...
2009-11-10
560 reads
SQL Server MVP Deep Dives Book Signing at PASS
The PASS Community Summit is one of the highlights of my professional year. It’s a time when members of the...
2009-11-10
387 reads
SQL Server Wish: Last Logon Information
The other day my wife and I were driving around and noticed that a Little Caesar's location had shown up...
2009-11-10
8,739 reads
Time Management Quotes
A short post today, ran across http://www.lifeoptimizer.org/2007/03/08/66-best-quotes-on-time-management/ when I was looking for ideas for my Moo cards. Quotes are fun...
2009-11-10
489 reads
Closing Out PASS Summit 2009
I was up early again on Friday morning to have breakfast with Patrick Leblanc (SQLLunch man), and then off to...
2009-11-09
623 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers