SQL backup directly to Azure storage
Most companies required to keep their database backup offsite (on tape) for many years due to audit requirement. This normally...
2015-03-12
965 reads
Dennis's SQL Blog
Future of Database Mirroring
One of the beloved feature of SQL server standard edition for HA is database mirroring, since you only have 2-node...
2015-03-12
485 reads
2015 - the year of upgrade
2015 should be a very busy year for most DBAs, due to the end of support of SQL server 2005...
2015-02-06
318 reads
Mentor blog
I have been following a few blogs for a number of years now, and one of the most enjoying blog...
2015-02-02
288 reads
Memory consideration (Windows + SQL)
We all know that with the latest Windows 2012 R2 and SQL 2014, even with the standard edition, it can...
2014-11-14
405 reads
DR drill - Part 1: General
Every DBA in their career should have done DR drill at some point, in fact it should be done in...
2014-09-18
2,433 reads
SQL Server licensing consideration
You might already read lots of post about SQL server 2012 is license per core rather then per socket and...
2014-04-07
515 reads
AlwaysOn Availability Groups Setting
Many of us are planning to move to SQL Server 2012 in the coming year, and one of the feature...
2014-04-01
328 reads
Checking Backup/Restore progress
Every now and then we all need to perform backup or restore, for large databases when we need to perform...
2013-10-09
612 reads
Installing SQL Server 2012 on Windows Server 2012
Everyone knows that installing SQL server requires .Net frameworks 3.5, and it normally install by default, when you run the...
2013-03-12
589 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
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