Reblog: April 19 to April 25
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-26
1,029 reads
StrateSQL
5 SQL Server White Papers Every DBA Should Read
There are countless sources for information on SQL Server available today. There are books, webcasts, conferences, and blogs. With all...
2013-04-25
842 reads
Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend
We are down to the last few days before first SQL Saturday in Fargo. It’s been some work pulling it...
2013-04-23
495 reads
Last Weeks Top “Reading” Links #29
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-22
1,013 reads
Staggering SQLIO Sessions Across Multiple Volumes
In a previous post, I discussed running SQLIO against multiple files. The purpose in using multiple files is being able...
2013-04-22 (first published: 2013-04-10)
2,001 reads
Reblog: April 12 to April 18
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-19
873 reads
Backing Up Azure SQL Database to the Cloud
When I first started working with Azure SQL Databases, I wasn’t sure what it would take to backup a database....
2013-04-18
1,790 reads
Last Weeks Top “Reading” Links #28
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-15
479 reads
Presentation Materials “Discovering the Plan Cache” #SQLSat211
Just got done with my morning session, titled ”Discovering the Plan Cache“, for SQL Saturday Chicago #211 and wanted to get...
2013-04-13
441 reads
Presentation Materials “What Are You Waiting For?” #SQLSat211
After lunch, I led the session “What Are You Waiting For?” at SQL Saturday Chicago #211. It was another well-received...
2013-04-13
512 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Automatically generate tabular model partitions
Hi. I hope someone can give some useful suggestions. My workplace have a suite...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;