T-SQL Tuesday 86: SQL Server Bugs & Enhancement Requests
Let’s kick off the new year with a T-SQL Tuesday! This month’s edition is hosted by Brent Ozar:
Announcing T-SQL Tuesday...
2017-01-10
476 reads
Blog Posts
Why Data Warehouse Projects Fail
Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among...
2017-01-10
1,099 reads
A Whole Day of PowerShell and SQL – Join Chrissy LeMaire & I at #sqlsatvienna
SQL Saturday Vienna 2017 is only just around the corner.
On Friday, January 20, 2017, a lot of local and international...
2017-01-09
404 reads
Disk Space Monitoring using SQL Server DMV
DMV : sys.dm_os_volume_stats
Being a SQL Server database administrator, you may often receive alerts or asked by Senior DBAs to check, if...
2017-01-09
17,691 reads
Forcing Parallelism – T-SQL Tuesday
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-01-09
556 reads
Getting Started Blogging–#SQLNewBlogger
It’s a new year, and the perfect time for you to start blogging about your SQL Server work. I think...
2017-01-09
730 reads
Monday Coffee 2017-01-09
I’m almost back into the swing of things now after the Xmas break, that holiday feeling has just about left...
2017-01-09
382 reads
Should We Allow Paid Sponsor Presentations at PASS Summit?
For many years the PASS Summit program committee has enforced a bright line rule – no sponsor content in the educational...
2017-01-09
492 reads
Starting with Chocolatey
I ran across Chocolatey years ago when Scott Hanselman wrote about it in his power tool list. At the time,...
2017-01-09 (first published: 2017-01-02)
3,213 reads
Moving to WordPress.com
For years I’ve hosted WordPress somewhere, most recently in Azure using Project Nami so that I could store all the...
2017-01-08
391 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