Using sys.objects When Scripting Permissions? You're Missing Something!
I suspect most DBAs have a script in their T-SQL toolbelt which scripts out database permissions for a specific user...
2014-02-04
1,105 reads
Blog Posts
Announcing the SQLpassion Performance Tuning Training Plan
You are a developer and/or DBA and want to learn in a very compact way the essential things about performance...
2014-02-03
1,073 reads
Blockades and ladders to learning new tech
It’s been a long time since I’ve been a true newbie to a technology. There are plenty of things I...
2014-02-03
580 reads
Cumulative Update – 15 for SQL Server 2008 Service Pack 3 Is Now Available !
The 15th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft...
2014-02-03
751 reads
Cumulative Update – 8 for SQL Server 2012 Service Pack 1 Is Now Available !
The 8th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 8 contains all...
2014-02-03
1,216 reads
Eight Essential Questions for Every Corporate Innovator
Reflect before you leap into action.
from HBR.org http://ift.tt/1behXS1
via IFTTT
2014-02-03
270 reads
HBR’s 10 Must Reads: The Essentials
If you read nothing else, read these 10 articles from HBR’s most influential authors: 1) “Meeting the Challenge of Disruptive...
2014-02-03
363 reads
Installing VMware vCenter 5.5 on Windows Server 2012R2
Recently I encountered a small glitch while trying to install VMware’s vCenter 5.5.0b Server on a new VM with Windows...
2014-02-03
1,310 reads
Last Weeks Top “Reading” Links #69
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-02-03
1,087 reads
Negative session_ids
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right?...
2014-02-03 (first published: 2014-01-27)
2,171 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