Regular Audit Analysis
This Friday Steve Jones asks about how you handle audit data in your environment. Do you regularly analyze the data? Or do you wait for something to go wrong before you check the data.
2011-06-24
127 reads
Editorials
The Age of Software
Does the age of software matter? Steve Jones talks about this after there was a decision for the SQL 11 tools not to support Windows XP.
2011-06-23
261 reads
Excel in the Clouds
Today Steve Jones talks about a new use for cloud computing with Excel to analyze large sets of data.
2011-06-21
159 reads
Archiving
It seems that archival isn't on the mind of most designers when they first build a database, which is OK, but DBAs ought to be building skills to implement this if the data size grows large.
2011-06-20
737 reads
Patch Week
This week Steve Jones notes there were quite a few patches from Microsoft for a variety of products. No SQL Server specific security patches, but that doesn't mean that DBAs shouldn't be patching systems.
2011-06-20
135 reads
Multiple Failures
This Friday Steve Jones has a disaster recovery poll. When you have a true disaster, often there are multiple things that go wrong and cause a cascading failure. Is this common, let us know what your experience is this Friday.
2011-06-17
105 reads
Phrases that Resonate
Today we have a guest editorial from Andy Warren. Are there particular phrases that you use in technology that resonate with you and have particular meanings? Andy shares a few of his favorites.
2011-06-16
151 reads
Understanding Security
It is important for data professionals to understand security, but it's also important for end users that must handle data. However we have a lot of work to do to make that easier since Steve Jones thinks many IT pros struggle with this concept.
2011-06-15
281 reads
Etiquette
As technology has rapidly advanced our communications, we have not necessarily learned to deal with the implications and challenges of this anywhere, anytime communication reach. Steve Jones reminds us that etiquette matters, even when we are designing systems.
2011-06-14
216 reads
Cloud Outages
It seems that we regularly hear about outages from various cloud services. Steve Jones comments that we are likely to have this happen more and more, but it's shouldn't happen at a rate greater than in house IT services.
2011-06-13
151 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