1-Week to PASS Summit 2010 – After Hours
Final post for the countdown – a little later in the week than I wanted. Right now there is less than...
2010-11-05
609 reads
StrateSQL
Return of the Index Analysis Report
Let’s Anaylze An Index! Finally up to the last post of this series resurgence. Time to update the Index Analysis...
2010-11-04
1,138 reads
SQLServerPedia Award Nomination
I thought this week was going to be pretty low key. SQL Saturday 58 has wrapped up. The PASS Summit...
2010-11-04
978 reads
SQL Saturday 58 – It’s A Wrap! #sqlsat58
It’s Tuesday after PASSMN’s first SQL Saturday event in Minnesota. After a restful weekend, I’m finally starting to completely wind...
2010-11-03
447 reads
Why are DBA skills necessary? #TSQL2sDay
Time for another T-SQL Tuesday and this time I’ll finish my entry in time. This month we are talking about...
2010-11-02
773 reads
“Wear Your SQL Saturday Shirt Day”
Over the past year there have been a number of SQL Saturday events. These events have occurred across the country...
2010-11-01
873 reads
SQL Saturday 58 TODAY! #sqlsat58
Don’t forget the Minnesota SQL Saturday is TODAY. Obviously, this was written before today and I’m hoping to catch a...
2010-10-29
1,477 reads
Last Call for PASSMN Board of Directors
As I mentioned a couple weeks ago, we are looking for nominations for the 2011 PASSMN Board of Directors. PASSMN...
2010-10-28
493 reads
2-Weeks to PASS Summit 2010 Countdown
It’s getting down to brass tacks. There is now only 2 more weeks until the PASS Summit. There’ve been a...
2010-10-26
816 reads
SQL Saturday 58 This Week #sqlsat58
Don’t forget the Minnesota SQL Saturday is this Friday. Remember, we’re DIFFERENT and out event is on a Friday instead...
2010-10-25
574 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;