How to Excel in Board Meetings as a CFO
The post How to Excel in Board Meetings as a CFO appeared first on Joyful Craftsmen.
2024-08-20
14 reads
Blog Posts
Master Advanced SQL: 2 Essential Courses for Every Data Analyst
If you're a data analyst, you already know that SQL isn't just a nice-to-have skill – it's the bedrock of your work. But let's face it, SQL isn't a...
2024-08-19
210 reads
Monday Monitor Tips- Enabling Index Tracking in Redgate Monitor
There is a new index feature in Redgate Monitor, but it’s disabled by default. This post shows how to enable things. This is part of a series of posts...
2024-08-19 (first published: 2024-08-05)
132 reads
Monday Monitor Tips: Changing the Fragmentation Alert
I had a customer that was concerned about the fragmentation alert for indexes and wanted to know how to change it. This post discusses the change. This is part...
2024-08-19
32 reads
My personal experience Dockerizing a Ruby on Rails Application: Deploy to AWS ECR using Github…
My personal experience Dockerizing a Ruby on Rails Application: Deploy to AWS ECR using Github ActionsI recently received a request on how to Dockerize a Ruby on Rails application after...
2024-08-19
53 reads
Service Broker Blocking
This post is dedicated to all 10 other DBAs that use Service Broker (you know who you are).
The main reason for this blog post is that I’ve got no...
2024-08-19 (first published: 2024-08-09)
179 reads
Managing Database code
This is my own contribution to the T-SQL Tuesday I am hosting – on managing database code. I am from the older generation – where the farthest we went...
2024-08-18
41 reads
SQL Saturday Denver 2024 Resources
Here are the resources from my talks today. Best Practices for Seamless Database Deployments PPTX slides Architecting Zero Downtime Deployments git repo: https://github.com/way0utwest/ZeroDowntime PPTX slides Some good questions today,...
2024-08-18 (first published: 2024-08-17)
48 reads
A New Word: Povism
povism – n. the frustration of being stuck inside your own head, unable to see your face or read your body language in context, only ever guessing how you...
2024-08-16
25 reads
dbatools Required Filesystem Access for Database Restores
The Problem While performing an instance migration this spring, I happened upon something I didn’t expect in [dbatools](https://dbatools.io/). It should have been a simple backup/restore copy of the databases,...
2024-08-16 (first published: 2024-08-06)
268 reads
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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