SQL Homework – October 2022 – Replication part 2
In August we started taking a look at replication. We learned some of the terms used, and set up a ... Continue reading
2022-10-04
28 reads
Blog Posts
Book Review: SQL Server Query Tuning & Optimization
If you are like me and still prefer the physical book as your primary reading material, Benjamin Nevarez's book from Packt Publishing is a great book to add to...
2022-10-03 (first published: 2022-09-19)
418 reads
Daily Coping 3 Oct 2022
Today’s coping tip is to write down three things you appreciate about yourself. I don’t mind self-evaluation, but I struggle a bit to publicly talk about things I do...
2022-10-03
9 reads
Function Vs. Performance
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that I decided to answer. I went off, set up a test database and some test...
2022-10-03
25 reads
Putting counters in names
It’s not all that unusual, or unreasonable to put a counter in a name. For example let’s say you need ... Continue reading
2022-10-03 (first published: 2022-09-13)
568 reads
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant to go out 9/29) Brent Ozar ... Continue reading
2022-10-01
113 reads
Community Tools Month 2022 - dbatools
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September Community Tools Awareness Month.
In September, I want you to improve community knowledge about one free...
2022-10-01
132 reads
Daily Coping 30 Sep 2022
Today’s coping tip is to find a new way to use one of your strengths or talents. I asked someone for strengths recently. Most of those items are things...
2022-09-30
13 reads
Data lake architecture
I have had a lot of conversations with customers to help them understand how to design a data lake. I touched on this in my blog Data lake details,...
2022-09-30
44 reads
DELETE TOP x rows with an ORDER BY
This was an interesting question that I was asked yesterday and something that I’d never really thought of before. Can you delete the top x number of rows based...
2022-09-30 (first published: 2022-09-15)
948 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