There are times when you might want to read backup/restore history information to identify a backup’s start and finish date/time, the location where the backup was written, the size of the database backup, etc. Greg Larsen shows you how to do this in SQL Server.
2016-10-31
4,425 reads
Here is a reference that lets you take a quick look at the new features in SQL Server 2016 and dig into the various items with a collection of links we'll maintain.
2016-10-28 (first published: 2015-06-22)
14,425 reads
Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail
2016-10-28 (first published: 2015-07-28)
19,083 reads
Ahmad Yaseen explains how you can control the number of processors assigned to the SQL Server DBCC CHECKDB command in order to free-up the server's resources.
2016-10-28
3,392 reads
Preparing for SQL Server presentations is always a challenge. This article provides a few guidelines for the same
2016-10-27
2,417 reads
Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery. In choosing the best options, you need to accurately understand the value that the business places on the service you're running, long it will take for a secondary replica to be in synch with the primary replica, the importance of spreading the location of replicas widely, and the maximum tolerable unscheduled downtime. Just clicking all the options could prove to be expensive.
2016-10-27
3,361 reads
2016-10-26
121 reads
Arshad Ali discusses the different design considerations for leveraging the Real-time Operational Analytics feature of SQL Server 2016, covering the different scenarios where it fits or does not fit, and how to get started with it for disk based tables.
2016-10-26
3,511 reads
Sloppy terminology leads to big misunderstandings. Terms don't get much sloppier than "Unstructured data".
2016-10-25
589 reads
Learn how to generate Registered Servers with PowerShell in this article.
2016-10-25
5,462 reads
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,...
I’ve been doing storage load tests for SQL Server for a long time, both...
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...
Comments posted to this topic are about the item Half of All Engineers
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