-->
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: November 2015

Python Command Line Calls

There was a time I worked in a company any we lived in the command line. This was in the early 90s, prior to Windows v3.1 being released and we primarily used DOS on a Novell network.

We also had paper phone books on every desk for the 1,000+ people… Read more

2 comments, 674 reads

Posted in The Voice of the DBA on 27 November 2015

Test if a File Exists with Powershell

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

Awhile back I wrote a PowerShell script (PoSh) to download the SQL Saturday XML files used for the Guidebook application. These contain a bunch of the information that… Read more

4 comments, 783 reads

Posted in The Voice of the DBA on 25 November 2015

Python and Tweepy

One of the projects that’s been on my list lately is to programmatically access Twitter for a few ideas I want to play with. Since I’ve been trying to learn some Python, I thought I would take a look using Python to update status and read status.

A quick Google… Read more

2 comments, 477 reads

Posted in The Voice of the DBA on 20 November 2015

Viewing Extended Properties for Information

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

I’ve been working a little with extended properties, adding and updating them for various objects. However in addition to altering properties, viewing the properties on an object is… Read more

1 comments, 471 reads

Posted in The Voice of the DBA on 18 November 2015

Back to SQL Saturday Washington DC

I’ve been to the SQL Saturday in Washington, DC a few times and I’m looking forward to going back. It’s a good event and since I have family in the area, I can usually take a day or two of vacation and visit.

This year the event is on Dec… Read more

4 comments, 461 reads

Posted in The Voice of the DBA on 16 November 2015

Thankful in November

I’m taking a short break from technical talk today to spend a few minutes thinking about life. My wife started the Thankfulness challenge in November, and while I didn’t participate, I’ve been thinking about life as I watch her posts.

This is a career and learning blog, and much of… Read more

0 comments, 388 reads

Posted in The Voice of the DBA on 13 November 2015

Git Pull in SQL Source Control

I wrote recently on Git Push in SQL Source Control (SOC), and now wanted to add the other side of the story, pull. This process is even simpler.

I’ll be working with a new database, one that has two client systems set up already with Git support. I know I… Read more

0 comments, 991 reads

Posted in The Voice of the DBA on 12 November 2015

Webinar: Unit Testing with SQL Server and tSQLt

I ran into Sebastian Meine at the PASS Summit a few weeks ago and we were talking testing. Sebastian is the founder and developer of tSQLt, which I really like using. We’ve done some teaching together and I’ve delivered a number of sessions on tSQLt at various events, but… Read more

2 comments, 480 reads

Posted in The Voice of the DBA on 11 November 2015

Updating Extended Properties

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

I wrote recently about adding extended properties. Updating them is very similar. There’s an analogous procedure called sp_updateextendedproperty that changes the value of properties.

The arguments are… Read more

1 comments, 375 reads

Posted in The Voice of the DBA on 11 November 2015

Poor Data Modeling – T-SQL Tuesday #72

This month Mickey Stuewe hosts the T-SQL Tuesday and she has a great topic. Data Modeling is something few people seem to do, especially developers, and it often can go wrong. That’s the topic, and I have a short story.

T-SQL Tuesday is a monthly blog party, on the… Read more

0 comments, 797 reads

Posted in The Voice of the DBA on 10 November 2015

What is the DLM Maturity Model?

I’ve written a few posts on the Redgate Software blog to try and show how I see the DLM model, and how we see things at Redgate. We have a lot of developers that work in a similar way when building application software in C#, Java, Python, or other languages,… Read more

0 comments, 414 reads

Posted in The Voice of the DBA on 9 November 2015

Rebooting SQLNewBlogger in November

I ran into Ed Leighton-Dick last week at the PASS Summit and we were chatting about the SQLNewBlogger challenge he started in April. I enjoyed it and while a number of people started, it seemed like most waned away. I tried to keep the challenge going with my own posts Read more

1 comments, 789 reads

Posted in The Voice of the DBA on 6 November 2015

The SQL Source Control Frequent Updates Channel

One of the things we do at Redgate is release software often. It’s not just that we want you to release your software often (and develop better), but we do it ourselves. Different teams release at different cadences, which is both cool, and hard to keep track of. The SQL… Read more

1 comments, 600 reads

Posted in The Voice of the DBA on 5 November 2015

Adding Extended Properties

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 needed to do recently was add some extended properties to objects. I got the idea of using them from John McClusky at SQL… Read more

4 comments, 1,314 reads

Posted in The Voice of the DBA on 4 November 2015

Looking Back at Summit 2015

Last week was the 2015 PASS Summit in Seattle. It’s the largest SQL Server specific gathering of data professionals in the world, and it’s an exciting week. If you work with SQL Server in the US and have the opportunity to attend, I’d recommend you go. If you’re in Europe,… Read more

0 comments, 403 reads

Posted in The Voice of the DBA on 3 November 2015

DLM Dashboard moves to 50 Databases – For FREE

I love DLM Dashboard. It’s the product that I’ve written myself, in various ways since SQL Server 6.5. My versions weren’t as pretty, often scripts that ran queries, returning loads of data in text format, from queries, trace, or Extended Events.

However there’s been a limitation that affected even… Read more

0 comments, 482 reads

Posted in The Voice of the DBA on 3 November 2015