When things aren't done well or set up properly in your systems, is it a mistake or a failure? Steve Jones talks about the need for those working with technology to be sure that they are taking responsibility for being educated about how to do things.
SQL Server 2008 and 2005 offer the Service Broker feature. In this tip we will go through the different components of service broker and step by step on how to setup Service Broker for a single database.
Recently, my friend Jack Corbett asked a question on Twitter:
In a nutshell, the SSIS foreach loop will enumerate a given...
Avoiding getting snared in these traps avoids having to spend a lot of money later to fix problems, Gartner says. In addition, EA benefits can be realized faster and the risk of program failure is reduced.
There's a networking seminar at the PASS Summit, and with the explosion of social networking sites, lots of technology workers have been thinking about how to better network for their career. Today Steve Joens talks about why it's a good idea to build up your networking skills.
Building a tally table is a common T-SQL problem that many new developers struggle with. Lynn Pettis brings us an article that shows how to use CTEs to accomplish this.
There's a networking seminar at the PASS Summit, and with the explosion of social networking sites, lots of technology workers have been thinking about how to better network for their career. Today Steve Joens talks about why it's a good idea to build up your networking skills.
There's a networking seminar at the PASS Summit, and with the explosion of social networking sites, lots of technology workers have been thinking about how to better network for their career. Today Steve Joens talks about why it's a good idea to build up your networking skills.
There's a networking seminar at the PASS Summit, and with the explosion of social networking sites, lots of technology workers have been thinking about how to better network for their career. Today Steve Joens talks about why it's a good idea to build up your networking skills.
Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.
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...
Hello all, I’m looking for advice on how to derive a daily snapshot table...
We need to replace our Windows server running SQL 2017. Any reason not to...
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