Being Careful with Power
It's good to be careful with your power consumption, especially as the power cost of computing continues to grow. However with your SQL Server, you don't want to be too careful, as Steve Jones notes.
2011-01-03
299 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
MVP 2011
I was awarded the MVP status from Microsoft for 2011 on Jan 1, 2011. This is my fourth consecutive award...
2011-01-03
1,276 reads
Enjoying the New Year
For the last Friday poll of the year, Steve Jones has a fun one. Add your input and give everyone an idea of how to spend the last part of this holiday season.
2010-12-31
65 reads
Quick MCM Prep Help
Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4...
2010-12-31
1,620 reads
Getting a Dedicated Admin Connection
Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need...
2010-12-31
1,433 reads
2010-12-31
2,424 reads
MCM Prep - VLF Allocations
I had heard that you could have too many VLFs in your transaction log, and it could cause performance issues....
2010-12-30
1,936 reads
The Year of the Community
Steve Jones looks back at 2010 and dubs it the year of the community. Join him for a look back at some events in the SQL Server world from 2010.
2010-12-30
94 reads
Looking Back at 2010–Goal Review
I had 8 goals for 2010, which I posted at the end of last year. That reminds me, I need...
2010-12-29
1,828 reads
Getting a Dedicated Admin Connection
Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need...
2010-12-28
1,201 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
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...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
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?
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