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

Delete an Azure SQL Database from PowerShell

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’ve been working on is trying to get my DevOps, continuous delivery pipeline working with Azure. Part of that is a test deployment… Read more

0 comments, 123 reads

Posted in The Voice of the DBA on 22 March 2017

Building a Database DevOps Process at the Data Platform Summit 2017

I’m heading to India this August for the Data Platform Summit 2017. I am honored to have been selected to deliver a pre-conference seminar called “Building a Database DevOps Process”, where I’ll walk through the way in which you can include your database alongside application code and deploy it… Read more

2 comments, 127 reads

Posted in The Voice of the DBA on 21 March 2017

SQL Bits in less than a month

I’m getting excited, and you should as well. Join me at a fantastic conference in the UK this spring. Register today and come to a training day and learn something. I might just see you there, as I’m thinking to take one or two myself.

I’ll be presenting “Including Your… Read more

0 comments, 148 reads

Posted in The Voice of the DBA on 17 March 2017

Global v Session Trace Flags

I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss the implications of session v global trace flags, which is something I’d like to do here.

In the article, I set trace flag 3226 for my session. This showed… Read more

0 comments, 164 reads

Posted in The Voice of the DBA on 16 March 2017

Create a BACPAC–#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 things that you might encounter at some point is the need to create a BACPAC. This is essentially a DACPAC with data included. There… Read more

0 comments, 151 reads

Posted in The Voice of the DBA on 15 March 2017

The Livestream Product Launch

SQL in the City Streamed in 2016 was a success, with lots of feedback that people enjoyed the sessions and format. With the release of SQL Clone, we’ve decided to do it again.

The SQL Clone Product Launch Live Stream is coming in a couple weeks, on Mar 29,… Read more

0 comments, 178 reads

Posted in The Voice of the DBA on 15 March 2017

T-SQL Tuesday #88 – WTF

It’s T-SQL Tuesday time again, and this is a good one. The host this month is Kennie Pontoppidan, who I had the pleasure of running with one morning in Copenhagen. His theme is The daily (database-related) WTF.

You can read about T-SQL Tuesday at tsqltuesday.com and see all… Read more

0 comments, 280 reads

Posted in The Voice of the DBA on 14 March 2017

Using tSQLt to Find Min/Max Times

I love tSQLt. It’s a good way to write tests that can determine if your code is actually working. Since I’m a fan of unit testing, I think using tests to verify your logic is great. What’s excellent with tSQLt is that I can verify a number of cases at… Read more

0 comments, 426 reads

Posted in The Voice of the DBA on 13 March 2017

Create a DACPAC to Move Databases–#SQLNewBlogger

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

In my last post, I talked about what a DACPAC was. Now let’s create one. This turns out to be about as simple as it could be.… Read more

1 comments, 223 reads

Posted in The Voice of the DBA on 8 March 2017

The $650 SQL Saturday

SQL Saturday #596 – Denver BI Edition was held on Feb 25, 2017. In keeping with my idea for a slimmer SQL Saturday, we ran this event for a total of $650. It’s not quite the $500 that Andy Warren challenged me to stick to, but it’s close.

We could… Read more

5 comments, 1,162 reads

Posted in The Voice of the DBA on 7 March 2017

Dots, Skills, and SQL Clone: A Contest from Redgate

Redgate just launched SQL Clone, a new product that can provision copies of databases in seconds. By copies, I mean full sized, up to 2TB copies of your database, each separate and isolated, and built in seconds. What’s even more amazing is that each of these copies takes just… Read more

10 comments, 902 reads

Posted in The Voice of the DBA on 6 March 2017

Implicit Time Conversions – #SQLNewBlogger

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

I was trying to work with times recently and needed to get the current time. I thought, well, Getdate(), or better yet, SysDateTime() will give me a… Read more

0 comments, 255 reads

Posted in The Voice of the DBA on 2 March 2017

How Do You Use SQL Clone?

On Monday, Redgate released v1.0 of SQL Clone, and I’m excited that the product is finally available. I’m excited because this has been a long time coming, but it’s worth the wait.

You can certainly download SQL Clone and try it out, but I’d also say you should check… Read more

0 comments, 220 reads

Posted in The Voice of the DBA on 1 March 2017

TSQLTuesday.com

I’ve hosted a page on this blog that has all the T-SQL Tuesday blog invitations and roundups linked. I did this mainly because I was trying to ensure I have hosted a few, I wanted to know what others had chosen. Since I didn’t see a good list, I created… Read more

2 comments, 1,133 reads

Posted in The Voice of the DBA on 28 February 2017

Speaking at VS Live–Austin

I’ll be speaking at Visual Studio Live – Austin in May 2017. I was fortunate to be selected to speak again, after my first two VS Lives last year in DC and Orlando. I’m excited to go back, as the conference is a lot of fun, and Austin is a… Read more

0 comments, 239 reads

Posted in The Voice of the DBA on 27 February 2017

Upgrading SQL Server on Linux

I saw this week that there was a new CTP (v1.3) of SQL Server v.Next. I haven’t had a lot of time to work on the Linux version lately, but I thought I’d try and see how well the upgrade went.

There’s an install and upgrade page at Microsoft you… Read more

0 comments, 1,499 reads

Posted in The Voice of the DBA on 23 February 2017

What’s a DACPAC and a BACPAC?

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

If you’ve worked with SQL Server development and database projects, you might have heard about DACPACs. However, if you haven’t, this was a concept that didn’t seem… Read more

1 comments, 281 reads

Posted in The Voice of the DBA on 22 February 2017

Heading Back to SQL Bits

I’m honored to be selected to speak at SQL Bits 2017 this April in Telford. This is my favorite SQL Server conference, and it’s always a joy to attend. Especially the Friday night party, where everyone seems to have a lot of fun.

I’ll be presenting “Including Your Database in… Read more

0 comments, 229 reads

Posted in The Voice of the DBA on 21 February 2017

DevOps Webinar Tomorrow

A quick reminder that tomorrow, Feb 21 at 12pm EST, I’ll be hosting another DevOps, Database Lifecycle Management (DLM) webinar. Together with Arneh Eskandari, we’ll show how we can each make changes to our own database, push the changes to git and reconcile merge issues.

Register now, and… Read more

0 comments, 240 reads

Posted in The Voice of the DBA on 20 February 2017

SQL Clone and Encryption

I’ve been testing and working with SQL Clone for the last few months, trying to help the devs at Redgate ensure this product is ready to go when it’s released. I’ve written a few pieces on this blog, and I’ve got a new one up on the Redgate blog that… Read more

0 comments, 1,113 reads

Posted in The Voice of the DBA on 15 February 2017

Older posts