A Rickety Stairway to SQL Server Data Mining, Algorithm 2: Linear Regression
An algorithm that starts with the word “regression” seems an unlikely candidate to move forward with this series of self-tutorials...
2013-01-08
4,421 reads
Blog Posts
Day 5 of 31 Days of Disaster Recovery: Dealing With Corruption in a Nonclustered Index
31 Days of Disaster Recovery
Welcome to day 5 of my series on disaster recovery. I want to start digging...
2013-01-08 (first published: 2013-01-06)
3,146 reads
Day 7 of 31 Days of Disaster Recovery: Writing SLAs for Disaster Recover
Day 7 of 31 Days of Disaster Recovery: Writing SLAs for Disaster Recovery
31 Days of Disaster Recovery
Today is day...
2013-01-08
1,565 reads
Day 8 of 31 Days of Disaster Recovery (T-SQL Tuesday #38): Resolutions for All DBAs
T-SQL Tuesday #38
This post is not only day 7 of my 31 Days of Disaster Recovery series, it is...
2013-01-08
1,345 reads
Fast Starts
We are barely under way with the New Year and it is shaping up to be a busier year already....
2013-01-08
992 reads
Fast Starts
We are barely under way with the New Year and it is shaping up to be a busier year already. Not quite as busy as has been published by...
2013-01-08
1 reads
How crawl works in SharePoint || How indexing work || Basic Concept
Hey Friends,
Today I am here with some concept task . How a search work in SharePoint, but for a search to...
2013-01-08
572 reads
Index Analysis Update – January 2012
In the past couple weeks, I’ve gotten a couple reports of issues with sp_indexanalysis. The update today fixes those issues....
2013-01-08
749 reads
Master Data Management (MDM) Hub Architecture
The Master Data Management (MDM) hub is a database with the software to manage the master data that is stored in...
2013-01-08
8,792 reads
Partitioning Relational Data – (Part – 1)
A common requirement for dealing with large datasets is the ability to split the data into smaller blocks to help...
2013-01-08
1,015 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers