Daily Coping 31 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-31
21 reads
Blog Posts
Change Azure SQL Database Service Level Objectives in SSMS
Sometimes as a DBA, I am lazy and want the ability to execute all of my tasks in one place. Lucky for me I discovered the other day that...
2020-08-28
14 reads
Daily Coping 28 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-28
44 reads
Debating #PASSSummit Pre Cons for Monday
I’ll be speaking at the PASS Summit in 2020, and I have some things to prepare for that. I get a conference admission for the event and access for...
2020-08-28
68 reads
My August Christmas Card
Do you ever get the Christmas card that features a beautiful picture of a family on the front, and a letter catching you up on their year on the...
2020-08-28 (first published: 2020-08-18)
227 reads
The value of mentoring
I’ve spent my whole career working with databases which is over 20 years and counting. I work for a great company and I love what I do. The job...
2020-08-28 (first published: 2020-08-17)
200 reads
A Quick SQL Change Automation Build
I was going through a few of the Redgate products with a customer recently and they wanted to perform some validation of the build and release process with SQL...
2020-08-27 (first published: 2020-08-19)
527 reads
As a DBA, am I a gatekeeper?
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and ... Continue reading
2020-08-27
188 reads
Azure SQL Database Automatic Tuning
I really like the automatic tuning aspect of Azure SQL Database. This post is not a full explanation and demo. Instead, I want to point out a small point...
2020-08-27 (first published: 2020-08-17)
264 reads
Daily Coping 27 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-27
19 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