-
Running dynamic SQL in a different database
9May 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.
1May 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 -
How can I use the identity column, without knowing identity column’s name.
Leave a commentMay 12, 2022 by Kenneth Fisher
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The …
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 -
WITDC Mental Health and Wellness Day- April 8th
2April 5, 2022 by Kenneth Fisher
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This …
Continue reading -
Talk to the duck.
Leave a commentMarch 31, 2022 by Kenneth Fisher
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is …
Continue reading -
Scripting with a temp stored procedure
2March 17, 2022 by Kenneth Fisher
A few years back I learned about temporary stored procedures from a Kendra Little (blog|twitter) blog post. At the time …
Continue reading -
Shift calculations (or same time every day)
2March 15, 2022 by Kenneth Fisher
One of the more interesting jobs I’ve had over the years was for a company that created emergency room software. …
Continue reading