Tag Archives: SQLNewBlogger

Context Info Across Databases–#SQLNewBlogger

Posted on February 1, 2023 by way0utwest

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 , , | Comments Off on Context Info Across Databases–#SQLNewBlogger

Select All in a Power BI Slicer–#SQLNewBlogger

Posted on November 9, 2022 by way0utwest

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 , , | Comments Off on Select All in a Power BI Slicer–#SQLNewBlogger

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

Posted on October 17, 2022 by way0utwest

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

Posted on September 21, 2022 by way0utwest

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