Daily Coping 7 Dec 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-12-07
29 reads
Blog Posts
Data Architecture Blog Post: CI CD in Azure Synapse Analytics Part 1
Hello Dear Reader! It's been a while. I've got a new blog post over on the Microsoft Data Architecture Blog on using Azure Synapse Analytics titled, CI...
2020-12-07
12 reads
Data Architecture Blog Post: CI CD in Azure Synapse Analytics Part 1
Hello Dear Reader! It's been a while. I've got a new blog post over on the Microsoft Data Architecture Blog on using Azure Synapse Analytics titled, CI...
2020-12-07
81 reads
Top 10 Must-Ask Questions Before Going to the Cloud
After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top ten must ask questions before migrating to the cloud so that you can save time, money,...
2020-12-07 (first published: 2020-11-23)
694 reads
Virtual Log Files
Today’s post is a guest article from a friend of Dallas DBAs, writer, and fantastic DBA Jules Behrens (B|L) One common performance issue that is not well known that...
2020-12-07 (first published: 2020-11-24)
387 reads
A Note to the PASS Board of Directors
I just read with dismay that Mindy Curnutt has resigned. That’s a big loss at a time when the future of PASS is in doubt and we need all...
2020-12-06
108 reads
5 Things You Should Know About Azure SQL
Azure SQL offers up a world of benefits that can be captured by consumers if implemented correctly. It will not solve all your problems, but it can solve quite...
2020-12-04
15 reads
5 Things You Should Know About Azure SQL
Azure SQL offers up a world of benefits that can be captured by consumers if implemented correctly. It will not solve all your problems, but it can solve quite...
2020-12-04
7 reads
5 Things You Should Know About Azure SQL
Azure SQL offers up a world of benefits that can be captured by consumers if implemented correctly. It will not solve all your problems, but it can solve quite...
2020-12-04
9 reads
5 Things You Should Know About Azure SQL
Azure SQL offers up a world of benefits that can be captured by consumers if implemented correctly. It will not solve all your problems, but it can solve quite...
2020-12-04
12 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