SQL Server 2008 SP2 CTP Available
Microsoft has made the Community Technology Preview (CTP) of SQL Server 2008 SP2 available for download. This is Build 3798,...
2010-07-08
1,201 reads
Glenn Berry
Microsoft Assessment and Planning (MAP) Toolkit 5.0
I have been playing around with the new Microsoft Assessment and Planning (MAP) Toolkit 5.0 Beta 2 tool for the...
2010-07-07
801 reads
Electricity Conservation and Solar PV Power
Since I got my grid-tied solar PV system on my roof turned on almost two weeks ago, I have gotten...
2010-07-01
3,091 reads
How To Stay Current with SQL Server Cumulative Updates
Since the release of SQL Server 2005, Microsoft has been using what they call an Incremental Servicing Model for SQL...
2010-06-23
2,179 reads
Microsoft Releases SQL Server 2008 R2 RTM Cumulative Update 2
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 2 (CU2) today. It became available for download today, and...
2010-06-23
2,885 reads
Detecting and Reducing VLFs in SQL Server 2008/2008 R2 Transaction Log Files
One common, but often undetected issue that I see with SQL Server databases is a very high number of virtual...
2010-06-22
3,468 reads
Inverter Obsession, or Why I am Starting to Hate Clouds
After getting my new grid-tied solar PV system turned on and operational on June 18, 2010, I have become temporarily...
2010-06-21
765 reads
Promoted to TempDB by SQLRockstar
I noticed today that fellow SQL Server MVP Thomas LaRock (blog | twitter) had updated his SQL Server blog rankings, and...
2010-06-21
726 reads
3.15Kw Grid-Tied Solar PV System Online
I took a day off work so I could be here when Namaste Solar and IREA came out to my...
2010-06-18
867 reads
Teaching ICT 4462 – Transact SQL Programming at Denver University, University College
I will be teaching a special five week version of ICT 4462 – Transact SQL Programming at Denver University, University College...
2010-06-15
625 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...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
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;