2011-09-29 (first published: 2009-11-18)
10,463 reads
Articles
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.
2011-09-29
3,287 reads
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.
2011-09-28
11,852 reads
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.
2011-09-28
2,870 reads
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.
2011-09-27
4,645 reads
2011-09-27 (first published: 2009-10-28)
9,695 reads
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.
2011-09-27
3,984 reads
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.
2011-09-26
1,188 reads
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.
2011-09-26
3,888 reads
SQL Server Log Shipping For Large Databases
In this article you will see the detailed steps needed to implement the log shipping for large databases.
2011-09-23
2,889 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers