Category Archives: Microsoft SQL Server
-
Using DBCC CLONEDATABASE to create a schema only copy of your database.
Leave a commentAugust 11, 2022 by Kenneth Fisher
DBCC CLONEDATABASE is one of those features that I don’t use often but it’s really cool when I need it. …
Continue reading -
Visiting with DBAs at midnight : T-SQL Tuesday #153
Leave a commentAugust 9, 2022 by Kenneth Fisher
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our host for this month’s episode of …
Continue reading -
SQL Homework – August 2022 – Replication part 1
Leave a commentAugust 2, 2022 by Kenneth Fisher
You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really …
Continue reading -
SSMS Put pinned tabs in their own row
2July 21, 2022 by Kenneth Fisher
A while back (6 years ago 😲) I talked about how you can change the behavior of SSMS so that …
Continue reading -
You’re doing your POC wrong! : T-SQL Tuesday #152
2July 12, 2022 by Kenneth Fisher
It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A …
Continue reading -
SQL Homework – July 2022 – Update your resume.
1July 5, 2022 by Kenneth Fisher
Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to …
Continue reading -
Creating a Database Audit Specification can create new users & schemas in the background
2June 28, 2022 by Kenneth Fisher
I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on …
Continue reading -
How do I tell if identity_insert is turned on and if so what table?
4June 24, 2022 by Kenneth Fisher
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 -
Too many coding standards : T-SQL Tuesday #151
4June 14, 2022 by Kenneth Fisher
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding …
Continue reading