I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for ... Continue reading
2020-10-22 (first published: 2020-10-15)
273 reads
(2020-Oct-14) Ok, here is my problem: I have an Azure Data Factory (ADF) workflow that includes an Azure Function call to perform external operations and returns output result, which in...
2020-10-23 (first published: 2020-10-15)
1,141 reads
Enjoyed the heck out of tonight's October special edition of the virtual Baton Rouge .NET and SQL User Groups meeting, where we had a lot of active chat, three...
2020-10-15
27 reads
One of the things we often want to do when building a PoSh script is to get some output. I first learned about Write-Host, but I learned over time...
2020-10-22 (first published: 2020-10-14)
585 reads
This — like last week’s post — is not about SQL Server or Azure SQL Database. In a way, it hearkens back to a post I wrote a few years...
2020-10-14
40 reads
Data engineers, pipe line developers, general data enthusiasts will be spending most of their time within a notebook. Here you develop your code, nice visualisations and commentary boxes are...
2020-10-14
51 reads
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...
2020-10-14
21 reads
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2020-10-13
15 reads
This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...
2020-10-21 (first published: 2020-10-13)
270 reads
Copying an Azure SQL Database is a vital skill when managing cloud databases. Recently, a request was received from the “business”. They wanted to create a copy of an...
2020-10-21 (first published: 2020-10-13)
296 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers