What’s your build number?
Without looking, name your most important server. Or if you have a bunch, name the top 2 or 3.
Now tell...
2011-12-04
937 reads
Blog Posts
Getting data and log size of all databases
Hi guys.
The procedure bellow get the data and log size of all databases in current instance.
CREATE PROCEDURE dbo.uspDatabaseSize
AS
declare...
2011-12-03
1,937 reads
Installing SQL Server 2012 Release Candidate 0
In my last post, I indicated that my plan was to post by Dec. 3 on the topic of data...
2011-12-03
2,222 reads
“Beyond Rounded Corners” at the Microsoft BI User Group of Minnesota-Dec 6, 2011
Come join me and other Business Intelligence professionals at the Microsoft BI User Group meeting at Microsoft’s new offices in...
2011-12-02
463 reads
Autogrow guidelines
I always enable autogrow on my databases. However, it’s there for emergencies, not as a space management tool. I monitor...
2011-12-02
5,827 reads
DBA in Space: Behind the Scenes—Question 10
This is a continuation of my DBA in Space journal.
Alien Brad is not looking very well (more boils), or very...
2011-12-02
862 reads
MythBusting–“Table variables have no statistics”
Ok, as myths go, its a pretty weak one. In fact, it is true, this whitepaper explicitly states that. But...
2011-12-02
3,076 reads
Now to End of Year
My friend Steve Jones posted Shutting Down for a Week and in that he talked about doing too much, trying...
2011-12-02
759 reads
Re-blog – November 25 – December 1
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer...
2011-12-02
505 reads
SQL Server 2008 R2 Installation Step by Step Guide - Saving System Admins, DBAs, Developers and Support Technicians A Wee Bit O' Misery
I've uploaded to SkyDrive a complete step by step guide for a SQL Server 2008 R2 installation because I prefer...
2011-12-02
34,474 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