SQL Managed Instances – Cross Instance?
There is a setting / feature in Managed Instance worth talking about, it is called SQL Trust Groups. What is this? At a basic level it’s a way to...
2021-12-15
94 reads
Blog Posts
The less you hear from or about the DBAs the better they are doing their job.
Something I’ve been thinking about recently is that DBAs are best when they are invisible. Now, this is also true ... Continue reading
2021-12-15 (first published: 2021-12-07)
349 reads
You can’t run SQL Server on Apple Silicon, and it sucks
Prior to 2017, the only way to get SQL Server running on a Mac was through a virtual machine running some version of Windows that supported some version of...
2021-12-15
50 reads
Call for Speaker Surat Tech Talks 2022
Last year, September 2020 we had organized 1st yearly event and we named it Surat Tech Talk. That event was a great success. This year, we are organizing this...
2021-12-14
1 reads
Daily Coping 14 Dec 2021
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...
2021-12-14
9 reads
The Next Event: T-SQL Tuesday #145
It’s time for T-SQL Tuesday again, and this month the host is Xavier Morera. He’s been part of the push I had to get a host with every letter...
2021-12-14
13 reads
Changing Case in SSMS–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I never knew I could change case for...
2021-12-13
28 reads
Configure SQL Server on Linux for Active Directory Authentication
In this post, we’re going to walk through configuring Active Directory authentication for SQL Server on Linux. We will start by joining the Linux server to the domain, configuring...
2021-12-13 (first published: 2021-12-01)
243 reads
Daily Coping 13 Dec 2021
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...
2021-12-13
8 reads
Tagging in SQL Monitor
For many of us, we’ve learned over time that we need to filter out the amount of things that we deal with in an given situation. We certainly often...
2021-12-13 (first published: 2021-12-06)
145 reads
Blogs
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Forums
To View or not to View, that is the question...
I've read lots of the horror stories about nested views in databases where they're...
Grant user read-write permission to a single database
Hello! How do I grant a user to read-write to a single database and...
Question of the Day
The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers