Category Archives: Microsoft SQL Server
-
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 -
SQL Homework – June 2022 – SQL Agent Jobs continued.
2June 2, 2022 by Kenneth Fisher
A few years ago I gave you homework to create a SQL Agent Job and play with it a little …
Continue reading -
An auditing mind set
2May 31, 2022 by Kenneth Fisher
I little while back I presented at Pass Data Community Summit. Specifically the presentation was Auditing your data and data …
Continue reading -
Reblog from Brent Ozar: Designing a Data Model for Gender and Sexuality (Oh And Also, I’m Pansexual)
3May 25, 2022 by Kenneth Fisher
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s …
Continue reading -
TSQL Tuesday #150: Your first technical job. Rollup.
2May 24, 2022 by Kenneth Fisher
This months subject for T-SQL Tuesday was Your first technical job. I have to say I really really enjoyed reading …
Continue reading -
Running dynamic SQL in a different database
10May 19, 2022 by Kenneth Fisher
This is one of those things that on hindsight was a stupid problem, but still cost me hours and a …
Continue reading
SQL Studies 