Category Archives: Microsoft SQL Server

  1. DBA Myths: Database file extentions

    5

    December 2, 2015 by Kenneth Fisher

    Every now and again I hear or read that the only file extensions for a SQL Server database are mdf, …
    Continue reading

  2. Using multiple log files

    5

    November 23, 2015 by Kenneth Fisher

    The transaction log is made up of one or more files that are used sequentially. So in other words if …
    Continue reading

  3. Naught to Speaker pt 3

    6

    November 18, 2015 by Kenneth Fisher

    Becoming a speaker is one heck of a journey. Early this year I submitted a session to speak at Pass …
    Continue reading

  4. SSMS Setup

    5

    November 16, 2015 by Kenneth Fisher

    Every time I install a new version of SSMS I make a handful of changes to the default setup. For …
    Continue reading

  5. Hiding one or more columns

    Leave a comment

    November 12, 2015 by Kenneth Fisher

    This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain …
    Continue reading

  6. Why are you still using datetime?

    28

    November 10, 2015 by Kenneth Fisher

    It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a …
    Continue reading

  7. Questions from “SQL Server Security for Everyone”

    Leave a comment

    November 4, 2015 by Kenneth Fisher

    I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by …
    Continue reading

  8. Administrative Logins and Users

    Leave a comment

    November 2, 2015 by Kenneth Fisher

    If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this: Please …
    Continue reading

  9. Finding and keeping your #SQLPassion

    1

    October 26, 2015 by Kenneth Fisher

    I consider myself lucky. I fell into a job that I truly enjoy, something that I do for fun even …
    Continue reading

  10. Generating scripts for previous versions of SQL

    1

    October 21, 2015 by Kenneth Fisher

    I make a habit of using the latest version of SSMS even if I’m not working with the latest version …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 832 other followers