Database Data and Log Size Info
Have you ever wanted or needed to get the data and log file size for all of the databases in...
2011-12-05
2,429 reads
WAN Optimization–Part 2
After installing the WAN optimization appliances on all of our main sites, we have liked what we’ve seen thus far....
2011-12-05
689 reads
Meme Monday - What I Want for Christmas from Microsoft
This Christmas if I could get one thing from Microsoft it would be recognition that DBA's are not developers. This...
2011-12-05
758 reads
Enable XA transactions for SQL Server
An XA transaction is a global transaction usually covering multiple resources.
Use the Microsoft SQL Server JDBC Driver to support the ...
2011-12-05
209,614 reads
What Every DBA Should Get For Christmas
What is a brilliant gift at Christmas for a DBA? I mean apart from having the day off…..
For those new...
2011-12-05
595 reads
Upgrading Denali CTP3 to SQL Server 2012 RC0
When I started looking into the upgrade path for this, I saw a couple of notes online about the fact...
2011-12-05
805 reads
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
946 reads
Scaling SQL Server – SQL Saturday #104 Precon
I will be presenting a day long preconference session on Scaling SQL Server for SQLSaturday #104 on Friday, January 6,...
2011-12-04
875 reads
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,951 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,237 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
BCA KCP Summarecon Mall Serpong Telp:0821°7555°651
Telp&Wa 628217555651 Down Town Walk, Summarecon Mal Serpong Unit DGF, Jl. Boulevard Raya Gading...
Alamat BCA KCP ITC BSD Telp:0821°8200°203
Telp&Wa 628218200203 Ruko ITC BSD, Jl. Pahlawan Seribu Blok R No. 41 & 42,...
Alamat BCA KCU ALAM SUTERA Telp:0821°8200°233
Telp&Wa 628218200233 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers