SQL Server – String_Escape function in SQL Server 2016
Hi friends, in SQL server 2016 another string function that introduced is String_Escape. This function can escape special characters within...
2016-07-10
1,521 reads
Blog Posts
AlwaysOn Availability Group Database Level Health Detection – SQL Server 2016
SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements...
2016-07-08 (first published: 2016-06-30)
7,195 reads
Converged virtual architectures and SQL Server licensing
Hyper-converged compute architectures, meaning clusters of physical servers with self-contained storage configured for a traditional SAN-less solution, are growing in...
2016-07-08
590 reads
Dallas, TX Fallen Officers Relief Fund
If you want to make a Donation to the Dallas, TX Fallen Officers Relief Fund, Please click this Link.
http://bluealert.us/
2016-07-08
391 reads
Influence Skills: Live from @LearningTree London Day 4
We've made it to the final day, day 4 of Learning Tree course 294 Influence Skills: Getting Results without Direct Authority.
Today...
2016-07-08
517 reads
Is Today Your Last Day Working With SQL?
Please entertain this thought for a moment – If today was your last day working with SQL how would you spend...
2016-07-08 (first published: 2016-06-29)
3,325 reads
Join me for a free SQL Performance webcast on July 14th!
With less than we week away, I can say that I’m really excited to reach more people in the community...
2016-07-08
392 reads
Microsoft SQL Server 2016 Certifications Announced
Hi friends, Microsoft has announced the release of three new SQL 2016 certifications, based on the different working database professional’s...
2016-07-08
803 reads
SQL Server Basic - Memory
For those of you who just started to manage SQL server might wonder why SQL server use so much memory....
2016-07-08
844 reads
5 More Power BI Tips
I’ve had this blog post in my mind to write for the past month or so and I’m finally just...
2016-07-07 (first published: 2016-06-29)
3,613 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
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
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:...
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