Tag Archives: microsoft sql server
-
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 -
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 -
I’m writing a SQL Server security presentation and I need your help.
5February 24, 2022 by Kenneth Fisher
I’m working on a new presentation titled Watch Ken solve security headaches in SQL Server. In this presentation I’m going …
Continue reading -
Help, not all of my column is displaying in the output of the query!
1February 22, 2022 by Kenneth Fisher
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we …
Continue reading -
A DBA horror story in database file extensions.
4September 30, 2021 by Kenneth Fisher
-
The sysname datatype defaults to not NULL.
4August 26, 2021 by Kenneth Fisher
The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for …
Continue reading -
Experiment: Does sp_recompile on a table update associated views.
2August 17, 2021 by Kenneth Fisher
tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the …
Continue reading -
Padding a string in SQL Server
3July 15, 2021 by Kenneth Fisher
I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to …
Continue reading -
DDL Trigger to log database level security commands.
4June 24, 2021 by Kenneth Fisher
In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in …
Continue reading