A Script A Day - Day 27 - Missing Database Backups
Today’s script is one I have used many times in the past to check for missing backups. The script will...
2012-02-29
3,481 reads
Blog Posts
AdventureWorks in SQL Server 2012 RC0
The sample databases for SQL Server 2012 haven’t been completely finalized, but I was able to find the latest version...
2012-02-29
1,936 reads
Azure is Down
I saw a note about an outage on Windows Azure, apparently one that’s been going on for seven hours. Once...
2012-02-29
1,747 reads
Download free eBook for SQL Server 2012
Microsoft has released one more free eBook, this time it is on SQL Server 2012. However, this is the second...
2012-02-29
3,573 reads
MERGE with OUTPUT clause
A few days back I was presented with a theoretical challenge, and now I thought I would share my solution...
2012-02-29 (first published: 2012-02-21)
9,079 reads
PASS SQLRally Dallas 2012 Pre-Con: How to Perform a SQL Server Health Check
If you are attending the PASS SQLRally this May in Dallas, I will be presenting a one day preconference session...
2012-02-29
2,518 reads
Script SQL Server Agent Jobs Using PowerShell
It’s that time of the month again, no not that one, it’s T-SQL Tuesday time and this weeks topic is...
2012-02-29
4,751 reads
SQL Server 2012 (“Denali”): Extended Events
Extended Events is a general event-handling system for performance monitoring that was introduced in SQL Server 2008. It has a highly scalable and highly configurable...
2012-02-29
2,701 reads
Statistics Enhancements in SQL Server 2012
Today I want to talk about Statistics Enhancements in SQL Server 2012. As you already
know SQL Server uses Statistic Objects...
2012-02-29
4,374 reads
Trello: An agile style kan-ban web app that really works
I am no different to many others where I am being asked to work on various projects concurrently and expected...
2012-02-29 (first published: 2012-02-27)
2,900 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers