SQL Server Database Mirroring (Not Dead Yet)
SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL...
2012-03-07
3,077 reads
Glenn Berry
CPU-Z 1.60 Released
Pretty much right on schedule, Frank Delattre has released CPU-Z 1.60, which has support for some new and upcoming processors...
2012-03-04
827 reads
What I Want For My Birthday
Dell has teased us with some images of their upcoming 12th Generation servers (that will support the Intel Sandy Bridge-EP...
2012-02-29
1,788 reads
SQL Server 2008/2008 R2 Diagnostic Queries for March 2012
Since it is nearly March, I will go ahead and jump the gun by a few days and post an...
2012-02-28
1,833 reads
New Cumulative Updates For SQL Server 2008 R2
On Feb 22, 2012, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 5, which is Build 10.50.2806. This CU...
2012-02-24
922 reads
Behemoth of the Server Room?
Back during the PASS 2011 Summit in Seattle, I was interviewed by Tony Davis, Andrew Clark, and Rodney Landrum about...
2012-02-10
858 reads
Behemoths of the server room: An interview with Glenn Berry
At the last PASS summit, we cornered SQL Server MVP Glenn Berry, and found out his views on the impact of virtualization, solid state disks and SAN administrators on the life of a DBA, and what led him to write a book all about SQL Server Hardware.
2012-02-10
1,783 reads
Building or Buying a Desktop Based Development and Test Database Server
Back in April of 2011, I wrote a post that compared the merits of using an ancient, but actual rack...
2012-02-06
1,395 reads
AMD 2012-2013 Server Roadmap
AMD had their 2012 Financial Analyst Day today, which is basically a dog and pony show for stock analysts.
Previously,...
2012-02-03
1,162 reads
January 2012 SQL Server 2008/2008 R2 Diagnostic Information Queries
Since Microsoft recently released a couple of new Cumulative Updates for SQL Server 2008, I thought it was finally time...
2012-01-23
1,164 reads
Blogs
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers