PASS Summit 2018 – Keynote Day 1 Live Blog
Today is the first full day of the PASS Summit in Seattle, Washington. This is the 20th year of the...
2018-11-07
309 reads
Tim Mitchell
Where Are Your Data Leaks?
It has been almost impossible to avoid reading about the numerous large-scale data breaches reported on a seemingly daily basis....
2018-10-02 (first published: 2018-09-25)
1,952 reads
Speaking at PASS Summit 2018
I am honored to have been selected to be a presenter at this year’s PASS Summit coming up this November....
2018-06-06
291 reads
Temp Tables in SSIS
Temp tables are very handy when you have the need to store and manipulate an interim result set during ETL...
2018-05-29
459 reads
Managing Business Logic
Encapsulating business logic into data movement and presentation is a critical part of a stable information management strategy. Too often,...
2018-05-17
299 reads
Trading Data For Convenience
If data is the new oil, then the web is the world’s biggest gas station. Every day a few billion people...
2018-05-08
268 reads
Using SQL Server Management Studio Projects
One of the most underutilized assets in SQL Server Management Studio is the SSMS project. Within Management Studio, one can...
2017-12-22
544 reads
A Business Lesson from an Oil Change
When I first moved to the city where I now live, I found an oil change place just a couple...
2017-12-21
383 reads
Making a Difference: Andy Warren
Since I started working as a data professional some 15 years ago, I’ve had an enjoyable and successful career. I...
2017-12-20
344 reads
Do You Really Need Real-Time?
It wasn’t so long ago that the first day of the month was the most common trigger event for updating...
2017-12-19
396 reads
Blogs
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...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
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
Expensive CPUs
Comments posted to this topic are about the item Expensive CPUs
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