Checking DBCC CHECKDB
I hope you run consistency checks on your databases, if you are not currently doing this you probably will want to....
2017-01-03
582 reads
Blog Posts
Clustered Columnstore Index really hates Updates
First a little background. I’m working on a large fact table that behaves itself as a slowly changing type 2...
2017-01-03 (first published: 2016-12-23)
4,937 reads
Epic Life Quests
It is easy to get caught up in the daily details of life and not take the time to reflect on longer term goals and accomplishments.
Inspired by Brent Ozar...
2017-01-03
12 reads
Launching #TAPtips – Valuable Tips from Decades of Practice
Launching #TAPtips Blog Posts While forming Datalere, Carlos and I wanted to continue with our contributions to the Denver, Colorado...
2017-01-03
197 reads
My Interview published on Microsoft Technet Blog
Wish you a Happy New Year to all the readers and technical enthusiasts!!!
https://blogs.technet.microsoft.com/wikininjas/2017/01/02/interview-with-a-sql-server-expert-and-wiki-ninja-prashanth-jayaram/
My interview is published on the Microsoft Technet blog...
2017-01-03
451 reads
ReadyRoll Development
This is the sixth part in the series: SQL Server and Continuous Integration. This post will illustrate the power of ReadyRoll when...
2017-01-03 (first published: 2016-12-23)
1,293 reads
2016 – That was a Year :-)
Its the time of year for reflection and I have had the most amazing 2016, I am blessed that I love...
2017-01-02
501 reads
Grateful to have been a Microsoft MVP
A couple of weeks ago I received the disappointing but expected news that I wasn’t renewed as a Microsoft Data...
2017-01-02
441 reads
Make Your Application's Name Heard
Odds are, you’ve got more than one application or script accessing your database or SQL Server instance at any given time. You’re probably stacking them on a small number...
2017-01-02
9 reads
Microsoft Most Valuable Professional – Data Platform
Today, I’m proud to announce that I have been named a Microsoft MVP – Data Platform. This is an exceptional honor and I’m humbled to be included in this...
2017-01-02
19 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
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...
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