Category Archives: Microsoft SQL Server

  1. How was it done back in the day? T-SQL Tuesday #114

    2

    May 14, 2019 by Kenneth Fisher

    It’s TSQL Tuesday and Matthew McGiffen (b/t) is our host with a subject near and dear to my heart. Puzzles! …
    Continue reading

  2. Why am I getting an NT AUTHORITY\ANONYMOUS error when creating or altering a stored procedure?

    1

    May 8, 2019 by Kenneth Fisher

    If you have to deal with linked servers then you probably have or will run into the following error: Login …
    Continue reading

  3. db_owner in msdb == sysadmin

    1

    May 6, 2019 by Kenneth Fisher

    This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner …
    Continue reading

  4. SQL Homework – May 2019 – SQLCMD and the DAC

    5

    May 1, 2019 by Kenneth Fisher

    Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC …
    Continue reading

  5. Yes, pulling just the data you need is really important.

    Leave a comment

    April 24, 2019 by Kenneth Fisher

    I was asked the other day why a customer was having performance issues on a table. A simple SELECT that …
    Continue reading

  6. Shrinking a large database with limited outage windows

    10

    April 22, 2019 by Kenneth Fisher

    Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where …
    Continue reading

  7. It’s all just data.

    2

    April 17, 2019 by Kenneth Fisher

    Tables, stored procedures, views, logins, constraints, etc, etc. It’s all just data. In every database system I’ve ever worked on …
    Continue reading

  8. How do I let someone execute a SQL Agent job they don’t own?

    2

    April 15, 2019 by Kenneth Fisher

    In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that …
    Continue reading

  9. Can SQL Ids be used on an instance with Windows Authentication only?

    2

    April 11, 2019 by Kenneth Fisher

    tl;dr; Yes, but. It’s generally considered more secure to have your SQL Server instance set to Windows Authentication and not …
    Continue reading

  10. Writing Crossword puzzles with a database: T-SQL Tuesday #113

    2

    April 9, 2019 by Kenneth Fisher

    Todd Kleinhans (b/t) is host for T-SQL Tuesday this month and wants us to talk about how we use databases …
    Continue reading

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

Join 2,505 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013