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

New Video Cards

When I want to upgrade hardware, I usually turn to Glenn Berry for advice. He’s the person I know that really watches, examines, and evaluates computer hardware. He gives good advice and upgrades often, so he actually uses the latest hardware.

One of the upsides of his hobby is that… Read more

1 comments, 232 reads

Posted in The Voice of the DBA on 13 January 2017

Do I have a Database Master Key in a database? #SQLNewBlogger

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

How can I tell if I have a Database Master Key in a database? It’s actually easy. I query the sys.symmetric_keys DMV for data. If I get… Read more

0 comments, 1,591 reads

Posted in The Voice of the DBA on 13 January 2017

Installing the SQL Clone Agent and the VC++ Runtime

I was trying to get SQL Clone working recently and had an issue with the Agent. If you haven’t looked at SQL Clone, it’s a really cool product from Redgate that’s in beta right now. It will help you build and provision those large dev, test, customer service, etc. environments… Read more

1 comments, 251 reads

Posted in The Voice of the DBA on 13 January 2017

Vote for @SQLBits Sessions (pick me, pick me)

The SQL Bits sessions are out and it’s time to vote for me. Well, vote for the sessions you’d like to see, but certainly include me in the list. I’ve got a few new ones, and a few that have been popular at other conferences. I am hoping to return… Read more

1 comments, 235 reads

Posted in The Voice of the DBA on 12 January 2017

More #SQLintheCity–Behind the Scenes

I posted this, but here it is again. A a shot from our engineer, behind the scenes of my live talk today.

//platform.twitter.com/widgets.js

 

When we decided to stream… Read more

0 comments, 217 reads

Posted in The Voice of the DBA on 11 January 2017

Getting Started Blogging–#SQLNewBlogger

It’s a new year, and the perfect time for you to start blogging about your SQL Server work. I think blogging is a great way to showcase your knowledge, and over time, this can become as important to your potential employers and clients as your resume or CV.

This… Read more

2 comments, 352 reads

Posted in The Voice of the DBA on 9 January 2017

Easy Database Space with dbatools

One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is one of the most common questions posted on SQLServerCentral by newbies that are trying to manage their instances and ensure they don’t use too much space or run out of… Read more

7 comments, 2,034 reads

Posted in The Voice of the DBA on 6 January 2017

Watch the Manual DBA v Automated Deployment Challenge

At last year’s SQL in the City, I played the part of a manual DBA making changes and deploying those from development to test, staging, and production environments. Actually, I don’t think we went to production because I didn’t have time.

My co-worker, Tom Austin, showcased the automated process… Read more

3 comments, 1,218 reads

Posted in The Voice of the DBA on 5 January 2017

Quick Prompt Tips–Custom Procedure Templates

One of the things that I often do is create stored procedures. The syntax for doing so is simple, but it has a number of items that need to be included. SQL Prompt makes this much quicker with the “cp” snippet. When I type “cp”, I get this:

I can… Read more

0 comments, 253 reads

Posted in The Voice of the DBA on 4 January 2017

Be Careful of Your Create Stored Procedure Batch

I was rehearsing a demo with someone recently and we had some stored procedure code that looked like this:

CREATE PROCEDURE UpdateEmpID @empid INT
 AS
 BEGIN
 UPDATE  dbo.Employees
 SET empid = 3
 WHERE  empid = @empid
 ;
 END

However, this was part of a batch that had all of this… Read more

0 comments, 760 reads

Posted in The Voice of the DBA on 3 January 2017

Starting with Chocolatey

I ran across Chocolatey years ago when Scott Hanselman wrote about it in his power tool list. At the time, I wasn’t in need of the tool, but I thought it was cool and tried it. I was hooked.

In fact, the next year I got two different laptops,… Read more

4 comments, 2,517 reads

Posted in The Voice of the DBA on 2 January 2017

Checking Permissions for Keys–#SQLNewBlogger

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

I got a call from someone wanted to check how permissions were stored for encryption objects. I ran a quick double check for them and decided to… Read more

0 comments, 1,157 reads

Posted in The Voice of the DBA on 29 December 2016

Post TDE–Getting Unencrypted Backups

I saw a question posted recently about someone that had disabled TDE and was still having issues restoring a backup. This doesn’t seem like that should be an issue, but it can be. A little testing shows how.

Let’s assume I have an encrypted TDE database. If I run a… Read more

2 comments, 389 reads

Posted in The Voice of the DBA on 28 December 2016

New Formatting in #SQLPrompt

I love SQL Prompt. This might be my favorite tool from Redgate Software and just when I thought it couldn’t be any better, a new formatting engine has been released.

Reading through existing source code and understanding the intent is an important part of any software developer’s life. Often,… Read more

1 comments, 242 reads

Posted in The Voice of the DBA on 27 December 2016

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, 246 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, 252 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, 402 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, 195 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, 230 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, 216 reads

Posted in The Voice of the DBA on 13 December 2016

Newer posts

Older posts