The End of Estimation - MP3
How interesting would it be to not have to guesstimate what size server to buy for your next application? Steve Jones may have found a way to help you.
The End of Estimation - WMV
How interesting would it be to not have to guesstimate what size server to buy for your next application? Steve Jones may have found a way to help you.
Data Driven Subscriptions for Reporting Services (2000 and 2005)
Reporting Services has proven to be one of the more useful subsystems of SQL Server. However the standard editions of both SQL Server 2000 and SQL Server 2005 have limitations with regard to the subscription features. Jason Selberg brings us an updated version of his
code for extending the subscription feature.
Reporting on Activity across Multiple Servers using SQL Backup and SQL Multi Script
Rodney Landrum presents a creative solution for dynamic reporting across all of his SQL Servers, based on use of Red Gate's SQL Backup and SQL Multi Script.
Measure TSQL Statement Performance
Every developer needs to ensure that each TSQL statement is optimized. This article will give you a few different ideas on how to identify slow running queries and provide you with some tips on monitor your query performance while you make iterative changes to each query to try and improve performance.
The In-House Expert - iPod
Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get consultants as needed? Steve Jones comments on the choices you might face as your career grows.
The In-House Expert - MP3
Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get consultants as needed? Steve Jones comments on the choices you might face as your career grows.
The In-House Expert - WMV
Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get consultants as needed? Steve Jones comments on the choices you might face as your career grows.
A Pay Raise
There's a shortage of IT workers, which should lead to a pay raise for some people. Steve Jones takes a look at some recent news about IT salaries.
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
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...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
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