Too Much Data
Are you managing too much data? Lots of data professionals feel that way, but fortunately "Big Data" is in the news and bringing more visibility to the challenges we face on a daily basis.
2012-11-13
182 reads
Editorial
The Data We Give Away
We're all used to storing and protecting data, but how often to we consider the data we're generating every day?
2012-11-12
73 reads
Monitoring is Essential
One of the keys to better availability, scalability, and performance on your systems is understanding what is happening in the instances. That requires monitoring, which Steve Jones sees as essential.
2012-11-12
280 reads
What Do You Want from SQL in the City?
After the SQL in the City tour wrapped up this week in Seattle, Steve Jones looks back and asks a question. What type of training would be best for you.
2012-11-09
137 reads
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
2012-11-08
211 reads
2012-11-01
115 reads
DBA Support
This Friday Steve Jones talks about your support load. Let us know how many databases you support and what the load is like.
2016-10-07 (first published: 2012-10-26)
247 reads
Two Steps Ahead
Today Steve Jones talks about those great DBAs, the Exceptional ones that do more than just respond to issues or set up monitoring on their systems.
2012-10-25
165 reads
A SQL Server Log Reader
There's a hole in the SQL Server platform. No log reader comes with the product and Steve Jones thinks Microsoft should build one and include it.
2012-10-24
413 reads
Walk on the Wild Side
Today Steve Jones talks about the differences between development and production and how it can be good to spend a little doing the other type of work.
2012-10-23
118 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