Default Credentials
Using default credentials is a poor practice, but people still continue to forget to change them.
2021-01-18
316 reads
Editorials
Who is my customer?
My final job in my previous career was at a hospital. I worked there for five years in the 90s before getting my first position as a developer. While I didn’t love the career I was leaving, I did appreciate what I learned from that last job. Part of the onboarding included a short class […]
2021-01-16
129 reads
Improving Availability Groups
Availability Groups are a good way to use High Availability in SQL Server, Today Steve wonders if you have any improvements you would make to the technology.
2021-01-15
154 reads
Microsoft Fights Back
Microsoft fights back against hackers after a recent vulnerability in a management framework.
2021-01-14
222 reads
2021-01-13
84 reads
Reassess Your Configuration
It's a good idea for anyone managing systems to periodically check them and see if anything needs to change.
2021-01-12
93 reads
The Responsibility for Bugs
Today Steve wonders who should be responsible for software bugs, something of which we have no shortage of in our industry.
2021-01-11
104 reads
Easy Data Access Plus Security
As I type this, I've got my right leg propped up on a stool. That's because if I sit for any length of time with the knee bent, I have a great deal of pain on standing. Seems there's something horribly wrong with my knee. I still don't know what yet. I've had an MRI […]
2021-01-09
63 reads
Picking a Goal for 2021
If you have set any new goals for your career this year, Steve is asking you to let him know.
2021-01-08
113 reads
The Best Way to Protect Sensitive Data
Steve has a thought on the best way to protect sensitive data.
2021-01-07
140 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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