MDX YTD Calculation Issus
If you are using the templates for MDX calculation built into SSAS 2008 you might run into some strange issues....
2013-09-30
1,253 reads
Blog Posts
MidnightSQL Server Evaluation script, version 1.0
Server evaluations are a major part of my consulting business. I need to get up to speed very quickly on...
2013-09-30
1,256 reads
Speaking Twice on Oct 1, 2013
Carolina Technology Conference:
To start things off, I'll be speaking in the morning at the Carolina Technology Conference. I have a...
2013-09-30
2,812 reads
SQL Saturday #190 Denver Wrap Up
I must admit… Denver is my favorite town in this country. The outdoor things to do, the wide variety of...
2013-09-30
1,265 reads
SQL Server :Part 1 : Architecture of Transaction Log
In our earlier post, we have discussed in detail about the architecture of the data file and different types of...
2013-09-30
10,014 reads
The MERGE statement doesn’t have a WHERE clause.
What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw...
2013-09-30
1,355 reads
SQL Server Statistics
INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....
2013-09-29
3,930 reads
Do you want me to tell you the truth or do you want me to tell you what you want to hear?
We live in a Dilbert age.
If you are a DBA and have worked in organizations of any size you are...
2013-09-28
1,723 reads
Houston Tech Fest 2013 - SQL Admin Best Practices with DMV's
Here is the downloadable file with all my sample scripts and slidedeck from my SQL Admin Best Practices with DMV's presentation from...
2013-09-28
1,043 reads
Strategizing your Index Maintenance in SQL Server
Index maintenance is part of the DBA’s life. Surely you have a maintenance task for this somewhere running daily or...
2013-09-28
1,258 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers