Tag Archives: sql server

The Best Ever

Posted on April 10, 2018 by

Every few years, or every year now, we see a new version of SQL Server proclaimed as the best ever. A few weeks ago, I saw a number of people leaving hte MVP Summit, rating it as the best ever … Continue reading →

Posted in Editorial | Tagged | Leave a comment

Predictions for the Future

Posted on March 6, 2018 by

There is no shortage of predictions that we all make every day. Long before PREDICT and the popularity of Machine Learning/R/Python and more, each and every one of us has regularly made guesses about what will happen in our world. Some of … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

Decouple the Tools

Posted on March 5, 2018 by

For years, SQL Server included a complete set of add-ons with the main product. We got SSIS, SSRS, and more as part of an integrated installation. This also included things like Books Online and various tools, such as Profiler, bcp, … Continue reading →

Posted in Editorial | Tagged , , | Leave a comment

Brush Up on Your ETL Skills

Posted on February 21, 2018 by

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

Posted on February 16, 2018 by

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

Posted on February 6, 2018 by

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

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

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

It’s Time to Patch and Upgrade

Posted on January 5, 2018 by

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

Restoring a Copy Only Backup–#SQLNewBlogger

Posted on December 27, 2017 by

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