Tag Archives: sql server

Brush Up on Your ETL Skills

Many of us that work with data will find requests and demands to import or export data at some point. Plenty of us have regular processes that perform these actions, and we may regularly troubleshoot or enhance these activities. In … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Template Configuration

One of my goals this year is to really spend some time learning more about Extended Events (XE). I’m somewhat embarassed that almost a decade after their introduction in SQL Server 2008, I have a fairly rudimentary grasp of the … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

Getting Your SET Options

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

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

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 , , | Leave a comment

It’s Time to Patch and Upgrade

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

Restoring a Copy Only Backup–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There was a question posted recently at SQLServerCentral about whether a copy only backup could be restore with a … Continue reading

Posted in Blog | Tagged , , , , | Leave a comment

Not Useless Features

Some time ago I noticed Adam Machanic had written a post titled The SQL Hall of Shame. In it, Adam notes there are features that Microsoft will introduce in SQL Server and then let die. These are the useless features that … Continue reading

Posted in Editorial | Tagged | Leave a comment

Keeping the Single User Connection

A reader was having issues with a script. They ran their code from PoSh (Invoke-Sqlcmd), setting single user and then trying to rename a database and its files. However, occasionally, they’d lose the single user connection to another user. Frustrating, … Continue reading

Posted in Blog | Tagged ,

Changing the Default DB for a Login–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I got into a bit of a pickle. I was detaching some databases for a demo, which is … Continue reading

Posted in Blog | Tagged , , ,