Hot Adding CPU to SQL Server
Last Updated on January 24, 2023 by John Morehouse © 2022 – 2023, John Morehouse. All rights reserved.
The post Hot Adding CPU to SQL Server first appeared on John...
2022-12-09
69 reads
Blog Posts
Hyperconverged storage tuning tip for SQL Server
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises and in the cloud, has some interesting trade-offs. The biggest is write latency from the...
2022-12-09 (first published: 2022-11-25)
681 reads
Read data from Azure Synapse Serverless SQL Pools with Azure Data Factory
We have some data we can query using the serverless SQL pools in Azure Synapse Analytics. For this blog post, I’m querying data that is stored in Azure Cosmos...
2022-12-09 (first published: 2022-11-23)
248 reads
What Do I Do to Relax?
I’ve republished an editorial today from another author, called What do you do to relax after work? I’m thinking about that a few weeks ahead, because I needed to...
2022-12-09
24 reads
#PowershellBasics: Warnings and how to hide them.
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain ... Continue reading
2022-12-08
177 reads
Daily Coping 8 Dec 2022
Today’s coping tip is to be curious. Learn about a new topic or an inspiring idea. My daughter pointed a new podcast out to me: What’s Her Name? This...
2022-12-08
11 reads
Creating a Unity Catalog in Azure Databricks
Unity Catalog in Databricks provides a single place to create and manage data access policies that apply across all workspaces and users in an organization. It also provides a...
2022-12-07 (first published: 2022-11-23)
245 reads
Daily Coping 7 Dec 2022
Today’s coping tip is to stop for a minute when you walk outside and just enjoy nature. It’s getting cold in Colorado, but we had a day recently that...
2022-12-07
13 reads
Encryption and Data Protection Regulation
One of the reasons you may be considering encryption is due to the relevant data protection regulation: either because the regulation specifies that data should be encrypted or because...
2022-12-07
22 reads
Granting read access to SQL Server services with Just Enough Administration
We’ve all been there as DBAs…people requesting access to the servers that we look after to be able to view certain things. I’ve always got, well, twitchy with giving...
2022-12-07 (first published: 2022-11-23)
352 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers