Atlanta for Two Days
Today is the first Redgate Summit of 2024 in Atlanta. I flew to town yesterday, There is a packed schedule, which is mostly repeated at our other events coming...
2024-03-13
16 reads
Blog Posts
Don't Trust the Defaults
(2024-Mar-08) Software installation typically involves several steps. After accepting the license agreement, you may have an express option to streamline the installation process by accepting all defaults, including the installation...
2024-03-13 (first published: 2024-03-08)
573 reads
How Can Data Empower Leaders
Using data effectively, leaders can make better decisions, drive innovation, and inspire trust. What is leadership through data? Leadership that utilizes data is the ability to use data as...
2024-03-13 (first published: 2024-03-07)
191 reads
SQLBits 2024 Recap
Had an absolutely amazing time at SQLBits this year! It was lovely to see all my data friends again and had the opportunity to introduce my husband to everyone...
2024-03-12
26 reads
A First Look at Redgate’s Subsetter
I have been a proponent of subsetting databases in dev/test for a long time. It took awhile, but as part of the Test Data Manager that Redgate launched at...
2024-03-11 (first published: 2024-02-28)
316 reads
Azure SQL MI License free?
A common setup when leveraging the cloud is to use the cloud for Disaster recovery (DR) purposes, some say it becomes a logical extension of your on-prem / data...
2024-03-11 (first published: 2024-02-27)
444 reads
10 reasons why IT certifications are still important
As someone who has spent over 20 years in the Software/Data Engineering area and has obtained numerous certifications, I can confidently say that certifications are still a valuable asset...
2024-03-08 (first published: 2024-02-23)
446 reads
A New Word, err Phrase: loss of backing
loss of backing– n. an abrupt collapse of trust in yourself – having abandoned a resolution, surrendered to your demons, or squandered an opportunity you swore you’d take seriously...
2024-03-08
26 reads
SQLpassion Live Training about running SQL Server in Microsoft Azure
From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training about Design, Deploy, and Optimize SQL Server on Microsoft Azure. Unlock the power of Microsoft...
2024-03-08 (first published: 2024-03-04)
325 reads
Book Review: My Effin Life
This is very off topic, but I’ve been a fan of Rush since I was about 12 years old. Their Moving Pictures This is a few thoughts on Geddy...
2024-03-06
141 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