The Next Generation DBA
DBA, database developer, analyst, SQL grunt, or whatever your title may be, there is no question that your role will...
2008-12-02
794 reads
Tim Mitchell
[Off Topic] Web host is down
For my colleagues and friend who visit my websites (www.bucketofbits.com, www.tyleris.com, www.timmitchell.net), I just discovered that my web host has...
2008-12-01
793 reads
Microsoft Certified Master program – Is This The Answer to Certification Woes?
In the past few years, many people - myself included - have expressed a desire to see the quality of the Microsoft...
2008-11-29
1,709 reads
Does regulation make data any safer?
Working with healthcare organizations, I am constantly aware of the restrictions my staff and I must abide by according to HIPAA constraints. ...
2008-11-27
1,669 reads
Raising the Bar
Turning up the heat. Take it up a notch. Stepping up to the plate. Less talk, more action.
However you choose...
2008-11-24
1,636 reads
Immersed in work, and missing out on everything else
After 2 years working on a data conversion and software implementation project, I’ve finally started to get caught up on...
2008-11-24
1,663 reads
Vista, Day 5
I broke down and bought my first Vista machine last Sunday, an HP Pavilion from a local box store. From...
2008-11-21
599 reads
SMO Videos on JumpStartTV.com
Last month I got to head out to Orlando and spend a couple of days with Andy Warren and the...
2008-09-28
1,670 reads
Data Quality, Part 1: The Discovery
I wrote a post a few months back about a healthcare data conversion project that I’ve been working on for...
2008-09-28
1,963 reads
Defining Value
I've been thinking a lot lately about the concept of value. Earlier this week a colleague of mine tendered his...
2008-08-29
1,458 reads
Blogs
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...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Creating JSON I
Comments posted to this topic are about the item Creating JSON I
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers