The Worst Advice
We all try to help others with advice, but sometimes we end up doing damage. Steve Jones asks for the worst advice you see given in this Friday poll.
Instead of Trigger, Part 2 - SQL School Video
Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.
Turning Over Passwords
Would you disclose the password for your online sites to get a job? That was required of applicants in Bozeman, MT until recently. Steve Jones is stunned by this.
Create a Web-Based CRUD Automation Framework with Python
Implement a CRUD automation framework that handles insert and simple queries, an easy way to talk to a database without needing to write any database-access code.
Transaction Rollbacks with Identity Values
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your inserts and a no-deletion policy, you find that there are missing values in what should be an unbroken sequence of numbers. The problem could be partially related to transaction rollbacks.
Turning Over Passwords
Would you disclose the password for your online sites to get a job? That was required of applicants in Bozeman, MT until recently. Steve Jones is stunned by this.
Turning Over Passwords
Would you disclose the password for your online sites to get a job? That was required of applicants in Bozeman, MT until recently. Steve Jones is stunned by this.
Administering Securely
A common request is how can you secure SQL Server data and prevent the system administrator from viewing data. Steve Jones talks a little about the issue and how you can handle it.
The New Reality of an Audit Trail
With a continuation of his last article on auditing, Leo Peysakhovich enhances his solution to capture more details using XML.
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