Tag Archives: SQLNewBlogger

Getting the Role Permissions–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. If you are wondering what permissions a role has, and don’t want to spend time searching and digging through … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Solving Ken’s FizzBuzz 3D–#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 FizzBuzz test. It’s cute and fun, and I’ve had my kids solve it, just to think … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Finding Inconsistent Key Values–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was reading Iris Classon’s blog recently and ran across a post on her day at work. I think … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Getting SQL Agent going for SQL Server on Linux–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. It’s actually a simple procedure, but I thought I’d write a short note to help me remember. The procedure … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Finding Tabs in SSMS–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Someone posted this as a question and I thought it was worth noting. I use SQL Prompt for formatting, … Continue reading

Posted in Blog | Tagged , ,

Defining FKs in CREATE TABLE–#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 important things that a database developer can do is to define Foreign Keys (FK) at table … Continue reading

Posted in Blog | Tagged , , | 2 Comments

I learned about the order of logical operations #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I had logic in a CS curriculum many years ago and I’ve worked with AND and OR statements for … Continue reading

Posted in Blog | Tagged , , | 6 Comments

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

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

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