Category Archives: SQLServerPedia Syndication
-
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 -
What’s next?
19June 21, 2022 by Kenneth Fisher
As I’m sure a fair number of you already know I was told my position had been eliminated. They are …
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 -
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 -
Getting a list of the articles in a publication.
5May 17, 2022 by Kenneth Fisher
The other day I was asked to supply a list of all of the tables being replicated into a given …
Continue reading -
My job managing a calling list. : T-SQL Tuesday #150
1May 10, 2022 by Kenneth Fisher
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I …
Continue reading -
SQL Homework – May 2022 – Books on Line
Leave a commentMay 5, 2022 by Kenneth Fisher
No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of …
Continue reading -
TSQL Tuesday #150 Invite – Your first technical job
45May 3, 2022 by Kenneth Fisher
This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start …
Continue reading
SQL Studies 