Where Did The Women Go?
A guest editorial today from Atieh Jones wondering where are all the women in IT?
Why RAID is (usually) a Terrible Idea
Your development system might be as valuable as your servers, but is it worth setting up with RAID? Read an interesting argument from one of the largest custom computer builder.
Would I encourage my daughter to pursue a career in IT?
A guest editorial today from Lynda Rab, PASS board member and new mother.
Technology: Where have all the women gone?
Longtime author Kathi Kellenberger brings us a guest editorial today on what is happening with women in the technology world.
The Old Boys Club
Steve Jones looks at some of the issues with gender in the workplace and reminds everyone that they need to respect each other.
Hacking SQL Server
In this presentation at the Jacksonville SQL Server Users Group, Bayer White playS the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins!
Introduction to ADO - The Command Object
The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.
SQL 2005 Maintenance Wizard Part 1
The SQL Server 2005 Maintenance Plan Wizard offers many core tasks and options for database housekeeping. In addition, the wizard will roll all of your selected tasks into a reusable and customizable package. Read on to learn more.
A Review of NGSSQuirreL
Longtime SQL Server expert and author Michael Coles takes a look at one of the security products that every SQL Server DBA should consider. Read on to find out how NGSSQuirreL can help you.
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