-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: January 2018

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 bottom (as well as insert/overwrite status) in the status bar.… Read more

1 comments, 131 reads

Posted in The Voice of the DBA on 16 January 2018

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 terribly helpful. If you run the HTML file from the… Read more

2 comments, 104 reads

Posted in The Voice of the DBA on 16 January 2018

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 SQLServerCentral.

I do think GDPR will affect many of us,… Read more

0 comments, 158 reads

Posted in The Voice of the DBA on 15 January 2018

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 solving the issues that way. This lets me use… Read more

0 comments, 240 reads

Posted in The Voice of the DBA on 13 January 2018

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 with Day 1. Here is a look at… Read more

0 comments, 213 reads

Posted in The Voice of the DBA on 11 January 2018

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 turned out that the local name of the workstation had… Read more

0 comments, 220 reads

Posted in The Voice of the DBA on 10 January 2018

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 to troubleshoot and discover what the issue was, as well… Read more

1 comments, 728 reads

Posted in The Voice of the DBA on 9 January 2018