End an ALTER DATABASE immediately if anyone is in the database.
The development team has told me they’ve shut down the application, there are no more connections and I can go ... Continue reading
2020-06-30 (first published: 2020-06-11)
706 reads
New Management Hub in Azure Data Factory
I wanted to manually start an Azure-SSIS Integration Runtime in ADF, so I went to the edit section and then to connections. But instead of showing me my linked...
2020-06-25 (first published: 2020-06-11)
296 reads
Webcast – Principles of Data Modeling
Tomorrow, June 11, 2020, at 3 PM Eastern I’m giving a webcast on the Principles of Data Modeling. Sign up link: https://www.mssqltips.com/sql-server-webcast-signup/?id=822 Here’s what we’ll be covering: You’ve been...
2020-06-10
52 reads
Next week is EightKB–The SQL Server Internals Conference
Next week, on Wednesday, June 17, 2020, the EightKB conference takes place. As with other events, it’s online, and it is full of high level content. It looks to...
2020-06-10
38 reads
How SQL Server stores data types: floating points
In this post we are looking at how SQL Server stores floating point values (FLOAT and REAL). If you’d like to read the previous posts in this series of...
2020-06-10
196 reads
Remote communication for fun and profit! – a MinionWare snippet
We’re a large household with a small business, and we find ourselves with an interesting mix of tools for chat, screen sharing, and video conferencing. Here are our favorites!
The...
2020-06-10
17 reads
Remote communication for fun and profit! – a MinionWare snippet
We’re a large household with a small business, and we find ourselves with an interesting mix of tools for chat, screen sharing, and video conferencing. Here are our favorites!
The...
2020-06-10
14 reads
Daily Coping 10 June 2020
I’ve 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-06-10
17 reads
Creating a Repository from VSCode–#SQLNewBlogger
I’ve been working with a few different git clients, and trying to write some articles to help people get started. As I do this, I thought it was interesting...
2020-06-25 (first published: 2020-06-10)
364 reads
Azure Monitor and Azure SQL Database
This is all about enabling diagnostics telemetry for Azure SQL databases. For Azure SQL Database there are quite a few options to select from. Below shows the diagnostic settings...
2020-06-10
46 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers