Please please tell me now…
.. Is there something I should know, sang Duran Duran many moons ago when I was young and before I knew...
2014-08-15
398 reads
Blog Posts
Reblog: August 8 to August 14
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-08-15
708 reads
SQL Downgrades Made Easy
I was reading Kendra Little’s ( b | t ) post on SQL Server Edition Changes and it reminded me of the work...
2014-08-15 (first published: 2014-08-06)
8,853 reads
SQLSaturday Orlando Marketing Plan-Part 35
Quick update on registrations. We’re at 287 as of noon on August 15th, not bad. The blue part of the...
2014-08-15
516 reads
USING SQL & POWERSHELL – Different Methods to List Databases WITH Recovery Models
USING POWERSHELL TO LIST SQLSERVER USER DATABASES WITH RECOVERY MODELS
One of op requested to list all the user defined databases...
2014-08-15
1,319 reads
A Full Day of Query Tuning
I’m excited to able to say that I’ve been given the opportunity to put on a full day workshop at...
2014-08-14
804 reads
Announcing SQL Server Radio – English Edition!
About a year and a half ago, I approached Guy and asked him if he wanted to start a podcast...
2014-08-14
1,399 reads
AVG() function in SQL Server
Avg():- This function is used to get the average value of a numeric column
Syntax:-
SELECT AVG(column_name) FROM table_name
In this article,...
2014-08-14
879 reads
Effects of sp_rename on Stored Procedures
There comes a time when mistakes are made. Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure. When a mistake...
2014-08-14
14 reads
Export XML Columns to Individual Files
I was reading SqlServerCentral.com Articles Requested forum and saw this request.
Looking for an article that takes data from an XML...
2014-08-14 (first published: 2014-08-04)
9,467 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