Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about that, there were months where I barely managed to...
2017-01-03
3 reads
Blog Posts
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
497 reads
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
159 reads
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
578 reads
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,924 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
7 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
189 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
445 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,284 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
494 reads
Blogs
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Deleting data in large table
I have a large table with 17M+ rows for our package record audits. I've...
ETL Framework In Production
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...