Tag Archives: microsoft sql server

  1. How can I use the identity column, without knowing identity column’s name.

    Leave a comment

    May 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

  2. Scripting with a temp stored procedure

    2

    March 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

  3. Shift calculations (or same time every day)

    2

    March 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

  4. I’m writing a SQL Server security presentation and I need your help.

    5

    February 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

  5. Help, not all of my column is displaying in the output of the query!

    1

    February 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

  6. A DBA horror story in database file extensions.

    4

    September 30, 2021 by Kenneth Fisher

  7. The sysname datatype defaults to not NULL.

    4

    August 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

  8. Experiment: Does sp_recompile on a table update associated views.

    2

    August 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

  9. Padding a string in SQL Server

    3

    July 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

  10. DDL Trigger to log database level security commands.

    4

    June 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,653 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013