SQL Server 2012 Developer Training Kit
The SQL Server 2012 Developer Training Kit has been updated with a bunch of new content (download it here). This...
2011-12-05
1,129 reads
Blog Posts
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
797 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
674 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
587 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
869 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
929 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,925 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,200 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
460 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,820 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers