T-SQL Tuesday #147 Invitation – Upgrade Strategies
It is time for T-SQL Tuesday #147 and this month I get to be the host. Since I’m in charge, I usually try to ensure I remember what this...
2022-02-01
25 reads
Blog Posts
Creating Azure DB for MySQL – Single Server
Enough of the theory and text lets use the Azure Portal and create MySQL Single server. Navigate to the Azure Portal, find Azure Database for MySQL servers: Click create...
2022-01-31
40 reads
Daily Coping 31 Jan 2022
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...
2022-01-31
13 reads
DP-900 Preparation Guide
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-01-31
50 reads
Trusting the Fine Print or connecting Azure Data Factory with Salesforce
(2022-Jan-19) David Eldersveld once said that a “cool solution is a completely insecure solution” - David Eldersveld on Twitter. That puzzled me, but only for a little while, since I...
2022-01-31 (first published: 2022-01-20)
536 reads
Two Clustered Indexes?
Everyone knows that you only get a single clustered index, right? Wouldn’t it be great though if you could have two clustered indexes? Well, you can. Sort of. Let’s...
2022-01-31 (first published: 2022-01-18)
447 reads
Ohio North Database Training User Group Presentation 1 Feb 2022
I am looking forward to presenting to the Ohio North Database Training User Group this Tuesday, February 1st, starting at 4:00pm CST. It is exciting for me to kickoff...
2022-01-29
40 reads
CosmosDB and Consistency
I was doing a little work with CosmosDB recently, and there were a few things that surprised me about the platform. I’m also not 100% sure I completely understand...
2022-01-28 (first published: 2022-01-17)
241 reads
Daily Coping 28 Jan 2022
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...
2022-01-28
34 reads
Get SQL Server Configuration using T-SQL
As a SQL architect or database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share
2022-01-28
309 reads
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Forums
Troubleshooting WQL in custom PBM conditions?
Hi, I'm currently trying to implement policy based mgmt with a condition to query...
Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers