Capturing Perfmon Counters With Telegraf
Setting up Telegraf to Capture Metrics I had a lot of issues with getting the GO enviroment setup in windows, this time and previous times. For using telegraf, I'd...
2017-08-08
40 reads
Blog Posts
Capturing Perfmon Counters With Telegraf
InfluxDb & Grafana Series
Running InfluxDb As A Service in WindowsSetting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDB And AnnotationsCapturing...
2017-08-08
794 reads
Data modeling in Power BI using XML file with Parent and Children nodes
[2017-Aug-08] Support for XML structured files as a data source has been available in Excel, then was introduced into the Power...
2017-08-08
12,761 reads
Exploring SQL Server With Powershell And SMO Basics
SqlServer Powershell Cmdlets 2017 - Initialize Look
Diving into the Sql Server Management Objects library can be a pretty interesting process. You...
2017-08-08
1,235 reads
How to be a bad interviewer
In the monthly SQL blogging party that is T-SQL Tuesday (brainchild of Adam Machanic), Kendra Little has invited us this...
2017-08-08
1,421 reads
I Hate Interviews – TSQL2sDay
This month’s T-SQL Tuesday is hosted by Kendra Little and is on the topic of interviews
I hate interviews as an interviewee....
2017-08-08
520 reads
Interview Patterns and Anti-Patterns Combined
It’s that time again. T-SQL Tuesday. The monthly blog party started by Adam Machanic (b/t) seven and a half years...
2017-08-08
385 reads
Interviews and Oranges
What a great topic for this month’s T-SQL Tuesday hosted by Kendra Little https://littlekendra.com/2017/08/01/tsql-tuesday-93-interviewing-patterns-anti-patterns/
The topic being: Interviewing Patterns and Anti-Patterns....
2017-08-08
314 reads
Learn How to Recover Deleted Records from SQL Server 2014
Problem
Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their records are deleted due to which they face a...
2017-08-08
5 reads
Learn How to Recover Deleted Records from SQL Server 2014
Problem
Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their...
2017-08-08
5,227 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