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
8 reads
Blog Posts
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
23 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)
558 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
111 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
123 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
12 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
36 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)
933 reads
The Redgate 100
The Redgate 100 is a list of 100 people that are influential in the database world in a number of categories.I made the list in a few places, which...
2022-09-30 (first published: 2022-09-09)
161 reads
Daily Coping 29 Sep 2022
Today’s coping tip is to avoid saying “I should” and make time to do nothing, or do something fun. I’m writing this ahead of time, and I am doing...
2022-09-29
11 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers