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

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, 304 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, 309 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, 194 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, 273 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, 244 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, 728 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, 277 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, 217 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, 605 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, 243 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, 604 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, 387 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,090 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, 226 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, 232 reads

Posted in The Voice of the DBA on 3 November 2015

No Live Blogging

The PASS Summit opens today with the first keynote. This is one of the few times that I’ve declined the blogging table at PASS. The table has grown, it’s become a bit loud at times, and the pressure to take notes and push them out distracts me from listening and… Read more

0 comments, 211 reads

Posted in The Voice of the DBA on 28 October 2015

No Live Blogging

The PASS Summit opens today with the first keynote. This is one of the few times that I’ve declined the blogging table at PASS. The table has grown, it’s become a bit loud at times, and the pressure to take notes and push them out distracts me from listening and… Read more

0 comments, 168 reads

Posted in The Voice of the DBA on 28 October 2015

A Great SQL in the City 2015 Seattle

Yesterday was the Seattle edition of the 2015 Redgate Software SQL in the City tour. I was in London a couple weeks ago for the first event, and we closed out the year in Seattle on Monday.

I had some, fun, as you can see here.

Slava Murygin has a… Read more

0 comments, 150 reads

Posted in The Voice of the DBA on 27 October 2015

A Great SQL in the City 2015 Seattle

Yesterday was the Seattle edition of the 2015 Redgate Software SQL in the City tour. I was in London a couple weeks ago for the first event, and we closed out the year in Seattle on Monday.

I had some, fun, as you can see here.

Slava Murygin has a… Read more

0 comments, 261 reads

Posted in The Voice of the DBA on 27 October 2015

Networking Tonight at the YardHouse in Seattle

I’m heading over to the Yardhouse (4th and Pike) as soon as SQL in the City is finished and should be there by 6. Andy Warren will likely be there earlier, so look for him. If you don’t know Andy, he looks like this:

This is me, though I’ll probably… Read more

1 comments, 236 reads

Posted in The Voice of the DBA on 26 October 2015

Newer posts

Older posts