Learning Priorities
Steve Jones talks a bit about the value of learning for DBAs and other IT professionals.
2008-12-15
817 reads
Articles
Learning Priorities
Steve Jones talks a bit about the value of learning for DBAs and other IT professionals.
2008-12-15
1,040 reads
Learning Priorities
Steve Jones talks a bit about the value of learning for DBAs and other IT professionals.
2008-12-15
1,303 reads
SQL Server 2008 Sparse Columns Identifying Columns For Conversion
SQL Server 2008 has introduced a new way to store data for columns that contain excessive NULL values called Sparse Columns. What this means is that when you declare a column as Sparse and any time a NULL value is entered in the column it will not use any space. Is there a way to identify what columns would make a good candidate for this without having to analyze each column individually?
2008-12-15
2,633 reads
SQL Server virtualization pros and cons
Virtualizing SQL Server has pros and cons. Learn the performance impacts of virtualization on SQL Server I/O, RAM and memory to decide if it is a fit for your SQL Server system.
2008-12-15
4,829 reads
SQLSaturday #10 - Tampa 2009
Looking for free SQL Server training?
Join over 250 SQL Server professionals in Tampa on January 24th, 2009 for SQL Saturday #10. Featuring 6 tracks and more than 36 SQL Server presentations, it's the biggest and best free SQL event available. Visit www.sqlsaturday.com to see event details and to register.
2008-12-15
1,196 reads
Simple Metadata
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
2008-12-14
867 reads
Simple Metadata
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
2008-12-14
919 reads
Simple Metadata
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
2008-12-14
874 reads
Career Challenges - Database Weekly (Dec 15, 2008)
This week Steve Jones sees a lot of people talking about challenges in their career.
2008-12-13
578 reads
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.[key]
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers