Tag Archives: microsoft sql server

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

    Leave a comment

    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

  2. Synonyms, how and why.

    3

    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

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

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

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

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

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

  8. Who should own the database?

    6

    January 15, 2018 by Kenneth Fisher

    TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and …
    Continue reading

  9. Fun with sp_rename

    Leave a comment

    January 11, 2018 by Kenneth Fisher

    Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in …
    Continue reading

  10. A Solution for Squirrely SQL Server Security: TSQL Tuesday #98

    Leave a comment

    January 9, 2018 by Kenneth Fisher

    It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject …
    Continue reading

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

Join 2,163 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013