No One is Safe
A funny example of SQL Injection has Steve Jones reminding us that every application needs to protect itself.
2010-04-20
372 reads
Editorial
More Support for Customers
A change in the support policy from Microsoft is a good thing, Steve Jones notes. Now you can still get help if you haven't been applying service packs.
2010-04-19
44 reads
Smart Virtualization
With so many people looking at virtualizing their environments, it's easy to assume it's easy to get done. Steve Jones, however, points out some advice from a very performance oriented company: the NYSE.
2010-04-19
425 reads
Company Rewards
Is there something that your company could do for you that would show that they valued your employment? That you were somehow important to them? Answer this Friday's poll.
2010-04-16
308 reads
2010-04-15
88 reads
Continuing Education
In IT we don't mandate that people continue their education in their field. But is there something else we can do? Steve Jones talks about other professions and the need for us to continue to learn about technology.
2010-04-14
201 reads
Are you preparing for SQL Server 2008 R2?
With the launch of SQL Server 2008 R2 almost upon us, DBAs need to start planning in some time to see what it has to offer. Brad McGehee reviews some of the available resources.
2010-04-12
519 reads
The Log Shipping Standard
Log shipping is a tool that has more benefits than just recovering from a major disaster. Steve Jones thinks this might be a tool that DBAs should use for all their critical databases.
2010-04-12
644 reads
Essential Software
For this Friday's poll, Steve Jones asks if there is a set of essential software that every DBA needs to have installed on their machine.
2010-04-09
344 reads
Office Cleaning
A guest editorial from Andy Warren today looks at choices in time management, as well as work accomplished.
2010-04-08
121 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...
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