HP Netbook Mini 1030NR
It was not what I expected. When I was leaving for a run this morning, I decided to apply an...
2009-07-01
1,320 reads
Blog Posts
Powershell SQL Server Backup/Restore
I posted a script on Poshcode for doing backups and restores of SQL Server databases using SMO. The script is...
2009-07-01
2,147 reads
Stack Overflow, Server Fault, and SSC
Steve Jones sent me a link to a presentation Joel Spolsky did at Google about Stack Overflow (SO) and it’s...
2009-07-01
766 reads
The Best Thing I Learned At PASS
Note: I'm writing this as part of the "Best Thing I Learned At PASS" contest. Why? Because if I win...
2009-07-01
753 reads
Transaction Rollbacks with Identity Values
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your...
2009-07-01
10,023 reads
Connector Editorial for July 1, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-30
1,516 reads
Querying the Procedural Cache on Canada Day (July 1st)
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources...
2009-06-30
2,444 reads
SSIS - Creating a Deployment Manifest
Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a...
2009-06-30
42,024 reads
Tracking My Goals – Half the Year
I made a series of resolutions in January related to SQLServerCentral. These are things that I wanted to accomplish this...
2009-06-30
1,728 reads
Unwired for Days
Today is the first day that I've really had any significant time on the computer over vacation. That probably sounds...
2009-06-30
1,380 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
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,...
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