That’s Actually A Duplicate Index
As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with...
2013-03-06
2,445 reads
Upgrading to SQL Server 2012?
Do you have any plans in place to upgrade to SQL Sever 2012 this year. We are now well into...
2013-03-06
1,058 reads
PowerShell Usage In DBA Work — Case Study 1 / 7
I have been blogged non-technical topics for too long and it is time for me to return to my favourite...
2013-03-06
978 reads
SQL Server Community World Tour with GeoFlow
When I started playing with GeoFlow, I just had to find a way to do something interesting with it. This...
2013-03-06
706 reads
The End of SQLRally in the US
I saw it in the Connector, but just had time to read the minutes to see what was behind the...
2013-03-06
863 reads
Picking a Conference Venue
I was reading about the American Association of Woodturners annual symposium that will be held in Tampa this year (and...
2013-03-05
641 reads
SQL Server 2012 on Microsoft Surface Pro
I received my long-awaited Microsoft Surface Pro 128GB yesterday! The first thing I did was to promptly install SQL Server...
2013-03-05
4,477 reads
Microsoft Data Explorer
Data Explorer (download), which I first mentioned in my blog about PASS Summit 2011 (SQL Server 2012 and other PASS...
2013-03-05
2,000 reads
Invitation to T-SQL Tuesday #040: File and Filegroup Wisdom
Hello and welcome to the third T-SQL Tuesday of 2013!
Over three years ago, Adam Machanic (Twitter) dreamed up the idea...
2013-03-05
658 reads
Remove Local Administrators SSAS Admin Access
Recently while changing some production security around on a new server I needed to modify the SQL Server Analysis Services...
2013-03-05
1,248 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers