How Do I Identify Invalid or Unneeded Logins?
Introduction
I was looking at one of my servers and was caught off-guard by how many individual users had been granted...
2010-04-07
525 reads
Blog Posts
How Silly
Have you ever done anything that made you feel like a dunderhead? Maybe a little bone-headed, thick, numb-skullish?
Here is my...
2010-04-07
554 reads
New MSSQLTips Article: Nesting Database Roles in SQL Server
I'm still way behind on my writing for the year, thanks to fighting off stronger than usual migraines and now...
2010-04-07
1,670 reads
SQLSaturday Orlando 2010 - The Planning Begins
Believe it or not, it's already time to start planning for Orlando's next SQLSaturday. Andy Warren and I had our...
2010-04-07
428 reads
Test Driving a LinkedIn Poll
Had this on my list for a while, thinking maybe it’s a way to leverage the investment in my (your)...
2010-04-07
257 reads
Use a Clustered Index
I stumbled across this clustered index test from Hugo Kornelis recently from a post in the forums. I think I’d...
2010-04-07
537 reads
24 Hours of PASS Registration Now Open
Registration for the 24 Hours of PASS is now open. This free, online training event will be held starting 12:00...
2010-04-06
649 reads
24 Hours of PASS v2.0
The kids over at the Professional Association of SQL Server Users have done it again. They’re hosting 24 Hours of...
2010-04-06
712 reads
24 Hours of PASS: Celebrating SQL Server 2008 R2
Well, we finally got the ok to start talking about the second 24 Hours of PASS event, called 24 Hours...
2010-04-06
572 reads
A DMV a Day – Day 6
The DMV for Day 6 is sys.dm_db_index_usage_stats, which is described by BOL as:
Returns counts of different types of index operations...
2010-04-06
854 reads
Blogs
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...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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