Redgate Summit Comes to the Windy City
I love Chicago. I went to visit three times in 2023: a Redgate event, a volleyball tournament, and a wedding. Each time was a lot of fun and I...
2024-05-08
58 reads
Blog Posts
Techorama 2024 – Slides
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on github.
The post Techorama 2024 – Slides first appeared on Under the kover of business intelligence.
2024-05-08
55 reads
Attacking the Weakest Link
When I look at a system and think about its security model, the first thing I start poking around at is where I think security is weakest. For instance,...
2024-05-06
60 reads
Cloud Databases Made Simple: Creating Your First AWS RDS Instance
I recently started full time learning of Amazon Web Services (AWS). I found that AWS's Relational Database Service
(RDS) is really user-friendly. RDS simplifies many of the
complicated aspects of...
2024-05-06 (first published: 2024-04-20)
395 reads
Tired of Tedious SQL Queries? AI Tools Can Automate The Boring Parts
If you've ever wrestled with complex SQL code, you know the drill. Hours spent on a single query, eyes glazing over at the endless lines of commands, that sinking...
2024-05-06 (first published: 2024-04-19)
912 reads
Webinar – Microsoft Fabric for Dummies
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about Microsoft Fabric (at 6PM UTC).Abstract: Microsoft Fabric is the new all-encompassing data platform of Microsoft....
2024-05-06
64 reads
A New Word: mcfeely
mcfeely – adj. inexplicably moved by predictable and well-worn sentiments, even if they are trite or obvious or being broadcast blindly to the masses. I get mcfeely all the...
2024-05-03
14 reads
Check your regions people
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing came up. I mentioned an F2 is only around €250 a month, but a colleague...
2024-05-03 (first published: 2024-04-17)
199 reads
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break into this field or climb the DBA career ladder, mastering SQL is absolutely crucial. Let's...
2024-05-03
374 reads
Using Git Prune–#SQLNewBlogger
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated a lot of branches. Even though I’m a solo developer, I decided to use branches,...
2024-05-03 (first published: 2024-04-17)
208 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