Tag Archives: SQLNewBlogger

Context Info Across Databases–#SQLNewBlogger

Does Context Info work across databases? This post shows it does. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Here are some hints to get started. The … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Select All in a Power BI Slicer–#SQLNewBlogger

One of the things I’ve been working on this year is a Power BI report for the kids I coaco in volleyball. As a part of this, I want to be able to show all kids, or a few kids, … Continue reading

Posted in Blog | Tagged , , | Leave a comment

An Update to Skipping the Leading Digit in T-SQL–#SQLNewBlogger

There was an interesting question in a forum, which I wrote about before. How do you skip the leading digit in a numeric value. I had looked at a UNION, but someone had a better suggestion, so I’m adding to … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Checking Database Compatability = #SQLNewBlogger

Recently I needed to check the compatibility level of a database and SSMS didn’t work. This is what I did in T-SQL.https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16 Another post for me that is simple and hopefully serves as an example for people trying to get … Continue reading

Posted in Blog | Tagged , , | Comments Off on Checking Database Compatability = #SQLNewBlogger