Coding for the Future
Writing code that solves problems and adapts to the future is a challenge, but it's something we should think about.
2022-01-12
278 reads
Editorials
Teams Security Issues
There are a few security issues in the Teams application from Microsoft, and Steve notes that some of the push for new features can be a problem in this area.
2022-01-10
296 reads
Where the World Takes You
We're launching into a new year and there are lots of "looking into the future" articles out there. Personally, I'm pretty jazzed for the coming year for any number of reasons (can you say "SQL Server 2022"?). However, I also get a little retrospective at times like this. Now, I'm not going to talk about […]
2022-01-08
175 reads
What Were Your 2021 Wins
The first poll question of the year has Steve asking you to look back at 2021 and pick something good that happened.
2022-01-07
178 reads
Challenging Trends
Steve notes the changes in the world might affect how to view and use data in our work.
2022-01-05
276 reads
Data Cleanup
Steve wishes we could do some data cleanup and archival every year. Or even more often.
2022-01-03
325 reads
Education to solve the tech skills shortage
I’ve been teaching T-SQL to groups of students since 2014 at the non-profit LaunchCode in St. Louis. LaunchCode provides free tech training, paid apprenticeships, and career support to hundreds of people who have the ability and interest but not always the opportunity to land tech careers. For example, not having a college degree can eliminate […]
2021-12-31
404 reads
2021-12-31
59 reads
2021-12-29 (first published: 2017-03-24)
161 reads
2021-12-27
232 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