Is C# Better?
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
2009-11-13
296 reads
Editorial
Consolidating Again and Again and Again
This editorial was originally published on November 12, 2009. It is being re-run as Steve is on holiday. Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2014-11-25 (first published: 2009-11-12)
236 reads
A Better Way To Install Updates
The decisions to install service packs and cumulative updates is often confusing to new DBAs. Many of them install every update, often without a good reason. Steve Jones asks why we might not have a better way to install updates, maybe even helping us decide if we need them.
2009-11-11
128 reads
Is Unit Testing Important?
Testing our applications is important, but at what level do we need to test? Steve Jones talks about unit testing today, and wonders if this is prevalent for SQL Server developers.
2014-03-24 (first published: 2009-11-10)
522 reads
A Bad Litmus Test
A litmus test is a way of determining your answer to a question based on a single issue or response. Steve Jones sees this as a bad idea, especially when looking to hire technical people.
2009-11-09
337 reads
#SQLPASS on Twitter
With the PASS Summit taking place last week in Seattle, Steve Jones found that there was a tremendous amount of SQL Server news and information on Twitter. It's a medium that is becoming useful for SQL DBAs.
2009-11-09
88 reads
Is The PASS Summit Worth It?
Steve Jones has attended the PASS Summit annually, and found value. But for this Friday's poll, did you find value this week? Or have you in the past? Let others know.
2009-11-06
62 reads
Inspiring Change
Day 2 at the PASS Summit provides some inspiration for Steve Jones at the Women in Technology luncheon.
2014-03-25 (first published: 2009-11-05)
138 reads
The Summit 2009 - Day 1
Steve Jones talks a little about day one of the PASS Summit in 2009. A day of news, announcements, and briefings.
2009-11-04
65 reads
It's Time for Encryption
Encryption is starting to become a necessity, not an option as we work with and store more sensitive data. A guest editorial from Andy Warren comments on our fears of implementing encrpytion and why we might want to just encrypt everything.
2009-11-03
218 reads
Blogs
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...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Data Modeling with dbt for...
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