Daily Coping 4 Nov 2020
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-11-04
30 reads
PASS Virtual Summit 2020: I'm (Virtually) Presenting
I'll be presenting at 7AM Central Time in the first timeslot of the main three-day PASS Virtual Summit 2020 conference. It's long been a goal of mine to present...
2020-11-04
33 reads
Consider the Benefits of Powershell for Developer Workflows
Who Am I Talking To
You use bash or python.
PowerShell seems wordy, extra verbose, and annoying.
It’s a windows thing, you say… why would I even look at it.
Pry bash out...
2020-11-20 (first published: 2020-11-04)
470 reads
Pro Microsoft Power Platform: Solution Building for the Citizen Developer
Over the last several months a team of excellent authors, including myself, have been writing a very exciting new book about Microsoft’s Power Platform. We
2020-11-20 (first published: 2020-11-04)
334 reads
Restoring Database Users After Copying the Database
A former colleague emailed me with a question about retaining/fixing database users and permissions after restoring a database. They were copying a database from one instance to another, with...
2020-11-04
25 reads
Improving Local Development Workflow With Go Task
Workflow Tooling
Development workflow, especially outside of a full-fledged IDE, is often a disjointed affair.
DevOps oriented workflows that often combine cli tools such as terraform, PowerShell, bash, and more all...
2020-11-03
176 reads
External tables vs T-SQL views on files in a data lake
A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what is the difference between using an external table versus...
2020-11-11 (first published: 2020-11-03)
782 reads
Fundamental Information for Azure Open Source Databases
As all of us know that Microsoft Azure Supporting many different database types such as Azure SQL, Azure Cosmos DB, and Azure support also MariaDB, MySQL, and PostgreSQL so...
2020-11-03
41 reads
Fundamental Information for Azure Open Source Databases
As all of us know that Microsoft Azure Supporting many different database types such as Azure SQL, Azure Cosmos DB, and Azure support also MariaDB, MySQL, and PostgreSQL so...
2020-11-03
84 reads
SQL Homework – November 2020 – Help!
If you ask any senior IT person What is the most important tool you have? there is a decent chance that ... Continue reading
2020-11-10 (first published: 2020-11-03)
592 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers