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,565 reads
Blog Posts
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,540 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,651 reads
Schedule Announced for SQLSaturday #49 in Orlando
Our schedule for this year has 47 one hour sessions plus another 6 “mini” fifteen minute presentations, plus a separate...
2010-07-30
1,374 reads
SQL University – Other Capacity Issues
This is the final lecture this week at SQL University. We are covering the topic of capacity planning this week...
2010-07-30
2,657 reads
SSC Editorial: Becoming Highly Productive
This editorial is about the idea of being highly productive more than how to actually accomplish it. Most of us...
2010-07-30
1,396 reads
Ambiguities and the wild object.oriented brigades
--Whilst trying to design a more effective way of detecting dependencies in a SQL Server database, I was mulling over...
2010-07-29
2,031 reads
Checking Users AD Groups Using Windows CMD
Blog Title: Checking Users AD Groups Using Windows CMD
Depending on your role in the organization, there may be a time...
2010-07-29
3,982 reads
Commenting TSQL Scripts
If you have ever searched for “commenting in TSQL” scripts, I am sure that you’ve found hundreds or maybe even...
2010-07-29
1,773 reads
Finding Key Lookups In Cached Execution Plans
Ask anyone with performance tuning experience to list the most expensive operations in an execution plan and it's a safe...
2010-07-29
5,379 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers