PowerShell, Pester and Ola Hallengrens Maintenance Solution
If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and...
2016-10-04 (first published: 2016-09-24)
3,760 reads
Blog Posts
Restore through FULL backup
Problem
A common misconception that i've heard a few times around backups is that a FULL backup invalidates previous TRANSACTION LOG...
2016-10-04
295 reads
SQL 2016 SSMS memory leak?
Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...
2016-10-04
7,247 reads
SQL SSRS Express Edition Cannot Connect to Azure SQL Databases
This has bit a couple of clients recently, figured I'd put out a PSA.
Express editions of SQL Server Reporting Service,...
2016-10-04 (first published: 2016-09-25)
2,150 reads
Upcoming Webinars: What’s New in SSRS and MDS 2016
I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features...
2016-10-04
586 reads
A quick fix for a full identity column.
A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following:
Negative...
2016-10-03 (first published: 2016-09-21)
2,055 reads
Becoming a Microsoft MVP
I was awarded the Microsoft MVP (data platform) award on Saturday.
On the four days a year (one per quarter) when...
2016-10-03
635 reads
Future DBA – Big Data -MongoDB 1
We have discussed hadoop and its HDFS management tools for big data system, which works horizontal scaling for data distribution...
2016-10-03
484 reads
Mastering Index – Clustered Index
This article is the part of series Mastering Index, in this particular article we will be exploring Clustered Index. Take...
2016-10-03
506 reads
PowerShell: Extending Modules – System Parameter measurement
The Microsoft Technet Guru Award (August 2016) winning article – Silver
PowerShell: Extending Modules – System Parameter measurement
PowerShell: Extending Modules – System Parameter measurement
Abstract
The...
2016-10-03
972 reads
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
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...
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