CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very...
2023-01-31
6 reads
Blog Posts
Daily Coping 31 Jan 2023
Today’s coping tip is to take a small step towards and important goal. One of my goals this year was to work on a way to score myself with...
2023-01-31
2 reads
Flyway Desktop Projects for My PoC
In a previous post, I set up the basic databases for the PoC project I’m working on. In this next post, we’ll get the Flyway Desktop projects set up...
2023-01-31 (first published: 2023-01-30)
3 reads
Tales From The Field Weekly Wrap Up for the Week of 01-23-2022
Hello Dear Reader! It's been a while since I had time to sit down and write out a Monday re-capThis past week was my birthday week. With all the...
2023-01-31
1 reads
Daily Coping 30 Jan 2023
Today’s coping tip is to plan something fun and invite others to join you. The fun thing is actually skiing today. My wife and I wanted to get some...
2023-01-30
5 reads
EightKB 2023
EightKB is back! The biggest online SQL Server internals conference is back in 2023…happening on May 24th. We’ve open our call for speakers, you can submit here: – https://sessionize.com/eightkb-may-2023/...
2023-01-30 (first published: 2023-01-23)
137 reads
Logic App errors out when using variables in a SharePoint Action
I have a Logic App that reads out a SharePoint library and stores all the documents found into Azure Blob Storage (ADF only supports Lists). I was trying to...
2023-01-30 (first published: 2023-01-18)
46 reads
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to make sure we are prepared for the scenario where something goes wrong. For instance, if...
2023-01-30
5 reads
New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend and colleague Ben E. Weissman, is now available on Pluralsight here! If you want to...
2023-01-28
8 reads
Allow a user to only trigger pipelines in Azure Data Factory
Typically you have a bunch of pipelines that are started by one or more triggers. Sometimes, a pipeline needs to be manually triggered. For example, when the finance department...
2023-01-27 (first published: 2023-01-25)
24 reads
Blogs
Daily Coping 31 Jan 2023
By Steve Jones
Today’s coping tip is to take a small step towards and important goal. One...
Tales From The Field Weekly Wrap Up for the Week of 01-23-2022
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my...
Forums
Multiple values in a parameter
Dear All, I want to use these values in the parameter for further usese,...
parameterizing a sql server connection
I am parameterizing an sql server connection. There are the following fields: username password...
'DATE' is not a recognized built-in function name
Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(TransactionDate)...
Ask SSC