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

Reminder: Extending DevOps Practices to SQL Server Databases with Redgate

I’m hosting a  new webinar on the DLM tools from Redgate Software and database DevOps. Tomorrow, Tues, Jan 17, at noon EST, Arneh Eskandari, a great sales engineer, will be demoing the tools and techniques to deploy changes.

You can register here and I’ll talk to you on tomorrow. Read more

0 comments, 49 reads

Posted in The Voice of the DBA on 16 January 2017

The Top 20 SQL Toolbelt Tips

Redgate produces some great software, and I’m glad that I get to use all of them as a developer and DBA. I use many of the tools each week, some daily, but I constantly find that there are plenty of features, tips, and tricks that I don’t know about.

At… Read more

0 comments, 45 reads

Posted in The Voice of the DBA on 16 January 2017

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, 140 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, 138 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

0 comments, 127 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, 159 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, 124 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, 218 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

2 comments, 306 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

0 comments, 1,029 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, 192 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, 667 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,236 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, 899 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

1 comments, 315 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

0 comments, 182 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, 191 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, 196 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, 361 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, 153 reads

Posted in The Voice of the DBA on 13 December 2016

Older posts