Monthly Archives: April 2019

  1. What do you get with a Free account in #Azure?

    Leave a comment

    April 29, 2019 by Kenneth Fisher

    The first thing I want to do is say thank you to Michael Crump (b/t). He tweeted out this: What …
    Continue reading

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

  3. Shrinking a large database with limited outage windows


    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

  4. It’s all just data.


    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

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


    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

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


    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

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


    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

  8. SQL Homework – April 2019 – Practice dealing with corruption

    Leave a comment

    April 3, 2019 by Kenneth Fisher

    Over the last almost 2 years (wow how time flys when you are having fun) we’ve practiced all kinds of …
    Continue reading

  9. Making a life change


    April 1, 2019 by Kenneth Fisher

    It is with a very heavy heart that I announce I will no longer be working with SQL Server. In …
    Continue reading

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

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013