Unboxing SQL Clone 2020 for a PoC
When I got a new machine, I had SQL Clone on my old machine, in a few VMWare VMs. I decided to move this to my new machine, so...
2020-08-13 (first published: 2020-08-04)
354 reads
Daily Coping 4 Aug 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-08-04
17 reads
Azure SQL Database SLA
Can you improve on the baseline (service level agreement) SLA of 99.99 % for Azure SQL Database? How can you get 99.995% as shown below, from official Microsoft documentation?...
2020-08-04
105 reads
Speaking at DataMinds Connect 2020
I’m delighted to announce I’ll be speaking again at DataMinds Connect this year, one of the greatest and best Microsoft Data Platform conferences on the European mainland. Due to...
2020-08-04
15 reads
SQLSaturday Auckland: Certification Exams Inside Out this Weekend!
Looking forward to virtually presenting at SQLSaturday Auckland 2020 this weekend! I'll be presenting at 10:45AM Auckland time on Saturday, but that's 5:45pm Friday evening where I am in Central...
2020-08-03
22 reads
Data Cleanup for WordPress Tags without a Plugin
Over the years I’ve had this blog, I’ve added lots of tags. In 15 years and 4,600+ posts, you can guess that I’ve made some typos and mistakes. I’ve...
2020-08-03
26 reads
Capturing Queries Can Be a Pain
The moment you decide you want to monitor your SQL Server instance for query behavior, you’re going to be forced to make a bunch of choices. Further, all these...
2020-08-11 (first published: 2020-08-03)
446 reads
Daily Coping 3 Aug 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-08-03
11 reads
Last Week Reading (2020-08-02)
Press ADF Release Notes 07/31/2020 I believe this is the first Release Notes from ADF Team. Working with Git repositories in Azure Pipelines Multi-repository access and more. DevOps for...
2020-08-02
21 reads
Online certification exams are definitely different
As you can tell from previous posts, I’ve taken a few Microsoft Certification exams here in 2020. As you may have also heard, there’s been this Coronavirus pandemic happening...
2020-08-01
11 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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
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