Database Code Reviews
I’ll be honest, ever since I did a SQL Homework about doing code reviews I’ve wanted to do a blog ... Continue reading
2022-03-10
125 reads
Blog Posts
Snowflake Integration to Azure AD
Azure Active Directory is Microsoft Azure’s identity and access management providing authentication and authorization mechanism for internal and external applications in Azure ecosystem. With AD(more...)
The post Snowflake Integration to...
2022-03-10
63 reads
Check if File Exists Before Deploying SQL Script to Azure SQL Managed Instance in Azure Release Pipelines
I have been in Azure DevOps pipelines a lot recently, helping clients set up automated releases. Many of my clients are not in a place where automated build and...
2022-03-09 (first published: 2022-02-22)
387 reads
Daily Coping 9 Feb 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-03-09
10 reads
ETL v ELT
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-09
48 reads
Help, not all of my column is displaying in the output of the query!
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we ... Continue reading
2022-03-09 (first published: 2022-02-22)
348 reads
How do I merge a small part of a Git repo into another repo?
At my new day job, one of the things we want to do is migrate a portion of a really large Git repository (over 20GB) which I’ll call LargeRepo,...
2022-03-09
29 reads
An increased opportunity. Remote user groups. : T-SQL Tuesday #148
Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a ... Continue reading
2022-03-08
1 reads
An increased opportunity. Remote user groups. : T-SQL Tuesday #148
Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a ... Continue reading
2022-03-08
16 reads
Daily Coping 8 Feb 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-03-08
9 reads
Blogs
A New Word: Immerensis
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple...
Using a Local Large Language Model (LLM): Running Ollama on Your Laptop
You can now run powerful LLMs like Llama 3.1 directly on your laptop using...
Forums
SQL Server is terminating in response to a 'stop' request from Service error
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
Database Files on Shares I
Comments posted to this topic are about the item Database Files on Shares I
Question of the Day
Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers