How to Setup Log Shipping for Multiple Databases
This article by Brian Davey describes how to setup log shipping for a large number of databases minimizing the number of jobs needed thus significantly reducing CPU and memory usage.
Data Mining Query Task in SQL Server Integration Services
One of the primary goals of business intelligence is to transform raw data into meaningful information, by combining its sources, discovering its dependencies and patterns, and using them to predict future trends.
Custom SSMS Shortcuts for ETL Developer. Part 2: Extended Properties
With the following technique, you can quickly read information stored in the extended properties of a SQL Server table.
Know when to hold 'em
It's time for the SQLServerCentral Party at PASS and Steve Jones talks about the event.
Find Last Restart of SQL Server
How can you tell when your SQL Server instance was last started? In this tip we look at various methods of how to get the start time for a SQL Server instance.
Probabilities and Disaster Recovery
Today Steve Jones talks about the probabilities of different types of disasters occurring in your enterprise. He reminds you that the effort spent on disaster recovery ought to be related to the cost of the disaster, and the risk of it actually occurring.
Where are all the MVBs?
Whereas there are plenty of experts prepared to help with the technology, few seem to come forward when the struggle is against the bureaucracy rather than a recalcitrant server. Where are all the SQL MVBs (Masters at Vanquishing Bureaucracy) when you need them!?
Come Visit the Tacoma SQL Server Users Group
A new user group is forming at the University of Washington in Tacoma, WA. Come to their next meeting on Sept 29th, 2011.
SQL Code Reuse: Teaching a Dog New Tricks
Developers, by every natural instinct and training, strive to make their code reusable and generic. Dissuading them from doing so, in certain circumstances, is akin to trying to persuade a dog not to fetch a stick.
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
Make your moments memorable with Fildena 200mg
Make your moments memorable with Fildena 200mg, a high-strength option designed to support men...
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