Getting a list of the articles in a publication.
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
Blog Posts
Storage Field Day 23 – SIOS
I am thrilled to have been a part of this year’s Storage Field Day 23 event, held by Gestalt IT during the first week of March. This event is...
2022-05-17
11 reads
Azure Synapse Explained
In this article we would like to give you a high level summary on Azure Synapse.
What it is, what are its strengths and weaknesses observed through our project implementations...
2022-05-16 (first published: 2022-05-13)
37 reads
Comparing Daily Estimates to Actuals–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a previous post I wrote about using...
2022-05-16 (first published: 2022-05-04)
174 reads
Daily Coping 16 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-16
7 reads
How can I use the identity column, without knowing identity column’s name.
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The ... Continue reading
2022-05-16 (first published: 2022-05-12)
22 reads
How to Deploy an Azure Function with PowerShell using Azure Devops
In the blog post Azure Function with PowerShell and the Power BI REST API I explained how you could create an Azure Function using the PowerShell scripting language. This...
2022-05-16 (first published: 2022-04-27)
157 reads
Installing the mssql-cli on Ubuntu 22.04
I really like the mssql-cli tool. I use it pretty much everyday however it seems like it’s not being maintained anymore and as such, there are issues when trying...
2022-05-16 (first published: 2022-05-13)
98 reads
Power BI Adding Dynamic Hierarchies – XMLA, TOM, C#
This post is a continuation of my adventure into the Tabular Object Model and how we can use it to make Power BI scalable and incorporate it into existing...
2022-05-16 (first published: 2022-05-12)
10 reads
Power BI connectors to Azure Synapse
When using Power BI and pulling data from Azure Synapse, you will use the “Get Data” feature in Power BI. There are now three connections that you can use...
2022-05-16 (first published: 2022-05-13)
42 reads
Blogs
Daily Coping 24 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Notes on SQLSaturday Jacksonville 2022
By Andy Warren
I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...
TSQL Tuesday #150: Your first technical job. Rollup.
This months subject for T-SQL Tuesday was Your first technical job. I have to...
Forums
Is this If Condition Expression Valid?
I hate to be a pain, but I am a beginner at this and...
SSRS 2012 Email Relay question
Hi All, I am trying to figure out if it is possible to...
Interviewing for a SQL Server DBA role, any tips?
Hi all, as the title says, I'm interviewing for a job as a SQL...
Ask SSC