I'm Speaking at SQLLunch
I am excited to be speaking at SQLLunch.com on March 1st. SQL Lunch is a great website event where Host...
2010-02-21
349 reads
Microsoft AdCenter and SQL Server Analysis Services 2008
There is a recently published whitepaper that talks about Microsoft AdCenter using SSAS 2008 to accelerate performance over 2005. Most...
2010-02-21
529 reads
Disk Partition Alignment
This whitepaper from Greg Lowe talks about the important strategy behind disk partition alignment. This is focused mainly in SQL...
2010-02-21
534 reads
Data Type Precedence and Implicit Conversions
In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that...
2010-02-21
4,523 reads
Modifying SQL in a Lookup Transform
Oftentimes you need to make a more advanced join that the default LookUp Transform will allow. The challenge is when...
2010-02-20
356 reads
Selecting Top N Rows from Excel Source
Excel is a significant source of data in most enterprises. Therefore there is a large amount of Excel work being...
2010-02-20
274 reads
SSAS Query Processing and Performance Tuning
Any of us can work with some simple MDX queries and get them to do what we want, but in...
2010-02-20
298 reads
Testing Security in SSAS
Security in SSAS is a simple yet powerful application of windows integrated security. MDX adds extra power to this by...
2010-02-20
339 reads
Quotes in Calculation Tab
A quick clarification on something I said the other day to a group of students in one of our quick...
2010-02-20
221 reads
I’m Speaking at the SSWUG VConference in April
Hey All ! I wanted to let you know I will be speaking at the SSWUG Virtual Conference this Spring. This...
2010-02-20
221 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers