Category Archives: T-SQL

  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. My job managing a calling list. : T-SQL Tuesday #150

    Leave a comment

    May 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

  3. SQL Homework – May 2022 – Books on Line

    Leave a comment

    May 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

  4. 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

  5. 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

  6. An increased opportunity. Remote user groups. : T-SQL Tuesday #148

    Leave a comment

    March 8, 2022 by Kenneth Fisher

    Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a …
    Continue reading

  7. SQL Homework – March 2022 – Formatting

    Leave a comment

    March 1, 2022 by Kenneth Fisher

    Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries …
    Continue reading

  8. You can’t use GO in dynamic SQL.

    1

    February 10, 2022 by Kenneth Fisher

    This is one of those things that when I look back on it seems really obvious. Note: If at the …
    Continue reading

  9. Who do you contact before an upgrade? : T-SQL Tuesday #147

    1

    February 9, 2022 by Kenneth Fisher

    I haven’t been blogging as much recently as I’d like and I’m trying to get back into it. One excellent …
    Continue reading

  10. Commenting a branching IF-THEN-ELSE.

    1

    October 19, 2021 by Kenneth Fisher

    I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an interesting way to comment an IF-THEN-ELSE …
    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