What Are You Afraid to Ask?
There are some questions that can’t necessarily be answered in a book or a training video. Those are often the...
2010-08-02
606 reads
MDX Puzzle #5
Writing YTD totals and Running totals using T-SQL can take a little effort. However, with MDX it's not too difficult. ...
2010-08-01
556 reads
A Milestone
I just passed 100,000 views on the blog. That’s from 400 posts over a period of time starting in March...
2010-08-01
665 reads
Moving to a New Blog Platform
Moving to a New Blog Platform
First, I want to say that having my blog on SQL Server Central has been...
2010-08-01
1,030 reads
Like a Phoenix rising from the ashes ...
NOTE: At least one project will be selected every week for the remainder of 2010. Like the Phoenix rising from...
2010-07-31
1,443 reads
MDX Puzzle #4 - Solution
This puzzle may not have been much of a challenge, but it introduced two new MDX concepts. I have to...
2010-07-30
1,573 reads
Making a Career Change of My Own
Making a Career Change of My Own
I commented about a month ago on the high profile career changes that seemed...
2010-07-30
2,495 reads
Presenting to the West Michigan SQL Server User Group / SQL PASS Chapter (Rescheduled)
Presenting to the West Michigan SQL Server User Group / SQL PASS Chapter (Rescheduled)
My presentation scheduled for earlier this week to...
2010-07-30
1,653 reads
DevLINK, Music City’s Own Technical Conference
To many, August represents the lazy dog days of summer when it’s too hot to even think about going outside....
2010-07-30
1,470 reads
Personal or Professional Ethics
Steve Jones had an interesting blog post the other day, Do as I Say, Not as I Do, and I...
2010-07-30
1,543 reads
Blogs
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers