Tag Archives: T-SQL

Enabling Guest in a Database–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The guest account exists in all your databases. This is installed by default, and guest is used to map … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Getting Your SET Options

Have you ever used @@options? I haven’t typically needed this, but there are times that you might wonder what options are set for a session. You can check in SSMS, look for defaults, etc., but there’s an easy way. SELECT … Continue reading

Posted in Blog | Tagged , , | 3 Comments

No Default CONTEXT_INFO()

I was doing a little testing of Row-Level Security (RLS) for the stairway, and one of the ways that some people implement RLS is with CONTEXT_INFO(). I haven’t every really used CONTEXT_INFO in production, though it’s been around for some … Continue reading

Posted in Blog | Tagged , | Leave a comment

Advent of Code 2017 Day 5–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is day 5 of the Advent of Code 2017. If you want to read about the puzzles, start … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Advent of Code 2017 Day 4–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is day 4 of the Advent of Code 2017. If you want to read about the puzzles, start … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Advent of Code 2017 Day 2–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Advent of Code 2017 Day 1–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I like the Advent of Code. I stumbled on the site a few years ago and enjoyed working through … Continue reading

Posted in Blog | Tagged , , | 6 Comments

Restoring a Copy Only Backup–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There was a question posted recently at SQLServerCentral about whether a copy only backup could be restore with a … Continue reading

Posted in Blog | Tagged , , , , | Leave a comment

Renaming a Column–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I rarely do is rename objects. There are good reasons to do so, but often … Continue reading

Posted in Blog | Tagged , , | Leave a comment

ROLLing UP Totals–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was editing an article recently that talked about ROLLUP, and I wanted to play with this a bit … Continue reading

Posted in Blog | Tagged , , | 2 Comments