Database Concerns – A Poll!
What are you most concerned about in your database platforms? Please pick from the list below, and expand on your choice in the comments if you like: Thanks...
2023-11-08 (first published: 2023-10-25)
221 reads
Blog Posts
My data architecture book now has 15 chapters available!
Only one more chapter to go! As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title...
2023-11-08 (first published: 2023-10-23)
639 reads
All the chapters in my data architecture book are now available!
As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...
2023-11-06
28 reads
Common Mistakes in SQL Server – Part 6
In SQL Server, there are various scenarios in which you may want to consider recompiling a query or a stored procedure to ensure optimal query performance. Recompilation generates a...
2023-11-06 (first published: 2023-10-23)
755 reads
Setup Ola Index Maintenance with Azure Runbooks and Terraform
Yes, you still need to do some work to maintain indexes in Azure SQL Database. This post will walk you through setting up statistic updates and index maintenance using...
2023-11-06 (first published: 2023-10-19)
503 reads
Last Weeks Reading (2023-11-05)
📰 News Process Azure Event Hubs data using Azure Data Factory Mapping Data Flows Read how to process Azure Event Hubs data using ADF for certain use cases. Automate...
2023-11-05
18 reads
A New Word: Zielschmerz
zielschmerz – n. the dread of pursuing a lifelong dream, which requires you to put your true abilities out there to be tested on the open savannah, no longer...
2023-11-03
130 reads
Deleting a Git Branch–#SQLNewBlogger
I had someone ask me recently about deleting branches. While I had known how to delete a local branch, I had to look up how to delete a remote...
2023-11-03 (first published: 2023-10-23)
176 reads
Friday Flyway Tips–Seeing Pending Migrations
I find that quite a few people using Flyway will end up with a lot of migration scripts over time. While you can certainly re-baseline and split scripts into...
2023-11-03
47 reads
SQL Server query runtime is not everything
SQL Server query developers, listen up! Query execution time is not everything you should be worried about. You need to examine the parse and compilation time for each of...
2023-11-03 (first published: 2023-10-18)
659 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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...
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