Category Archives: Microsoft SQL Server

  1. Windowing without a partition by or an order by

    Leave a comment

    February 21, 2018 by Kenneth Fisher

    If you’ve never worked with windowing functions they look something like this: The other day someone mentioned that you could …
    Continue reading

  2. The default filegroup, and why you should care.

    1

    February 19, 2018 by Kenneth Fisher

    You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
    Continue reading

  3. Synonyms, how and why.

    4

    February 15, 2018 by Kenneth Fisher

    Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even …
    Continue reading

  4. Hobbies, stress relief, and meeting management: T-SQL Tuesday #99

    2

    February 13, 2018 by Kenneth Fisher

    It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that …
    Continue reading

  5. Backups of backups or How long is my backup really available?

    1

    February 7, 2018 by Kenneth Fisher

    I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important, …
    Continue reading

  6. SQL Homework – February 2018 – Work with security

    Leave a comment

    February 5, 2018 by Kenneth Fisher

    This month let’s create some security! Create logins: GUI 5 pts/Script 5 pts Create a SQL login and a Windows …
    Continue reading

  7. How To: Install SQL Server on an Azure VM

    Leave a comment

    January 29, 2018 by Kenneth Fisher

    Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is …
    Continue reading

  8. Help it takes forever to open the SQL Server Log!

    Leave a comment

    January 24, 2018 by Kenneth Fisher

    Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the …
    Continue reading

  9. What’s dbo?

    2

    January 22, 2018 by Kenneth Fisher

    Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems …
    Continue reading

  10. How to read a technical blog

    4

    January 17, 2018 by Kenneth Fisher

    There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If …
    Continue reading

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

Join 2,164 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013