Click here to monitor SSC
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

Quick Command Shells–#SQLNewBlogger

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

This isn’t a SQL post, per se, but since I’ve been using lots of PowerShell for SQL stuff at times, this is a handy trick I picked… Read more

1 comments, 202 reads

Posted in The Voice of the DBA on 22 December 2016

Connecting to a Specific Port–#SQLNewBlogger

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

I recently blogged about finding the port your SQL Server uses. At the end of that post I showed a connection to a server using a port.… Read more

0 comments, 205 reads

Posted in The Voice of the DBA on 15 December 2016

Live #SQLintheCity–Behind the Scenes

Here’s a shot from our engineer, behind the scenes of my live talk today.

//platform.twitter.com/widgets.js


Filed under: Blog Tagged: Redgate, sqlinthecity, syndicated

Read more

0 comments, 371 reads

Posted in The Voice of the DBA on 15 December 2016

SQL in the City Prep

I’m at the Redgate Software offices this week. I come over to visit the company, my boss and our department, and talk to product development groups a few times a year.

This time I’ve been mostly focused on the SQL in the City 2016, which is being streamed this… Read more

0 comments, 157 reads

Posted in The Voice of the DBA on 13 December 2016

T-SQL Tuesday #85–Cross Version Restores

It’s T-SQL Tuesday time, and this month Ken Fisher hosts. His topic is backups, and while I’m sure there will be plenty of views on backups, I wanted to touch base on a relatively simple item.

This is the monthly blog party started by Adam Machanic. Whether you want… Read more

1 comments, 204 reads

Posted in The Voice of the DBA on 13 December 2016

Using ReadyRoll to Automate Database Migrations

I like ReadyRoll, and this week at SQL in the City 2017, I get to show some of the product off. I’ll be doing mostly demos and coding, live, with ReadyRoll, sending my code through from development to QA to production.

Despite the power and ease with which… Read more

0 comments, 177 reads

Posted in The Voice of the DBA on 13 December 2016

Manual v Automation

I’ve got my work cut out for me. This week is SQL in the City 2017. One of the sessions I need to present is a Manual DBA database deployment against an automated CI/CD process with the Redgate tools.

To give our automated DBA a chance, I’ll be playing… Read more

0 comments, 212 reads

Posted in The Voice of the DBA on 12 December 2016

SQLBits 2017 In April

I’m getting excited, with the announcement that SQL Bits 2017 is scheduled. The conference goes back to Telford, which I enjoyed and takes place April 5-8, 2017. 

I’m getting my presentations ready for submission, and I really hope I get the chance to speak again. This is a fun event,… Read more

0 comments, 212 reads

Posted in The Voice of the DBA on 12 December 2016

Interviewed on Channel 9

Had a quick interview at Microsoft on Channel 9 last month, and it’s now live. Enjoy.

https://channel9.msdn.com/Blogs/vsppstories/Including-the-database-in-your-DevOps-pipeline/player


Filed under: Blog Tagged: DevOps, speaking, syndicated

Read more

0 comments, 384 reads

Posted in The Voice of the DBA on 9 December 2016

Easily Move Databases with Copy-SqlDatabase

One of the things that people have asked to be implemented for many years is an easy way to copy databases. SSIS has the Copy Database Task, but that has been problematic over time. As a result, while easy, it’s cumbersome to take a backup of a database, copy it… Read more

3 comments, 1,767 reads

Posted in The Voice of the DBA on 9 December 2016

What Port Should I Use?–#SQLNewBlogger

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

This is a quick post on checking the port for your SQL Server instance. It’s in line with Tim Ford’s request for simple, beginning blog posts this… Read more

4 comments, 238 reads

Posted in The Voice of the DBA on 8 December 2016

SQL in the City is coming next week

Next week is the 2016 version of SQL in the City and you can register now to attend. It’s free and doesn’t require any travel. You can watch the event live from the comfort of your office chair.

In the many years that we’ve run SQL in the City, we’ve… Read more

0 comments, 223 reads

Posted in The Voice of the DBA on 7 December 2016

A Python SQL Server App

I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page, they ask you to pick a language and OS. Since I’ve done a little Python and I used Windows, I chose that option.

The page looks to walk… Read more

4 comments, 344 reads

Posted in The Voice of the DBA on 6 December 2016

Find my git remote

I work on a few projects and have a bunch of demos setup, but I don’t work on them all every week. Being only semi-creative like many of you, I end up with some similar projects with similar names. When I wanted to determine which project was linked to which… Read more

0 comments, 215 reads

Posted in The Voice of the DBA on 4 December 2016

Moving Tasks with Copy-SqlJob

More dbatools experimentation for me. This is a great set of Powershell cmdlets that solve simple, handy problems. In this post, I want to look at Copy-SqlJob, which will allow me to easily move jobs from one instance to another.

The Job Subsystem

Jobs in SQL Server are part… Read more

2 comments, 378 reads

Posted in The Voice of the DBA on 2 December 2016

Hey Posh, Are My Services Running?–#SQLNewBlogger

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

In a previous post, I looked at escaping strings. The reason I needed to do this was that I was trying to do some automatic work… Read more

0 comments, 309 reads

Posted in The Voice of the DBA on 1 December 2016

What’s the little popup window in #SQLPrompt?

Awhile back I was working in SSMS and saw this window.

It threw me off since I was trying to write some code and hadn’t expected it. I clicked Escape, Enter, a few things and was getting frustrated when it disappeared.

I ignored it until I saw the window again… Read more

4 comments, 1,124 reads

Posted in The Voice of the DBA on 30 November 2016

Rate a Session for GroupBy

One of the things that I struggle with is understanding whether a session at a conference like a SQL Saturday is worth watching. I also struggle writing abstracts and attracting people to my own sessions, so I think the idea of GroupBy allowing rating and reviewing of abstracts in advance… Read more

2 comments, 240 reads

Posted in The Voice of the DBA on 29 November 2016

Validating a Set of Database Scripts using DLM Automation

The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or confusing, but they aren’t. This is part of a series of posts that examine how you use each one.

Previously I looked at New-DatabaseConnection. In this post, I’ll go through… Read more

0 comments, 1,052 reads

Posted in The Voice of the DBA on 28 November 2016

Quick PoSh Kills with Stop-DbaProcess

I’ve been trying to get used to using the dbatools cmdlets in PoSh. They help me learn some PowerShell, but they also make some things easier. As a part of my practice, I’m documenting the various items I’ve played with. This post looks at Stop-DbaProcess.

Killing Spids

At first I… Read more

0 comments, 1,059 reads

Posted in The Voice of the DBA on 25 November 2016

Newer posts

Older posts