Category Archives: Blog

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

Finding the Titles in R

PASS has released the videos to members from this past Summit. I say TJay Belt today ask about relating a video name to a session. I have the USB drive, so I looked on there. Here are the videos: Not … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Reading GDPR

In case you’re interested, the GDPR law is actually not bad to read. You might be affected by this, so go through the regulations. I’m doing that this week. You can also see a nice article from David Poole at … Continue reading

Posted in Blog | Tagged , | Leave a comment

tsqlt Tests for Advent of Code 2017 Day 2

This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and … Continue reading

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

The Travel Review

I got a note from United this week that summarized my travel for 2017. I’ve been feeling a bit itchy as I haven’t had any trips scheduled for 2018 so far. Strange for me, but looking over the summary, I’m … Continue reading

Posted in Blog | Tagged , | Leave a comment

Advent of Code 2017 Day 2–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start … Continue reading

Posted in Blog | Tagged , , | Leave a 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

T-SQL Tuesday #098–Technical Challenges

It’s the first T-SQL Tuesday of 2018, being brought to you by Arun Sirpal. His invitation this month asks for you to talk about some technical challenge that you conquered in your career. Some type of issue that you had … Continue reading

Posted in Blog | Tagged , | 1 Comment

Advent of Code 2017 Day 1–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I like the Advent of Code. I stumbled on the site a few years ago and enjoyed working through … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Creating a Books Online Pull Request

One of the neat things at Microsoft did last year was put Books Online in GitHub. This is in the MicrosoftDocs org under the sql-docs repo. The organization is a bit funny, but once you get used to it, you … Continue reading

Posted in Blog | Tagged | 2 Comments