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.
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.
Is the DBA Dead? Steve Jones scoffs at the notion put forth in an article and says we'll be using DBAs for a long time. He does, however, admit the role is changing.
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).
Learn how to post sample reports to the forums in order to get SSRS help
There hasn't been a service pack for SQL Server in a long time. Without knowing the plans for the future, Steve Jones asks you to express your own opinions.
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.
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.
Could you manage 20,000 databases? That's how many servers each person at Facebook has to manage in operations.
Phil factor warns against taking SQL Coding 'best-practices' too much at face value. They can, at best, assist in reviewing code, and at the worst they can prevent the developer from finding the best solution.
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
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