A SQL Server Hardware Nugget A Day – Day 2
For Day 2 of this blog series, I am going to talk a little about the upcoming Intel Westmere-EX processor...
2011-04-02
538 reads
Glenn Berry
Intel Sandy Bridge Mobile Processors Explained
The long wait for the new, mobile Sandy Bridge processor equipped laptops is nearly over. Most of the large system...
2011-03-24
1,107 reads
Presenting To Columbus SQL Server User’s Group on April 14
I will be doing a live, virtual presentation for the Columbus, Ohio SQL Server User’s Group on Thursday, April 14....
2011-03-23
784 reads
Microsoft System Center Advisor (Release Candidate)
Microsoft’s Brad Anderson announced the availability of the Release Candidate of Microsoft System Center Advisor today in his keynote presentation...
2011-03-22
1,495 reads
SQL Server 2005 SP3 Cumulative Update #15
Microsoft has released SQL Server 2005 SP3 Cumulative Update 15, which is Build 9.0.4325. There are only six fixes included...
2011-03-22
679 reads
SQL Server 2005 SP4 Cumulative Update 3
Microsoft has released SQL Server 2005 SP4 Cumulative Update 3, which is Build 9.0.5266. There are only five fixes listed...
2011-03-22
1,343 reads
SQL Server 2008 SP1 Cumulative Update 13
Microsoft has released SQL Server 2008 SP1 Cumulative Update 13, which is Build 10.00.2816.00. I count twelve fixes listed in...
2011-03-22
550 reads
SQL Server 2008 SP2 Cumulative Update 3
Microsoft has released SQL Server 2008 SP2 Cumulative Update 3, which is Build 10.00.4279.00. I count 25 fixes listed in...
2011-03-22
1,231 reads
Are You Taking Advantage of Twitter for SQL Server?
One thing I always do lately, whenever I give a presentation is ask the audience how many of them use...
2011-03-18
872 reads
Teaching Two Classes at University College–University of Denver
I will be teaching two classes for the Spring 2011 Quarter at University College – University of Denver. One will be...
2011-03-18
499 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;