Asciidoc Distributed Docs as Code
TEST The Problem
I want to keep my code and my documentation in the same place.
I want to separate the presentation layer from my documentation content.
I want to be flexible...
2020-02-14
42 reads
Sheldon Hull
Running SQL Server in Docker
Why Use Docker for MSSQL Say you have an onboarding and need to get a new developer up to speed. Have you gone through the setup process for SQL...
2020-01-16
9 reads
2020-01-16
34 reads
Getting Started With Python For Data Exploration
Intro To get started with running python queries with SQL Server is actually pretty easy. I waited far too long to tackle this, thinking it was much harder than...
2019-11-19
9 reads
Getting Started With Python For Data Exploration
Intro
To get started with running python queries with SQL Server is actually pretty easy. I waited far too long to tackle this, thinking it was much harder than it...
2019-11-19
22 reads
Improving the Quality of Your Automation Logging with Cowsay
TEST Automation Taxes Your Sanity
You have to glue together systems with your amazing duct taped scripts.
You see failure after failure.
You want help predicting the success of your next run,...
2019-11-11
15 reads
Getting Started With Terraform
TEST Getting started with using Terraform for infrastructure can be a bit daunting if you've not dived into this stuff before. I put this together as a write up...
2019-11-07
39 reads
2019-09-26T14:10:42+00:00
TEST You know you are a dad when you start looking at a minivan as a really cool vehicle and marvel at all the features that have zilch to...
2019-09-27
9 reads
2019-09-26T14:04:40+00:00
TEST I have a new term for the wait my daughter eats food. Instead of please stop wearing food all over your face and eat proper I'm going to...
2019-09-26
7 reads
2019-09-26T13:58:58+00:00
TEST You know you probably reserved the wrong hotel when you drive around from the back and think it's a condemned building, only to come around the front and...
2019-09-26
7 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers