SQL Homework – June 2021 – SQL Audits
Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. ... Continue reading
2021-06-14 (first published: 2021-06-01)
295 reads
Blog Posts
Azure SQL Database – Secondary Database and Tiers
On the theme of failover groups let’s do a quick recap on my environment. As shown below you can see the secondary database server called spacesql in West Europe....
2021-06-11
102 reads
Daily Coping 11 June 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-06-11
22 reads
The PASS Data Community Summit Call for Speakers
The other day I saw something that I wasn’t sure I’ve ever see again. The call for speakers for the PASS Data Community Summit went out. After the dissolution...
2021-06-11 (first published: 2021-05-28)
140 reads
The WITDC Mental Health and Wellness day and why July 2020 really sucked for me.
I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the ... Continue reading
2021-06-11 (first published: 2021-05-27)
217 reads
Daily Coping 10 June 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-06-10
31 reads
A Basic Encryption Primer for SQL Server
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Encryption is a function call in SQL Server,...
2021-06-09 (first published: 2021-05-26)
613 reads
Daily Coping 9 Jun 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-06-09
27 reads
Data Fabric defined
Another buzzword that you may have been hearing a lot about lately is Data Fabric. In short, a data fabric is a single environment consisting of a unified architecture...
2021-06-09
18 reads
How to extend your existing SQL Server Failover Cluster Instance to the Cloud for Disaster Recovery
I get asked this question all the time, so I figured it was time to write a blog post, record a video and write some code to automate the...
2021-06-09 (first published: 2021-05-22)
306 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers