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

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, 102 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, 94 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, 150 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, 229 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, 211 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, 699 reads

Posted in The Voice of the DBA on 9 January 2018

Speaking in 2017

I’m done. No more trips (and no more time) to hit any events this year. As I wrote recently, I’m doing less in 2018, so this review might be quite short next year.

In any case, I thought I’d look back at how speaking went in 2017. I have a… Read more

0 comments, 212 reads

Posted in The Voice of the DBA on 28 December 2017

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 transaction log backup from a database. I was positive… Read more

0 comments, 384 reads

Posted in The Voice of the DBA on 27 December 2017

AutoMap in SQL Compare

SQL Compare is a core product from Redgate and I’ve got a series on some of the interesting things I’ve found. Download a trial today if you haven’t tried it.

SQL Compare does a great job of trying to help you map columns in your database. For example, I was… Read more

0 comments, 829 reads

Posted in The Voice of the DBA on 14 December 2017

T-SQL Tuesday #098–2018 Goals

A great topic for T-SQL Tuesday this time from @sqlmal. It’s Setting Learning Goals for 2018, and it’s a topic I both loathe and love. I hate making commitments that I can’t keep, and I constantly find that a chaotic life will get in the way of learning over… Read more

4 comments, 280 reads

Posted in The Voice of the DBA on 12 December 2017

Renaming a Column–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

One of the things I rarely do is rename objects. There are good reasons to do so, but often the changes required in other objects and applications isn’t… Read more

0 comments, 1,771 reads

Posted in The Voice of the DBA on 11 December 2017

SSMS Updates in 17.4

SSMS 17.4 is out, and if you haven’t upgraded from SQL 204, 2012, 2008, etc., you should do so. You can run your bundled SSMS side by side with the new versions, but it seems that the 17x versions are improving andbecoming more stable.

You can download the new version Read more

0 comments, 911 reads

Posted in The Voice of the DBA on 8 December 2017

Interviewed

I got sent an interview by Mohammad Darab, a fellow SQL Server professional in Northern Virginia. I thought the questions were interesting, and spent a bit of time on them. You can read the interview here: https://mohammaddarab.com/interview-steve-jones/

Read more

2 comments, 915 reads

Posted in The Voice of the DBA on 8 December 2017

Live on Channel 9 with ReadyRoll

I was interviewed in Redmond a couple months ago and the video was just published. I show and demo some database migration work with ReadyRoll in this video:

https://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Database-DevOps-with-RedGate-ReadyRoll/player


Filed under: Blog Tagged: DevOps, ReadyRoll, Redgate, syndicated

Read more

0 comments, 1,524 reads

Posted in The Voice of the DBA on 7 December 2017

My Second Pester Test

I should write about my first one, but I just copied Rob’s test, so that’s not so exciting. Instead, I decided to take his advice and write some code, then decide how I test it. This isn’t really TDD, but I need to understand how Posh returns things, so… Read more

1 comments, 1,744 reads

Posted in The Voice of the DBA on 7 December 2017

Join Me Online Next Week for SQL in the City

It’s one week to SQL in the City 2017, once again streamed. I’ll be traveling this weekend to the Redgate office and getting setup. After two days of rehearsing, I’ll be ready for the live broadcast Dec 13.

Here’s a quick promo video as well:

Once again, we’ll be… Read more

0 comments, 886 reads

Posted in The Voice of the DBA on 6 December 2017

SQL Prompt Gets Even Better

SQL Prompt v9 came out recently, and just when you thought they couldn’t make it better, they found a way. If you click the menu for SQL Prompt, you’ll see a couple new items.

Code Analysis!!! Finally, a first step towards some sort of better analysis of code. These are… Read more

1 comments, 556 reads

Posted in The Voice of the DBA on 5 December 2017

Testing a Birthday Month Query

I ran across a post from a tester, wondering  how to write a query for birthday months. This makes sense, as I’m sure some businesses want to notify or track customers that have birthdays this month and give them something.

The post was good, with DDL and test data, and… Read more

0 comments, 1,476 reads

Posted in The Voice of the DBA on 4 December 2017

Automating SQL Clone Creation with PoSh

I think SQL Clone is one of the game changing products from Redgate. This product really fits into a DevOps mindset, allowing me to quickly and easily build (and rebuild) a dev database.

While the agent web pages make this easy, they’re slightly cumbersome and the PowerShell cmdlets fit better… Read more

0 comments, 395 reads

Posted in The Voice of the DBA on 1 December 2017

Older posts