Experimenting with PostgreSQL in a Container
Learn how to get started using a container to run PostgreSQL, or really any other RDBMS, including a gotcha to watch out for.
2020-10-06
1,921 reads
Steve Jones
- Interests: yoga, reading, biking, skiing, volleyball
2020-10-02 (first published: 2018-04-10)
11,087 reads
Editor Tips and Tricks for Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Data Studio Using Azure Data Studio with TFVC Using Azure Data Studio with […]
2020-09-30
1,725 reads
Basic Git for DBAs: Managing PowerShell Scripts
This next article in the git series looks at managing powershell code in Git.
2020-08-27
3,130 reads
Basic Git for DBAs: What's a Pull Request?
Steve continues his series on Git for DBAs by looking at code review and pull requests.
2020-08-06
3,940 reads
Removing Extended Properties
With the new labeling and classificiation options in SQL Server, there might be a need to remove these labels before deploying the database.
2020-07-31 (first published: 2018-12-20)
2,602 reads
Basic Git for DBAs: Merging Code Between Branches
This article will cover a basic set of code merges between different branches.
2020-07-23
3,642 reads
Basic Git for DBAs: Making Changes in GitHub
In this article, learn how to work with your repo online at GitHub.
2020-07-14
4,078 reads
2020-07-10 (first published: 2019-01-10)
4,908 reads
Basic Git for DBAs: the Basics of Branches
Learn what a branch is in git and how you can create these, share them, and begin working with copies of your code.
2020-06-16
4,814 reads
Blogs
One Thousand SQL Saturdays (*ish)
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
Top Azure Synapse Analytics and Power BI questions
By James-Serra
I have listed below the top questions I see from customers about Azure Synapse...
Pre-Conference Workshop and Sessions at PASS Summit
I’m pleased to announce that I will be presenting at PASS Summit. This year...
Forums
Index scan
Hi, I have a query as below: ;With P As (Select ProductID --Query that...
why cannot use ClientProcessID to trace data in SQL Server Profile.
A C/S system is running on a SQL Server database, and I get its...
Copying an Azure SQL Database with PowerShell
Comments posted to this topic are about the item Copying an Azure SQL Database...
Ask SSC