SQL Server 2012 (“Denali”) Licensing
Microsoft has posted the licensing for SQL Server 2012. It has simplified licensing: SQL Server 2012 will offer two licensing...
2011-12-02
1,511 reads
Blog Posts
System Reserved Partition and monitoring
On Windows 2008 R2 , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step...
2011-12-02
1,041 reads
With A Little Bit of Care, You Can Use the DMVs to Auto-Create Some Missing Indexes, Here Is How (but with Caveats)
An Automagic Index Creation Script? No, but a start to deal with Missing IndexesHere's the useful join from a number...
2011-12-02
2,014 reads
Workarounds for SSRS 2008 Font rendering issue
Problem
A report developed using SSRS 2008 either through Visual Studio 2010 or BIDS 2008 does not renders properly when viewed...
2011-12-02
5,974 reads
Database Mirroring In A Windows Workgroup
Database Mirroring is a popular high availability solution and low-cost alternative to clustering, especially for smaller shops who can't afford...
2011-12-01
4,761 reads
DBA in Space: Behind the Scenes—Question 9
This is a continuation of my DBA in Space journal.
Episode nine was filmed in the “Mars” exhibit. In this scene,...
2011-12-01
631 reads
December Question: When reflecting on this year, what has gone well, and what would you do differently?
December is the last month of the year, and is often a good time to reflect on the past year...
2011-12-01
1,179 reads
PASS Update #67
It’s been a slow few weeks since my last update. This week I did a call with Karla and Wes...
2011-12-01
433 reads
PASS Update #67 (Election)
Today the slate of candidates for the 2012-2013 term was announced;
Adam Jorgensen, Denise McInerney, Geoff Hiten, Kendal Van Dyke,...
2011-12-01
644 reads
Speaking in Colorado Springs
I’m probably going to have to put together a new SQL video, because I’ve been accepted to speak at SQL...
2011-12-01
566 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers