“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
464 reads
Blog Posts
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,829 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
866 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,077 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
764 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
508 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,483 reads
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,513 reads
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,047 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,024 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
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers