Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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

tSQLt in Azure SQL Database

I was excited to hear about the v12 Azure databases supporting CLR assemblies. Mainly because I’ve been doing testing work with tSQLt and wanted to run tests in an Azure database.

I upgraded a SQL Azure database to v12 and connected in SSMS. My first step was to open the… Read more

0 comments, 114 reads

Posted in The Voice of the DBA on 27 August 2015

The Log Chain

I ran across a question recently from someone that received a similar message to the one showed in this image:

In this case, the log chain is broken. I’ve received this message, usually from a script that is automatically restoring all the logs in a folder. I’ve also had clients… Read more

0 comments, 170 reads

Posted in The Voice of the DBA on 25 August 2015

Pick the Right Database in Azure

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

Another quick post, because this is something that’s annoyed me regularly. Hopefully writing this will help me make fewer mistakes.

Let’s suppose you have an Azure SQL Database.… Read more

0 comments, 134 reads

Posted in The Voice of the DBA on 24 August 2015

Changing Cell Phones Again

Slightly off topic, but since I use a cell phone so much for data transfer and work, it’s important that my device works for me. This is my current thought and experience, so take it with a grain of salt.

I want to talk about my experience with Verizon and… Read more

0 comments, 238 reads

Posted in The Voice of the DBA on 20 August 2015

Creating an SQL Databases – New Portal

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

I was looking to do some testing recently, but needed a v12 SQL Azure database. The test system that I have in Azure is v11, and I needed… Read more

1 comments, 210 reads

Posted in The Voice of the DBA on 19 August 2015

Create a SQL Azure Database–Old Portal

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

I worry about beta software, so when I wanted to create a new Azure database, I stuck with the old portal. Call me nervous, but the new portal… Read more

2 comments, 182 reads

Posted in The Voice of the DBA on 18 August 2015

SQL Saturday #403–Louisville

This weekend I’ll be attending SQL Saturday #403 in Louisville, KY. If you’re in the area, think about taking a few hours out of your Saturday and coming to learn some SQL Server stuff. There’s a great schedule, with 6 tracks and 6 sessions per track.

That’s 36 opportunities… Read more

0 comments, 168 reads

Posted in The Voice of the DBA on 17 August 2015

Catch up with T-SQL Tuesday

T-SQL Tuesday is a monthly blog party where we get an invitation the first week of the month to write on a specific topic for the second Tuesday of that month. Adam Machanic came up with the idea and he chooses the hosts.

If you’re interested in hosting, contact him. Read more

0 comments, 1,766 reads

Posted in The Voice of the DBA on 14 August 2015

T-SQL Tuesday #69–Encryption

This is a good T-SQL Tuesday topic for me. This month Ken Wilson asks everyone to write on encryption, which is a topic I’ve presented on quite a few times.

You can participate, too. Take a few hours, learn something, and tell us what you learned. Let everyone know… Read more

0 comments, 211 reads

Posted in The Voice of the DBA on 11 August 2015

Maturing Your Database Development Process–Version Control

At Redgate Software, we have a progression of the stages of a database development pipeline. These are the various ways in which you can better engineer your database development to ensure smoother releases to production, with less issues. There are five stages:

  • Manual (S0)
  • Source Control (S1)
  • Continuous Integration (S2)

Read more

0 comments, 1,098 reads

Posted in The Voice of the DBA on 6 August 2015

Loading XML Data–CONVERT Option 2

I was playing around with some XML lately, and had to load a file that looked like this::

I ran a simple query, one that used the OPENROWSET and a CONVERT to load the data.

WITH XmlFile (Contents) AS (
SELECT CONVERT (XML, BulkColumn) 
FROM…

Read more

4 comments, 184 reads

Posted in The Voice of the DBA on 6 August 2015

Connecting, Saving, Discarding, Branching, and Merging in the Big Apple

We’ve got another DLM workshop on Database Source Control taking place in New York City on August 27. It’s in Manhattan, at the Microsoft office all day, with lots of hands on labs to help you learn a number of skills:

  • connecting your database to a VCS with SQL Source…

Read more

0 comments, 702 reads

Posted in The Voice of the DBA on 6 August 2015

Start SQL Server in Single User Mode

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

I saw someone recently ask how to reset the sa password, and myself (along with a few others) suggested starting SQL Server in single user mode as an… Read more

0 comments, 426 reads

Posted in The Voice of the DBA on 3 August 2015

Clearing Out a Database With SQL Compare

I ran into a question recently about how to clear out a database of all objects. I assume someone was testing some type of deployment scenario, and didn’t want to drop the database, but rather just remove objects and redeploy.

I know SQL Compare could do this, so I mocked… Read more

0 comments, 334 reads

Posted in The Voice of the DBA on 3 August 2015

Using the DAC

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

The DAC is a really important tool for anyone managing a SQL Server. You might not use it often, but when you need it, you really need it.… Read more

0 comments, 183 reads

Posted in The Voice of the DBA on 3 August 2015

Halloween at PASS–Donate for some fun

This year’s PASS Summit will end on Oct 30, which is just before Halloween in the US. I’m sure lots of people will have some fun on Friday, though I also suspect we’ll see no shortage of people leaving early to get home to spend the holiday with families.

A… Read more

1 comments, 773 reads

Posted in The Voice of the DBA on 29 July 2015

Password for SQL Server Service Accounts

I wrote recently about my philosophy for service accounts, and wanted to add a few more thoughts.

Security is important for our database servers. One of the loopholes that everyone should be aware of is that the service running SQL Server has complete control over the service and potentially… Read more

0 comments, 665 reads

Posted in The Voice of the DBA on 28 July 2015

Culture Differences: US v UK

This is a bit of an off topic post from the technical stuff, but there’s a bit of a tie-in, so stick with me.

I had to get a tire fixed this morning. I actually owned a replacement tire, so I just needed someone to mount it on the existing… Read more

0 comments, 222 reads

Posted in The Voice of the DBA on 27 July 2015

Get Away from the Heat and Learn some Database Version Control

I have enjoyed the trips I’ve made to New Orleans and Baton Rouge in the past. It’s a good getaway, stopping in the French Quarter for a few minutes before an easy drive up the road. However it’s warm, and I can’t ever get my wife or kids to come… Read more

2 comments, 102 reads

Posted in The Voice of the DBA on 24 July 2015

My SQL Server Service Account Philosophy

Recently someone sent me a question about service accounts. They weren’t sure how they should go about setting accounts up for various instances and services in their environments. Specifically they asked me about having domain accounts, or accounts separate for services.

Note that I’ve managed SQL Server for years this… Read more

2 comments, 57 reads

Posted in The Voice of the DBA on 23 July 2015

Older posts