SQL Server Configurations – Back to Basics
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would...
2018-01-11
534 reads
Blog Posts
T-SQL for Performance and Accuracy – Vern Rabe: A preconference essential for anyone using SQL Server
SQL Saturday Preconference: February 9th, 2018 in Redmond, WA Do you think you write T-SQL queries that perform well? Think...
2018-01-11
409 reads
T-SQL Tuesday #98 Round Up
Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...
2018-01-11
584 reads
Comparing two SQL instances
Last week I was working on a couple of SQL instances that contained databases which were part of an Always...
2018-01-10
479 reads
Dynamics AX Event Session
Many moons ago, I wrote about how to enable the context info for Dynamics AX. Having the context info enabled...
2018-01-10 (first published: 2018-01-03)
1,138 reads
Fixing logins
I ran into an issue recently where I couldn’t get a Windows login to work with some application software. This...
2018-01-10
439 reads
It’s All in the Name, Index Naming Conventions
Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....
2018-01-10
1,710 reads
Regular Expressions (Day 10)
Have you ever downloaded a script from an internet site, only to find that there are extra blank lines between...
2018-01-10
452 reads
SCOM: SQL Instance and Databases exclusion
This post is by Chris Gibson
I recently wanted to exclude some temporary SQL databases from being discovered by our SCOM...
2018-01-10
1,365 reads
SQL Homework – January 2017 – Inspect an Execution Plan
It’s a new year and yet education never ends. So this month let’s take a look at an important part...
2018-01-10 (first published: 2018-01-03)
2,491 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