Buckets for Disaster Recovery
Disaster recovery can be a huge project at any company. Considering the ways in which you build a plan that...
2011-10-26
1,330 reads
Blog Posts
Dimensional Modeling Financial Data in SSAS
Part 1 – Parent Child Hierarchies and Pseudo GL Accounts
This post is born out of some real life lessons that I...
2011-10-26
5,522 reads
I’m a winner!
Actually, I only submitted the winning entry; Denali CTP3 SQL Server 2012 is the real winner. After having a blog...
2011-10-26
810 reads
Miss TechEd Australia 2011? No problem, all videos are online
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the...
2011-10-26
852 reads
SQLInspireNYC - You can still REGISTER for FREE! - Embarcadero Give-a-way
You may have missed the big announcement yesterday on SQLServerCentral.com, that thanks to one of our great event sponsors, Red Gate, we...
2011-10-26
950 reads
SSAS – Deployment Wizard
The Analysis Services Deployment Wizard is an often under utilized but important tool when moving your OLAP database throughout your...
2011-10-26
7,396 reads
Watch those VARCHAR(MAX) columns, and ONLINE index rebuilds
G’day,
I’ve noted a few instances lately of cases where VARCHAR(MAX) columns have been used unnecessarily, when a small value (for a...
2011-10-26
14,361 reads
Import MS Best Practice Policies
Let’s take a look at how to import the Microsoft Best Practice Policies into your Policy Based Management Server. You...
2011-10-25
1,018 reads
Multiple query plans for the same query?
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into...
2011-10-25
13,713 reads
Seeing Yourself as Others Do
As life skills go one of the hardest is to see yourself as others do – they apply all kinds of...
2011-10-25
865 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers