XQuery for the Non-Expert – Nodes
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-20
943 reads
StrateSQL
XQuery for the Non-Expert – XMLNAMESPACE
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Let’s talk...
2010-11-19
938 reads
XQuery for the Non-Expert – Terminology
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
It’s time...
2010-11-18
801 reads
The SQL Server MCM Training Has Changed
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft...
2010-11-16
2,426 reads
PASSMN Meeting Today
Check us out today by either traveling down to Bloomington or jumping in and joining us online. Today Minnesota’s SQL...
2010-11-16
751 reads
SQLServerPedia Awards Winner
Thanks to all those that voted for my Index Black Ops blog series for the SQLServerPedia blog awards. I am...
2010-11-15
552 reads
David Dewitt at the PASS Summit
The PASS Summit is complete and we got what we asked for from David Dewitt. He spoke on the third...
2010-11-15
2,088 reads
PASSMN November Meeting This Week
The PASS Summit has past and now it ‘s time to mention that the November PASSMN meeting is coming up...
2010-11-15
520 reads
White Paper of Supportability Roadmaps
Last week, a new white paper was released that discusses supportability roadmaps for ISVs. The white paper is Testing and...
2010-11-09
673 reads
PASSMN 2011 Board of Directors
For the third year in a row, we’ve had a blockbuster PASSMN Board of Directors election. By that, I mean...
2010-11-05
607 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;