Thanks for joining us at the Spring Houston Tech Fest 2018
Congrats to Michael, Eric, John, all the organizers and volunteers, and all the speakers for a successful Spring Houston Tech Fest 2018. It was a pleasure for the wife...
2018-05-05
5 reads
Blog Posts
A rant about presentations
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a...
2018-05-04 (first published: 2018-04-24)
2,359 reads
Day 4: MySQL Architecture Continue…
MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL...
2018-05-04
276 reads
Friday Reading 2018-05-04
Phew, busy week. In the middle of updating presentations and making sure demos work!
Here’s a few of the articles...
2018-05-04
338 reads
Moving Birthdays with Data Masker
Data Masker for SQL Server is a fantastic product, and one that can reduce your attack surface area and exposure...
2018-05-04
1,115 reads
SQL Server: Database snapshots vs Database backups
In the article, we’ll walk through the concepts to understand database snapshots, and their benefits and limitations. This article will...
2018-05-04
2,292 reads
Watching the Sands of Suggestion in #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-05-04 (first published: 2018-04-24)
2,507 reads
Day 3: MySQL Architecture
Like other RDBMS MySQL also has similar architecture: Connection Layer/Application Layer Logical Layer (Processing) Storage Engine Layer (Physical) – special Connection...
2018-05-03
305 reads
dbachecks – Setting temporary configuration values
dbachecks has seen the light about two months ago. As I'm writing this blog post, the module counts with more...
2018-05-03 (first published: 2018-04-24)
1,972 reads
Setting Windows To Prefer IPv4 Over IPv6
This post is a bit different from my usual SQL Serer posts, I recently hit a problem where a legacy...
2018-05-03
339 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers