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

Join me at VS Live – Anaheim

We’re just a month away from Visual Studio Live in Anaheim where I’ll be speaking along with many others. Join me today, register with ANSPK14 and save $400. This gives you the 4-day, all access conference package for a reduced rate.

California coding, with experts in DevOps, Cloud Computing,… Read more

0 comments, 133 reads

Posted in The Voice of the DBA on 19 September 2017

Experimenting with VSCode instead of the ISE

I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or

I saw a tweet from Rob Sewell on using VS Code for PoSh, which I’ve tried, but it felt cumbersome and hard. I didn’t spend much time on it before dropping… Read more

0 comments, 156 reads

Posted in The Voice of the DBA on 18 September 2017

I want a new gadget with less features

Years ago I bought a Pebble smartwatch. I didn’t back the Kickstarter, but a few friends did and I liked the product. I wore mine for almost two years before it started to die. I can be rough on gadgets, so it’s possible I banged it and caused my own… Read more

3 comments, 284 reads

Posted in The Voice of the DBA on 15 September 2017

The Code Coverage Report

I had someone that told me recently that they needed to find a way to get code coverage in T-SQL. Not for them, not to improve quality, but because their manager wanted a report.

OK, here it is.

First, build a nice SSRS report that displays your company logo, a… Read more

1 comments, 258 reads

Posted in The Voice of the DBA on 15 September 2017

Multi Script Removes 25 Database Limit

I woke up to a Slack message that alerted me to a post in one of our channels. An engineer noted that SQL Multi Script was being upgraded today, releasing to all channels with v 1.3.3. The post alerted me to not the release, but the fact that the… Read more

2 comments, 317 reads

Posted in The Voice of the DBA on 14 September 2017

Data Governance Survey–Still Time

Just a reminder. Redgate is doing research into data governance, and we have a small survey we’d love to get some answers to about how you view the process inside your company.

Take the Survey and be entered to win $100 gift card.

If you want to read some thoughts… Read more

0 comments, 342 reads

Posted in The Voice of the DBA on 13 September 2017

Remove an Active Lease on a Blob in Azure

I was creating and dropping VMs in Azure, and found myself charged money for disks that I thought I’d deleted. I found later that deleting a VM doesn’t necessarily remove the disk blob. Here was one way that I removed some of those blobs.

First, go to the classic portal.… Read more

0 comments, 174 reads

Posted in The Voice of the DBA on 12 September 2017

Automate Migrations–T-SQL Tuesday #94

It’s T-SQL Tuesday time again, and I’m slightly pressed for time, which is sad. This is a great topic.

Rob Sewell hosts this month with his question about what we are going to automate? He’s a PowerShell advocate, so I’m not surprised here. As much as I enjoy working… Read more

0 comments, 192 reads

Posted in The Voice of the DBA on 12 September 2017

DevOps Basics–Git Clients

This is also a part of a basic series on git and how to use it.

There are lots of git clients. If you look at the top list for this year, you’ll see quite a few. I’ve used a couple of these, but they all give you roughly… Read more

2 comments, 1,308 reads

Posted in The Voice of the DBA on 7 September 2017

Game Night is Back at the Summit

Last year Andy Warren and I worked out a deal with the PASS organization to sponsor a game night on Thursday evening since there were no official events. The event went well, with way more attendance than we expected. I was actually amazed at the number of people that… Read more

0 comments, 486 reads

Posted in The Voice of the DBA on 5 September 2017

A Trip Across the Pond for the Community Hub

The Redgate Community Hub is out, and people are starting to use it. It’s a an idea that we think will provide our customers, and potential customers, a better way to learn about our products, get information, and learn from Redgate.

Annabel Bradford and I are going to be introducing… Read more

0 comments, 522 reads

Posted in The Voice of the DBA on 4 September 2017

Livestreaming the Redgate Hub for the US

The Livestream launch for the Redgate Community Hub is next Wednesday, Sept 6, 2017. To ensure that our customers and friends in the US and the rest of the this hemisphere can enjoy the festivities, we are broadcasting at 8pm GMT.

Register today and watch us live.

I’m flying to… Read more

0 comments, 209 reads

Posted in The Voice of the DBA on 1 September 2017

Bulk Inserting Build Data–#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 common tasks that many DBAs need to do is insert data into a database. Often this comes from various sources, but a CSV (comma separate… Read more

2 comments, 192 reads

Posted in The Voice of the DBA on 31 August 2017

Getting the Hyperlink from Excel

I had a spreadsheet of data that contained hyperlinks. In this case, it was a series of Microsoft Knowledge Base Articles with a hyperlink associated with them. I would assume there’s an easy function in Excel to extract these, but apparently there isn’t. That’s certainly a useful function for a… Read more

2 comments, 256 reads

Posted in The Voice of the DBA on 30 August 2017

The Game Night Poll

This year we’ve handed off Game Night to the PASS organization and it’s an official event. Volunteers from the community will help setup, manage, and tear down the event. Kevin Hill is taking the lead, but if you’re willing to help run the night, let he or I know.… Read more

1 comments, 248 reads

Posted in The Voice of the DBA on 29 August 2017

The World of MySQL

I had two different people ping me on the same day with MySQL questions. One was a former co-worker, asking for some query help, and one was from the Boy Scouts of America, also asking for some query help for a few reports. Strange that both requests came on the… Read more

3 comments, 213 reads

Posted in The Voice of the DBA on 28 August 2017

Responsible Log Growth with dbatools

I love dbatools, and I’ve been trying to explore the various cmdlets over time, both to practice my PoSh and see if there are easier ways of accomplishing some tasks.

Recently I was browsing the dbatools.io site to see what’s changed and noticed a new cmdlet, Expand-DbaLogResponsibly and just had… Read more

0 comments, 1,310 reads

Posted in The Voice of the DBA on 25 August 2017

Adding a New Default to a Column

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

This is a fairly simple process, but I bet more than a… Read more

0 comments, 231 reads

Posted in The Voice of the DBA on 21 August 2017

Using Merge–#SQLNewBlogger

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

I was playing with some data, loading it into staging tables and then moving it to a real table. I typically have done this with T-SQL, writing efficient… Read more

2 comments, 610 reads

Posted in The Voice of the DBA on 14 August 2017

T-SQL Tuesday #93–Interviewing Patterns

It’s time for T-SQL Tuesday, and this is a good topic. Not too close to T-SQL, but certainly something many people are interested in.

Kendra Little hosts this month, and her topic is interviewing patterns and anti-patterns. Things that are good, or things that might appear good, but are… Read more

0 comments, 237 reads

Posted in The Voice of the DBA on 8 August 2017

Older posts