Want me to do a presentation?
I greatly enjoy doing presentations on a variety of topics, such as Business Intelligence, SQL Server, and personal development. If you...
2013-05-02
714 reads
Blog Posts
Calculating the next beginning of month and the current end of month
Handling dates is always a fun challenge in T-SQL! Finding the current end of month and next months beginning of...
2013-05-01
2,224 reads
Colorado SQL Events : May 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-05-01
614 reads
PASS SQL Saturday Events : May 2013
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2013-05-01
545 reads
PowerSQL - List SQL Server instance configuration details and sending an automated email
Reblogged from Prashanth Jayaram :
This article walks through how to list SQL Server configurable and non-configurable instance settings using PowerShell...
2013-05-01
2,910 reads
SQL Server Events in the UK – May 2013
Things are really ramping up in May and June this year, it’s a great time to be an IT Professional with so...
2013-05-01
860 reads
Well I finally passed the 70-451
So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few...
2013-05-01
805 reads
Enhance your career by blogging!
When I started my blog two years ago, I never would have thought how much it would help my career. I...
2013-04-30
2,841 reads
Getting the lowdown on 18456 errors
If you can establish a connection to a SQL Server, but are having problems logging in to it, you will...
2013-04-30 (first published: 2013-04-18)
2,538 reads
Looking Forward
For the past couple months I’ve been looking forward to a 5 week break, a chance to think about what...
2013-04-30
1,406 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