Category Archives: SQLServerPedia Syndication

  1. T-SQL Tuesday #97 – Setting learning goals for 2018

    Leave a comment

    December 12, 2017 by Kenneth Fisher

    T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic …
    Continue reading

  2. Restrict the usage of a SQL Server Authenticated Application Id

    1

    December 6, 2017 by Kenneth Fisher

    SQL Server login ids may not be the most secure thing in the world but they are likely to be …
    Continue reading

  3. SQL Homework – December 2017 – View the log

    Leave a comment

    December 4, 2017 by Kenneth Fisher

    Last homework of the year. Last month was to create a view. This month it’s time to take a look …
    Continue reading

  4. SQL Puzzle – Word Scrambler

    2

    November 29, 2017 by Kenneth Fisher

    I’ve been writing crosswords for the last few months and to change things up I thought I would do a …
    Continue reading

  5. Closing all of the connections to a database

    3

    November 27, 2017 by Kenneth Fisher

    Doing a database restore may not be the most common task a database professional will ever do, but it’s a …
    Continue reading

  6. Why shouldn’t I shrink my database data file?

    2

    November 20, 2017 by Kenneth Fisher

    A while back I did a post about why you shouldn’t shrink your data file. This one is going to …
    Continue reading

  7. Variables in Dynamic SQL

    Leave a comment

    November 16, 2017 by Kenneth Fisher

    I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. …
    Continue reading

  8. It takes a village

    1

    November 14, 2017 by Kenneth Fisher

    Ewald Cress (b/t) is our host this month for Adam Machanic’s (b/t) monthly blog party T-SQL Tuesday. Having just gotten …
    Continue reading

  9. More Collation Confusion. (tempdb)

    1

    November 8, 2017 by Kenneth Fisher

    I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance …
    Continue reading

  10. DBA Definitions: FILLFACTOR

    1

    November 6, 2017 by Kenneth Fisher

    It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing …
    Continue reading

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

Join 2,151 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013