What’s In Your (Junk) Drawers?
Today we have a guest editorial from Andy Warren. Andy talks today about he various items that collect around your work space. Are they useful? should you be cleaning things up? What does this say about you?
Debugging Data Flow in SQL Server Integration Services
You can save a lot of time by using the SSIS Troubleshooting tools. These enable you to work with reduced data samples, monitor row counts, use data viewers, configure error-handling and monitoring package execution. Although you can develop SSIS packages without them, it is so much easier once you're familiar with these tools.
Bits Bound
Steve Jones talks about his trip to SQL Bits 9: Query Across the Mersey, which begins today.
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.
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers