Laerte Junior takes us further into the world of an Exceptional PowerShell DBA, showing us how he uses PowerShell 2.0 to take all the headaches out of even more of his daily checklist. What could be better than having your morning checklist run itself?
2010-01-28
3,012 reads
Another great one day training event in Richmond, VA on Jan 30. Be sure to attend.
2010-01-28 (first published: 2010-01-21)
1,857 reads
We have got some boxes and balls. Our job is to put balls into those boxes. But, wait a second! The balls should be filled into the boxes based on some rules and preferences configured by the user. Here are the rules.
2010-01-28
2,109 reads
The time has come again for the UK’s biggest conference for .NET developers and SQL Server professionals. Read the press release about this years DevWeek.
2010-01-27
312 reads
William Talada brings us a short article to help you check your ANSI NULL settings and gives you a few reasons why you might want to make them consistent.
2010-01-27
8,143 reads
The PASS DBA VC hosts this session today that will focus on helping to choose between using a virtualization, instance, or database consolidation option. We will highlight a few of the key areas to consider as well as some of the important differentiators to keep in mind. We will provide a decision tree to help guide administrators through the process of selecting a consolidation option.
2010-01-27
1,120 reads
What can we use in SQL instead of E. F. Codd's T theta operators for best-fit? Joe Celko returns with another puzzle that isn't new, in fact it already features “Swedish”, “Croatian” and “Colombian” solutions in chapter 17 of Joe's 'SQL for Smarties' book. These were all written before CTEs or the new WINDOW functions. Is there now a better solution? Was there one even then? We leave it to the readers to provide the answer!
2010-01-27
1,535 reads
Coming on Jan 30, to the Boston area, be sure to attend this SQL Saturday if you are nearby.
2010-01-27 (first published: 2010-01-20)
1,505 reads
2010-01-26
442 reads
Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.
2010-01-26
5,998 reads
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Using OPENJSON
Comments posted to this topic are about the item Data Modeling with dbt for...
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