Some Data Compression Commands for SQL Server 2008 and 2008 R2
One of the more interesting and valuable features in SQL Server 2008 R2 Enterprise Edition (and Datacenter Edition) is data...
2010-05-17
1,238 reads
Blog Posts
The Journeyman Certification
There has been quite a debate going on at SQLServerCentral about a DBA journeyman certification. There are a couple good...
2010-05-17
963 reads
Two Speaking Engagements Coming Up: Next Monday in Burlington, Vermont & SQL Saturday #43 June 12th
Next Monday, I shall be driving the Smart down to Burlington, VT, again to visit Roman Rehak's Vermont SQL Server...
2010-05-17
640 reads
Introduction to Memory configuration
Introduction to Memory configuration Yesterday I was discussion with one of my friend on memory management and internals to expertise in...
2010-05-16
689 reads
SQL Server Reporting Services R2 - Publishing Report Parts
SQL Server Reporting Services R2 – Publishing Report Parts
SQL Server Reporting Services R2 (SSRS) allows report developers to not only publish...
2010-05-16
4,186 reads
Study Tips for the SQL MCM Exams
Study Tips for the SQL MCM Exams
I met the new rotation of the SQL Server Certified Master program on Friday....
2010-05-16
2,140 reads
Is Microsoft “years behind” in cloud apps?
Microsoft is associated almost exclusively with Windows and Office. Unfortunately a lot more...
2010-05-15
10 reads
Is Microsoft “years behind” in cloud apps?
Microsoft is associated almost exclusively with Windows and Office. Unfortunately a lot more innovation areas are not well known… Is Microsoft losing the cloud apps? Let me share with...
2010-05-15
6 reads
Mea Culpa: TweetRandomizer-gate
If you’ve ever read Spider-Man or spent any sort of time around the Marvel Universe (movies included) you’ll have no...
2010-05-15
651 reads
SQL Agent Visual Job Schedule Viewer
If you have experience with the SQL Server Agent you quickly realize the difficulty in managing job schedules. On a...
2010-05-15
4,766 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