Reblog: May 3 to May 9
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-10
565 reads
StrateSQL
Presentation Materials “Discovering the Plan Cache” #SQLSat175
I’m a little late getting the information from my Fargo SQL Saturday session posted, titled ”Discovering the Plan Cache“. But it’s...
2013-05-07
514 reads
Webcast Presentation Materials: Introduction to SQL Server Security
Last Thursday, I delivered a presentation for Pragmatic WorksTraining on the T’s. The session for last week was Introduction to...
2013-05-07
648 reads
Last Weeks Top “Reading” Links #31
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-06
425 reads
May 2013 – Monthly SQL Server Checklist
It’s the start of the month of May, or at least the first Monday in May. Hopefully you aren’t nursing...
2013-05-06
685 reads
May the Fourth Be With You – Kindle Bonus!
It seems that with the Disney purchase of Star Wars this past year that May the Fourth is coming on...
2013-05-04
432 reads
A Replacement for DBCC IND in SQL Server 2012
Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles. Some...
2013-05-03 (first published: 2013-04-17)
3,197 reads
Reblog: April 26 to May 2
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-03
1,070 reads
Last Weeks Top “Reading” Links #30
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-29
1,328 reads
Restoring Azure SQL Database to a Local Server
In last week’s post, I talked about the steps required to backup a Azure SQL Database. That post leaves us...
2013-04-29 (first published: 2013-04-23)
6,536 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...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
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;