Memory
Not a sound from the pavement
Have you ever come across a SQL query that used to run faster? Has that...
2010-08-25
3,416 reads
Blog Posts
Mission Accomplished... Well sort of..
Did you ever set a goal and then sort of … demolish it without realizing it?
That has happened this year....
2010-08-25
358 reads
PASS Elections Portal
I think the shirt says it all
If you’ve been under a rock the last few weeks you may not know...
2010-08-25
526 reads
SFSSUG - Great Upcoming Speakers
Hey Folks,
We have some great speakers coming up at the SFSSUG in South Florida. Check out Devin Knight here talking...
2010-08-25
670 reads
SQL Pass Voting forum
So far I have seen lots of blogs about SQLPASS regarding the Slate for this years BoD. I do not...
2010-08-25
709 reads
You Don’t Need Log Backups
You don’t need log backups. You don’t. They aren’t required for SQL Server to function.
The place when you don’t need...
2010-08-25
744 reads
10 Character Traits of Outstanding DBA’s
What are the character traits of outstanding SQL Server Database Administrators (DBA) ?
You know what I’m talking about. There are...
2010-08-24
975 reads
Audio Proofreading & Writing Quality
Funny how if take time for longer conversations, ones that ramble, you often learn interesting things that you just wouldn’t...
2010-08-24
1,046 reads
Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series. Today we get to...
2010-08-24
1,665 reads
Find Tables and Columns by Data Type
A couple weeks back someone asked me some questions about data types. Apparently, while implementing some financial data, each developer...
2010-08-24
769 reads
Blogs
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...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
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