Indexes, Indexes, Indexes
This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.
TSQL Challenge 81 - Create a Game schedule generator in TSQL
This challenge is to generate a game scheduler based on the Teams given in a table.
Fix Failures Fast
A new study from Microsoft Research looks at failures in PCs. Steve Jones thinks there are a few things worth talking about for DBAs.
Generating Non-uniform Random Numbers with SQL
Some FUNCTIONs to help generate non-uniform random numbers from uniform random numbers including Normal, Multinomial, etc.
Email Job Failures Report to DBA using PowerShell
MySQL introduced its own brand of job scheduling, called Events, in version 5.1. However, some Database Administrators (DBAs) feel that it isn't quite ready for prime time. This article presents a hybrid solution that uses MySQL Event Scheduling to manage the batch jobs and Windows PowerShell for the error handling.
Security and Honesty
Today Steve Jones talks security and the need for us to share information about issues, especially those that impact security.
Using a PowerShell Script to delete old files for SQL Server
Many clients are using custom stored procedures or third party tools to backup databases in production environments instead of using database maintenance plans. One of the things that you need to do is to maintain the number of backup files that exist on disk, so you don't run out of disk space. There are several techniques for deleting old files, but in this tip I show how this can be done using PowerShell.
SQL Server 2012 - New Service Broker Features
SQL Server 2012 came with bells and whistles for service broker, that give you plenty reasons to start using service broker in your applications.
The High Availability Poll
Most customers and clients wants highly available systems, with 100% uptime if possible. However most don't want to pay for them, and eventually tolerate some outages to keep costs down. This Friday, Steve Jones asks what is your environment like.
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