Tag Archives: SQLNewBlogger

How does data file size relate to log file size?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The other day I saw someone asking about a way to determine which databases have a log file larger … Continue reading

Posted in Blog | Tagged , | Leave a comment

Finding Objects in a Schema #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 needed to do recently was move some objects from one schema to another. I … Continue reading

Posted in Blog | Tagged , , | 5 Comments

Moving Objects to a New Schema

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I haven’t had the need to move an object from one schema to another in years. Really since SQL … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Generating a Constrained Random Date–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There have been lots of posts on the topic of generating random values, and some great articles. One of … Continue reading

Posted in Blog | Tagged , , | Leave a comment

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

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