Tag Archives: sql server

Getting Your SET Options

Posted on February 6, 2018 by way0utwest

Have you ever used @@options? I haven’t typically needed this, but there are times that you might wonder what options are set for a session. You can check in SSMS, look for defaults, etc., but there’s an easy way. SELECT … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

SSMS Line Numbers

Posted on January 16, 2018 by way0utwest

I typically don’t turn on line numbers if SSMS, but while working with someone on a bit of code, they were referencing line numbers in a large script. By default SSMS shows you the line, column, and character at the … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Fixing logins

Posted on January 10, 2018 by way0utwest

I ran into an issue recently where I couldn’t get a Windows login to work with some application software. This software had been configured with a user account, which appeared to be in SQL Server, but it couldn’t connect. It … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Fixing logins

It’s Time to Patch and Upgrade

Posted on January 5, 2018 by way0utwest

I don’t want to be chicken little here, but the Meltdown/Spectre bugs have me concerned. I don’t know the scope of the vulnerabilities, as far as exploits go, but I do know the lax ways in which humans interact with … Continue reading →

Posted in Editorial | Tagged , , | 2 Comments