Work requests: It’s broke. Fix it.
Many years ago I was given a work request that literally just said: It’s broke. Fix it. I’m sure you ... Continue reading
2021-09-03 (first published: 2021-08-12)
430 reads
Blog Posts
Daily Coping 2 Sep 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-09-02
47 reads
Daily Coping 1 Sep 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-09-01
48 reads
Experiment: Does sp_recompile on a table update associated views.
tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the ... Continue reading
2021-09-01 (first published: 2021-08-17)
316 reads
Let’s talk about typefaces
I have previously written about accessibility in video captions, presentation slides, and disabilities, and I thought I should expand on the latter topic as it relates to typefaces, or...
2021-09-01
35 reads
Using PyApacheAtlas to import SQL Server extended properties to Azure Purview
Azure Purview is a compliance and data governance platform in Microsoft’s Azure cloud. The platform is currently in public preview and has quite a few features; but, does not...
2021-09-01 (first published: 2021-08-11)
411 reads
Daily Coping 31 Aug 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-08-31
25 reads
Expanded Button Formatting, New Spacing Controls, and Drag-and-Drop for List View Now in Block Editor
This month, our team released features in the block editor that give your site a little breathing room: spacing controls for buttons and paragraphs. And the List View tool...
2021-08-31
49 reads
Regular Expression Search & Replace in Visual Studio Code
Kind of a diversion into a Visual Studio Code/Azure Data Studio tip here (this works in both, as well as SQL Server Management Studio). I’m not a regular expression...
2021-08-31
45 reads
SQLCMD: Prevent an Entire Batch From Even Parsing With One Magical Character (Cruel Joke #4)
(last updated: 2021-09-01 @ 14:18 ET / 2021-09-01 @ 18:18 UTC ) In my previous post, SSMS and SQLCMD: Prevent T-SQL Batch From Not Only Executing, but Also From...
2021-08-31
104 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
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
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