Using SQL Management Objects to create and restore SQL Databases.
SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.
Automate Audit Requests
In this article TJay Belt describes a process to help respond to audit requests in a timely manner
In The Zone
Are you in the Zone at work? Can you find those times when you are amazingly productive? Tim Mitchell asks a question in this guest editorial.
In The Zone
Are you in the Zone at work? Can you find those times when you are amazingly productive? Tim Mitchell asks a question in this guest editorial.
In The Zone
Are you in the Zone at work? Can you find those times when you are amazingly productive? Tim Mitchell asks a question in this guest editorial.
Upgrade Active/Active cluster to SQL Server 2005
This case study describes upgrading to SQL Server 2005 and Windows 2003 Active/Active cluster from and provides upgrade option pros and cons for SQL Server high availability.
Dynamically Generate Folders for File Output using Variables in SSIS
This article describes how to use variables in SSIS to dynamically generate folders and file placement.
The Green Stuff
Money. It's part of the reason why we all work, though hopefully not all of it. Steve Jones comments a bit on financial matters.
Double Check
Steve Jones looks at the positive side of someone else doing your work when you're on vacation. There's an interesting benefit for the company.
Double Check
Steve Jones looks at the positive side of someone else doing your work when you're on vacation. There's an interesting benefit for the company.
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