Why wait statistics are important and how you can start collecting them now!
Why wait statistics are important and how you can start collecting them now!
Wait statistics have always been a very important...
2014-02-28
1,378 reads
Blog Posts
Challenges with Downgrading TFS 2010 from SQL Enterprise to SQL Standard Edition
I recently had the challenge of migrating an installation of Microsoft Team Foundation Server 2010 from a shared SQL Server...
2014-02-27 (first published: 2014-02-24)
2,895 reads
Data Architecture Virtual Group - Whiteboard Data Architecture Presentation
Thanks to all 130+ folks who joined, suffered my jokes and handwriting, and asked fantastic questions during my presentation to the...
2014-02-27
1,302 reads
Let’s Talk Query Tuning
I spend quite a bit of time writing about query tuning on this blog. I’ve written (re-written and am actively...
2014-02-27
1,282 reads
PowerShell – SSRS Inventory – Automatic – Excel File – EMAIL
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-27
2,047 reads
Security #Datachat on Twitter Tonight
Tonight, at 9 PM Eastern, I’ll be participating in a #datachat on SQL Server security. It’s sponsored by Confio (now...
2014-02-27
985 reads
Spring in Florida
The first sign of spring in Florida is the leaves falling from the oak trees. Tons of leaves, leaves everywhere,...
2014-02-27
1,049 reads
SQL Server sample databases
Here are some places on the web where you can find sample databases for SQL Server. It's nice to have...
2014-02-27
1,420 reads
Standard Deviations with CTE in SQL
I was working with a client recently getting the number of standard deviations a student was off the average number...
2014-02-27 (first published: 2014-02-24)
3,338 reads
Thinking with Data by Max Shron
DISCLAIMER
I recently enrolled myself in the O’Reilly Blogger Review program, which basically allows me to get one O’Reilly eBook for...
2014-02-27
1,191 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers