The Armor of Transparency
Yesterday I blogged about hosting a daily status meetings and some of the tricks I use to make it work....
2012-02-27
646 reads
Blog Posts
How to remove new line character from string using SQL ?
In a varchar column some of the entries were showing space in the left side and even after using the...
2012-02-26
9,155 reads
SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 Replication Magic
Session files are now available for download. The zip file...
2012-02-26
917 reads
SQL Saturday 108 in Redmond was a great success
Thanks to the organizers and volunteers for making SQL Saturday #108 an overwhelming success. I’m just wrapping up the day...
2012-02-26
737 reads
A Script A Day - Day 19 - Remove Virtual Subscriptions
Today’s script is to help replication performance. It was something I learned from my resident replication expert Paul Anderton. Below...
2012-02-25
3,471 reads
A Script A Day - Day 20 - User Database VLF Count
Today’s script will execute DBCC LOGINFO for all user databases. This is a script I use to monitor the number...
2012-02-25
2,637 reads
Powershell Get-EventLog and Event Log messages
This post explains how to list Event Log Messages with Powershell Get-EventLog , on multiple servers and output the results to...
2012-02-25
2,009 reads
How To Write an Interview Winning CV
Writing a CV that rocks is not an art. It just requires some planning and an understanding of what you...
2012-02-24 (first published: 2012-02-21)
3,606 reads
New Cumulative Updates For SQL Server 2008 R2
On Feb 22, 2012, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 5, which is Build 10.50.2806. This CU...
2012-02-24
930 reads
No MVP Summit for Me
On the corner of my rather messy desk is little recognition item in the image to the right. It’s a...
2012-02-24
851 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