Tag Archives: SQLNewBlogger

Always Use Roles–#SQLNewBlogger

Posted on May 10, 2019 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Which of these is more complex? GRANT SELECT ON dbo.Customer TO JoeDev or CREATE ROLE SalesGRANT SELECT ON dbo.Customer … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Lengthen a Primary Key–#SQLNewBlogger

Posted on April 17, 2019 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post recently where someone needed to increase the size of a PK and was getting a … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Upper Casing All the Data–#SQLNewBlogger

Posted on March 4, 2019 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There was a post recently where a user asked about needing to update all the data in all their … Continue reading →

Posted in Blog | Tagged , | 2 Comments

Changing the Database Collation–#SQLNewBlogger

Posted on February 27, 2019 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was testing some changes recently and needed to verify how things worked in a different collation. Here’s the … Continue reading →

Posted in Blog | Tagged , | 1 Comment