How do you configure where your database backups are created? Do you have problems updating all of your backup jobs if the backup location needs to change? See how you can make use of Windows settings and a few lines of simple TSQL to have total control over where you database backups are created.
2014-01-30
3,652 reads
SQL Saturday is coming to Tampa, Florida on February 22, 2014. SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This is a free event, so register early to secure your place.
2014-01-30
1,622 reads
Starting with SQL Server 2008, two different in-built mechanisms identify DML changes at the source table so that only changed data sets can be considered for data pulled from the source table to load into the data warehouse. These two in-built mechanisms are Change Data Capture (CDC) and Change Tracking (CT).
2014-01-29
6,448 reads
Learn how to post sample reports to the forums in order to get SSRS help
2014-01-28
2,512 reads
In this article, Gail Shaw looks at how you can identify common types of deadlock, the difference between a deadlock and severe blocking, and how to avoid and fix the most common deadlock types.
2014-01-28
5,395 reads
Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.
2014-01-27
2,944 reads
SQL Saturday is coming to Cleveland on February 8, 2014. Join us for a free day of SQL Server Training and Networking. There will also be paid-for pre-conference sessions on Feb 7 featuring Argenis Fernandez and Allen White.
2014-01-27
322 reads
SQL Server 2012 introduced the new project deployment model for Integration Services. This tip will guide you through the process of setting up security for the SSIS 2012 catalog.
2014-01-27
3,027 reads
Use SSRS to be create its own lightweight report version control system
2014-01-24 (first published: 2012-10-23)
26,977 reads
The sqliosim utility is provided with SQL Server to test the I/O stability and 'correctness' of a server. It is generally used before installing SQL Server in order to ensure that new hardware can handle your expected loads. Bob Sheldon explains what it is and how to use it.
2014-01-24
3,493 reads
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
I’ve been thinking a lot lately about what it actually takes to make an...
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Comments posted to this topic are about the item Finish the quote
Comments posted to this topic are about the item Everything I Needed to Know...
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers