The SQL Rally Pre Conference Seminars
There’s a change in how pre-conference seminars are being picked for the SQL Rally event next year in Orlando, FL....
2010-10-26
1,073 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Remote Security
As more and more people look to work away from inside traditional networks, security becomes an issue. As a data professional, Steve Jones reminds you to be sure that your data is protected.
2010-10-25
111 reads
SQL Slammer
It's been seven years since SQL Slammer, the worst SQL Server security worm struck. Steve Jones remembers that time.
2010-10-25
181 reads
T-SQL Tuesday Topics
I was asked to host a T-SQL Tuesday, and I accepted.
Once again, my fingers move a bit faster than...
2010-10-25
731 reads
New Looks
It’s been quite a few years since I updated the Hawaiian shirt wardrobe. I bought a series of 5 shirts...
2010-10-22
724 reads
SQL Saturday Advice - Extra Food
No matter whether you provide the food or have people pay for it, it seems that at every SQL Saturday...
2010-10-21
685 reads
Boulder SQL Server User’s Group - Common SQL Server Mistakes
The first iteration of my presentation on Common SQL Server Mistakes, based on the various things I’ve seen in the...
2010-10-20
988 reads
Common SQL Server – Not Indexing FKs
This series looks at Common SQL Server mistakes that I see many people making in SQL Server.
Foreign Keys
It’s way too...
2010-10-20
1,310 reads
Plan for Capacity
It is important that you are monitoring your system to handle the capacity increases as it grows. Steve Jones notes that FourSquare recently had to deal with this.
2010-10-20
365 reads
Database Mirroring Connection Strings - Automatic Failover
I saw a post recently from Hugo Shebbeare that reminded me of something that I’ve seen asked often on the...
2010-10-19
7,610 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