High Availability Lingo
You have got to love the way the SQL Server team change the lingo in all of their high availability...
2012-08-13
1,098 reads
SQL Server 365
Cost Savings and Backup Compression
Let me set the scene, one of our internal IT SQL Servers which stores a whole host of performance metrics...
2012-08-08
1,834 reads
Database Tables
Today I was asked for "a list of all tables in all databases" on a particular instance of SQL Server. ...
2012-06-13
871 reads
Rebuilding System Databases
Today’s post is something I thought I would share as there is an awful lot of incorrect commands I have...
2012-04-02
805 reads
Why I don’t like maintenance plans
If you create a maintenance plan (SQL 9.0.3042) to backup databases and select All databases as below;
Then at some point...
2012-03-16
890 reads
How Resilient Is Your Recovery Plan?
In this modern age of technology DBA’s face an ever increasing demand from businesses; our databases must perform, be secure,...
2012-03-14
605 reads
A Script A Day Finished!
Well that's it, my "A Script A Day" series is finished. I hope you found the scripts I provided useful, I've used...
2012-03-03
568 reads
A Script A Day - Day 29 - The Importance of Being Idle
Today’s script is also one I used in my migration on Wednesday. It again uses string manipulation to generate a...
2012-03-02
518 reads
A Script A Day - Day 28 - String Manipulation
Today’s script is one that I used earlier this week. On Thursday I migrated a server from SQL Server 200...
2012-03-02
522 reads
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,476 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;