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

Adding a New Default to a Column

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

This is a fairly simple process, but I bet more than a… Read more

0 comments, 109 reads

Posted in The Voice of the DBA on 21 August 2017

Using Merge–#SQLNewBlogger

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

I was playing with some data, loading it into staging tables and then moving it to a real table. I typically have done this with T-SQL, writing efficient… Read more

0 comments, 466 reads

Posted in The Voice of the DBA on 14 August 2017

T-SQL Tuesday #93–Interviewing Patterns

It’s time for T-SQL Tuesday, and this is a good topic. Not too close to T-SQL, but certainly something many people are interested in.

Kendra Little hosts this month, and her topic is interviewing patterns and anti-patterns. Things that are good, or things that might appear good, but are… Read more

0 comments, 194 reads

Posted in The Voice of the DBA on 8 August 2017

The 2017 Data Platform Summit

I’m off in a couple days to India for a week of vacation and then the 2017 Data Platform Summit. This is my first time attending, and I’m excited to go. A new country to visit and present in.

In addition to the sessions listed above, I’ve got a pre-con… Read more

0 comments, 224 reads

Posted in The Voice of the DBA on 4 August 2017

Checking Your Database Properties–#SQLNewBlogger

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

I was reading Grant’s Database Fundamental Series on Database Properties, and it got me thinking. I think this is a good set of knowledge to have, but building… Read more

0 comments, 203 reads

Posted in The Voice of the DBA on 3 August 2017

MSBuild and Azure SQL Database

I saw a report of a problem building a database with ReadyRoll in Azure SQL Database. This person wanted to use a local Shadow database in LocalDB and target an Azure SQL Database. I hadn’t build that config, so I decided to give it a try.

I ended up with… Read more

0 comments, 395 reads

Posted in The Voice of the DBA on 2 August 2017

SSoL: Adding disk space with a repartition

I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember the skills I used to have back in university. Read more

4 comments, 234 reads

Posted in The Voice of the DBA on 1 August 2017

Backup Log to Nul– #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

There are times when you might be working on your demo/lab system… Read more

4 comments, 881 reads

Posted in The Voice of the DBA on 31 July 2017

Using Test-DbaOptimizeForAdHoc

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions.

One of the cmdlets is Dba-OptimizeForadHoc, which is designed to help you determine if this… Read more

0 comments, 193 reads

Posted in The Voice of the DBA on 28 July 2017

Azure Labs–Minor Cluster Issues for SQL Server Setup

During the process of building an Azure lab, I ran into a place where my cluster was not completely validated. I think this happened when a node failed and was re-provisioned, but in any case, when I ran SQL Server setup, the program failed cluster validation and would not install. Read more

0 comments, 196 reads

Posted in The Voice of the DBA on 27 July 2017

DevOps–Fixing Poorly Named Constraints

I was building some code the other day and kept getting problems in my deployment for a change. The deployment was having issues, and this came down to this statement.

ALTER TABLE EventLogger DROP CONSTRAINT [PK__EventLog__5E548648B043C0BC]

The problem was that this was the constraint on one developer’s workstation, but on… Read more

1 comments, 1,369 reads

Posted in The Voice of the DBA on 26 July 2017

SSoL: Where are my data and log files?

I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember the skills I used to have back in university. Read more

0 comments, 329 reads

Posted in The Voice of the DBA on 25 July 2017

FizzBuzz–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

There’s been a programmer test that was used for awhile to see… Read more

3 comments, 231 reads

Posted in The Voice of the DBA on 24 July 2017

Lots of Resources

I’ve got a small Azure subscription, but there are a lot of resources in my mini lab. Forty seven, to be exact right now.

When I look at my bill, it’s got lots of details, but not always easy to understand.I get a breakdown and burn rate.

I can also… Read more

2 comments, 202 reads

Posted in The Voice of the DBA on 20 July 2017

Back to the Big Easy and SQL Saturday #628 in Baton Rouge

I’ve been fortunate enough to get to the Baton Rouge SQL Saturday a number of times. I think I’ve been 3 times and am heading back in a week for my fourth.

This is an amazing event, one of the largest in the country. I’ve met people from Texas to… Read more

2 comments, 172 reads

Posted in The Voice of the DBA on 20 July 2017

DevOps Basics–Git log

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

In a few previous posts I’ve looked at getting going with git,… Read more

2 comments, 1,267 reads

Posted in The Voice of the DBA on 19 July 2017

SQL Server 2017 RC1 is Here

And I’ve got it.

Glenn Berry posted a a link to the MSDN blog and almost immediately a note that the link was still the CTP. I decided to fire up my Ubuntu install and check. No updates there, though a few people reported Docker had the new bits.

A… Read more

2 comments, 1,504 reads

Posted in The Voice of the DBA on 18 July 2017

PowerShell $env Variables

I was playing with containers the other day, reading a Simple Talk article on the topic, and noticed the code in PowerShell (PoSh) used the $env:xx syntax for variables. I know I’ve seen this before, but for some reason this struck me as something I knew little about.

I decided… Read more

0 comments, 1,538 reads

Posted in The Voice of the DBA on 17 July 2017

T-SQL Tuesday #92–Hard Lessons

A quick post, written last week as I’m relaxing in the mountains.

This month the topic is lessons learned the hard way, from Raul Gonzalez. It’s interesting, and certainly one where I have experience. I make mistakes regularly, though I tend to fix them.

You can read more… Read more

0 comments, 254 reads

Posted in The Voice of the DBA on 11 July 2017

Bash on Windows

With SQL Server coming on Linux, some people will want to learn a bit of Linux. Or perhaps they need to get re-acquainted with the OS, which is my situation. I grew up on DOS, but moved to Unix in university. I’ve dabbled in Linux over the years, but with… Read more

0 comments, 368 reads

Posted in The Voice of the DBA on 7 July 2017

Older posts