SYS.PARTITIONS: Better Than X-Ray Vision
Originally posted 2011-09-09 21:27:00. Republished by Blog Post Promoter
Over the past few months, I’ve been doing a lot of work...
2013-11-19 (first published: 2013-11-09)
1,993 reads
Tracy McKibben
- Interests: Tech, gadgets, model railroading, photography, and of course SQL Server!
Automated Permissions Auditing With Powershell and T-SQL: Part 4
Previously, on REAL-SQL-Guy…
We were introduced to two SQL queries to obtain database login permissions, one for SQL Server 2000, one...
2013-11-18
1,048 reads
Superpowers Revealed
Like many of you out there, I’m constantly looking for new things to learn. A new skill, a new hobby,...
2013-11-16
414 reads
Friday Followup For November 15, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-15
472 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 3
In this episode, I’m going to start introducing some of the Powershell elements that tie this audit process together.
DISCLAIMER: I...
2013-11-14
3,525 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 2
In Part 1 of this series, I presented a T-SQL query that will return a summary of login permissions within...
2013-11-13
568 reads
The Cloud Is Scary – #TSQL2sDay #49
It’s T-SQL Tuesday time! I haven’t contributed in a while, so I really wanted to participate this time. The topic...
2013-11-12
641 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 1
A big part of my job is controlling security to multiple production databases, and reporting on that security for quarterly...
2013-11-11
1,036 reads
Building The Redneck Treadmill Desk
Don’t tell Brent Ozar, but here’s another DBA writing another helpful article about shrinkage. Before he gets bent out of...
2013-11-08 (first published: 2013-11-04)
3,965 reads
Friday Followup for November 8th, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-08
437 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers