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

What’s a SQL Compare Snapshot?

I saw a short video from Grant Fritchey on the Redgate channel that shows how to cerate a snapshot in SQL Compare. I think snapshots are great, and there are lots of uses (more on that later), but I do find sometimes I use the term and people are confused. Read more

0 comments, 358 reads

Posted in The Voice of the DBA on 21 September 2017

Test Database Compatability with dbatools

I really like the dbatools project. This is a set of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

One of the items that few DBAs think… Read more

0 comments, 1,894 reads

Posted in The Voice of the DBA on 20 September 2017

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, 296 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, 319 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, 735 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

5 comments, 699 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, 2,188 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, 720 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, 274 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, 278 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,580 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, 686 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, 695 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, 270 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, 318 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, 349 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, 336 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, 285 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,498 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, 304 reads

Posted in The Voice of the DBA on 21 August 2017

Newer posts

Older posts