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

What’s Database Drift?

The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context of the schema of your database, I can see the code “drifting” away from what you expect. Someone noticed this was a problem when implementing continuous delivery and DLM Dashboard Read more

1 comments, 159 reads

Posted in The Voice of the DBA on 22 July 2016

Rename a Primary Key–#SQLNewBlogger

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

Having system named objects is one of those things that people may debate, but as you move to more automated and scripted processes can cause you issues.… Read more

0 comments, 109 reads

Posted in The Voice of the DBA on 21 July 2016

ReadyRoll and Octopus Deploy Webinar

I’ll be hosting a webinar next week, Thursday, July 28, with Daniel Nolan (t) (founder of ReadyRoll and fellow Redgate employee) and Damian Brady (b | t) of Octopus Deploy.

We’ll be talking deployment, with demos to show you how to work with ReadyRoll for… Read more

0 comments, 143 reads

Posted in The Voice of the DBA on 21 July 2016

Growth or Control – #sqlpass

I’m disturbed.

I read an announcement from the PASS organization this week that bothers me. I am less upset with the content than the manner in which it was presented, though I am not pleased with either.

Making SQL Saturday Sustainable was released this week, with a few changes to… Read more

10 comments, 176 reads

Posted in The Voice of the DBA on 20 July 2016

Deploying Dynamic Data Masking Changes

I wrote a short piece over on the Redgate blog that covers how SQL Compare can catch and build a script to move Dynamic Data Masking (DDM) code from one database to another.

As the surface area of SQL Server programming changes, moving these items from one instance or database… Read more

0 comments, 121 reads

Posted in The Voice of the DBA on 20 July 2016

Adding the ReadyRoll Extension in VSTS

As I’m doing a little development with ReadyRoll, I’m documenting some of the things I learn about the product.

A few weeks ago I needed to do a demo with ReadyRoll for Redgate Software. I built a new project, and wanted to perform a build in Visual Studio Team Services… Read more

0 comments, 155 reads

Posted in The Voice of the DBA on 19 July 2016

Building locally from VSTS

One of the things that you need with a Continuous Integration server is that ability to build your software on some computer system and verify things work. With Visual Studio Team Services, using Visual Studio online, this seems to be a challenge.

The VSTS team has thought of this… Read more

0 comments, 738 reads

Posted in The Voice of the DBA on 18 July 2016

MeasureUp 2016

I’m heading down to Austin next weekend for MeasureUp 2016. This is a Microsoft stack conference that looks to help people build custom business software.  There are over 20 sessions, most of them devoted to .NET topics. I think I’m more excited to be in some nice company and… Read more

0 comments, 205 reads

Posted in The Voice of the DBA on 16 July 2016

Getting Table Change Scripts–#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 really basic things I think everyone should understand is how to get scripts from Management Studio (SSMS) and saving them. In fact, I’ve written… Read more

0 comments, 219 reads

Posted in The Voice of the DBA on 14 July 2016

Getting Started with Database DevOps, DLM, and New Tools

Next Tuesday is the next installment of our DLM series from Redgate. I’m off the hook, with Grant and Arneh showing off Git, Team City, and Octopus Deploy as the main tools. Register today and see how you can get started.

We’ve been running this series for a year, with… Read more

0 comments, 217 reads

Posted in The Voice of the DBA on 13 July 2016

Thanks, Karla

I heard the news this week, and I’m still sad. Karla Landrum is leaving PASS after five years of acting as the Community Evangelist.

Thank you, Karla, for all you’ve done.

In the last five years, we’ve seen tremendous growth in the SQL Saturday franchise, as well as other chapters.… Read more

1 comments, 171 reads

Posted in The Voice of the DBA on 13 July 2016

T-SQL Tuesday #80–Chris Yates’ Birthday

It’s the 80th version of T-SQL Tuesday. You can see all the parties from the past on my page, but feel free to jump in here or elsewhere. This is a monthly event, where anyone can write on a topic.

This month’s invitation is from Chris Yates, with today being… Read more

0 comments, 168 reads

Posted in The Voice of the DBA on 12 July 2016

Using sp_executesql Parameters –#SQLNewBlogger

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

I haven’t used sp_executesql much. Instead, my habitually way of executing dynamic SQL has been with EXEC(). There are a few differences between these commands, but… Read more

0 comments, 211 reads

Posted in The Voice of the DBA on 7 July 2016

Choosing Content for the Summit

This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for the first time, but on topics that I think make better events. These are opinions and thoughts, not mandates or demands. I’ve written on choosing speakers and debuting content. Read more

10 comments, 519 reads

Posted in The Voice of the DBA on 5 July 2016

Long Term Pebble Classic Review

I got a Pebble Classic watch for Christmas a few years ago, in Dec 2014 to be clear. That’s (as of now) about 18 months of use. I haven’t used it every day, but I’ve used it often, and here are a few things that I wanted to put down… Read more

2 comments, 185 reads

Posted in The Voice of the DBA on 1 July 2016

Basic XML Node Query–#SQLNewBlogger

 

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

I saw a question recently about querying an XML document. Certainly avoid this in the database if you can, but there are times you need to.… Read more

0 comments, 208 reads

Posted in The Voice of the DBA on 30 June 2016

The Desktop Rebuild–Part 3

This is the last part of this series, at least for now. If you haven’t seen Part 1 and Part 2, feel free to check them out.

After I got through Part 2, I was working again. In fact, I continued to chocotaley install a few things, but for… Read more

2 comments, 212 reads

Posted in The Voice of the DBA on 29 June 2016

Better Explorer on High dpi Displays

I’ve got a high dpi display on my laptop. The recommended resolution is 2560×1704. That’s small. I have had all kinds of issues with SSMS, VS, and various other applications, including a few from Redgate.

The other day I was looking at the Explorer window from about 2 feet away… Read more

4 comments, 161 reads

Posted in The Voice of the DBA on 29 June 2016

Better ReadyRoll Script Naming

One of the things that I like about ReadyRoll is that the product will automatically build new scripts that are named in a sequential order. This usually results in a few scripts that look like this:

As you can see, these scripts aren’t very intuitive. In fact, if you get… Read more

0 comments, 179 reads

Posted in The Voice of the DBA on 28 June 2016

The Desktop Rebuild–Part 2

You can read part 1, but that’s more about the (initial) hardware changes. This one looks at getting moving on the new desktop. Note, that since I changed the MB/CPU/Boot disk, I decided to reinstall Windows as well on a new disk to ensure I wouldn’t have more issues. Read more

1 comments, 196 reads

Posted in The Voice of the DBA on 27 June 2016

Older posts