How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty ... Continue reading
2022-06-30 (first published: 2022-06-24)
21 reads
TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty ... Continue reading
2022-06-30 (first published: 2022-06-24)
21 reads
Well, it’s only been about a week and a half but here’s an update. First a piece of advice. You ... Continue reading
2022-06-30
60 reads
I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on ... Continue reading
2022-06-28
14 reads
This months subject for T-SQL Tuesday was Your first technical job. I have to say I really really enjoyed reading ... Continue reading
2022-06-24 (first published: 2022-05-24)
193 reads
As I’m sure a fair number of you already know I was told my position had been eliminated. They are ... Continue reading
2022-06-21
22 reads
I little while back I presented at Pass Data Community Summit. Specifically the presentation was Auditing your data and data ... Continue reading
2022-06-15 (first published: 2022-05-31)
194 reads
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding ... Continue reading
2022-06-14
44 reads
This is one of those things that on hindsight was a stupid problem, but still cost me hours and a ... Continue reading
2022-06-10 (first published: 2022-05-19)
453 reads
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The ... Continue reading
2022-06-03 (first published: 2022-05-12)
373 reads
A few years ago I gave you homework to create a SQL Agent Job and play with it a little ... Continue reading
2022-06-02
20 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
In my previous post, I expounded on my first 30 days I had at...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, I have this list of training courses: Course_Code|Description 1 |Health and Safety 2...
Please assist? I would like to do a data model of the tables here:...
hi all We've ventured into the world of AAG's as we have now moved...