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

Archives: March 2016

Protecting the SA Account

The sa account is a well, known, built in account for SQL Server. Years ago, in previous

versions, I’d see people often use the “sa” account for development, usually with a blank password. Even those speakers and experts often showed demo code with a blank “sa” password.

Ugh, a horrible… Read more

0 comments, 476 reads

Posted in The Voice of the DBA on 29 March 2016

SQL Nexus in Copenhagen

The Nordic SQLNexus conference is taking place in Copenhagen on May 2-4. I’ve never been to the event, or the country, but I was accepted to speak, so I embark on another multi-city, multi day trip.

SQLNexus has quite a lineup, and I suspect a few of these people will… Read more

0 comments, 367 reads

Posted in The Voice of the DBA on 28 March 2016

The OUPUT Clause in an INSERT–#SQLNewBlogger

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

I got asked a question about the OUTPUT clause recently and realized I didn’t remember the syntax. I’ve rarely used this, so I had to look it… Read more

3 comments, 2,538 reads

Posted in The Voice of the DBA on 23 March 2016

SQLBits in Space

It’s coming in May. The official UK SQL Server 2016 launch event is SQL Bits and the conference returns to Liverpool on May 4-7.  With a fun theme.

Check out the launch video here: SQLBits XV

Update (Mar 24): The agenda is live. I’m speaking Saturday at 2:30pm.

There… Read more

0 comments, 1,187 reads

Posted in The Voice of the DBA on 22 March 2016

SQL Data Generator –Specific Domains for a Column

I was mocking up some test data and wanted to limit my list of values to specific items. In this case, I was modeling the game, Rock Paper Scissors. In my modeling, I had a field for the value played by someone. In this case, I used a text… Read more

0 comments, 1,281 reads

Posted in The Voice of the DBA on 21 March 2016

What Database am I in?

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

I saw someone trying to get the database context recently and they were confused. They had some code referencing @dbname, but received an error with this code.… Read more

0 comments, 366 reads

Posted in The Voice of the DBA on 17 March 2016

SQL Source Control v5.0 Beta–First Migration Script

I joined the beta program for SQL Source Control recently. I know, I work for Redgate, I should be in all beta programs. However I present on our various products, and I need those presentations  to work reliably. As a result, I rarely get ahead of our RTM products because… Read more

0 comments, 486 reads

Posted in The Voice of the DBA on 16 March 2016

Working on the Road

I spend a decent amount of time on the road, traveling to events. Last year I think I spent 50 nights in hotels for work. That’s a fair amount, and it can be challenging to get everything I need to accomplish done in those situations. I’ve gotten good at ensuring… Read more

2 comments, 370 reads

Posted in The Voice of the DBA on 15 March 2016

Finding Strings

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

A quick one today, just looking for strings. I wrote an article on this, so there’s more detail there, but here’s a bit of code you… Read more

0 comments, 379 reads

Posted in The Voice of the DBA on 11 March 2016

Converting SQL Backup Files to MTF

I got a copy of some backup files recently and needed to restore them. However, I don’t have SQL Backup installed on all my instances. It’s not a big deal to install it, but since this is a one-off, I decided to just decompress the files.

The documentation for SQL… Read more

0 comments, 746 reads

Posted in The Voice of the DBA on 8 March 2016

Restoring a Striped Backup–#SQLNewBlogger

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

Recently I uncompressed some SQL Backup Pro files. Since multiple threads were used to make the backup, I ended up with multiple files in my file system,… Read more

2 comments, 771 reads

Posted in The Voice of the DBA on 7 March 2016

PowerShell–Don’t Use Write-Host

I’ve written a few scripts and programs lately, mostly just for fun. In those scripts, I’ve used Write-Host to return output. To me, it’s been like “Print” in various languages where I can get output of a program. Often I’ll use a method/function to get info and then use print… Read more

2 comments, 664 reads

Posted in The Voice of the DBA on 4 March 2016

Quick Folder Size with PowerShell

This is a fairly simple idea, and one I’m sure many people have done in the past. Personally, I have tended to just hover a mouse over a folder when I want a size. That seems to work fairly well, but not only is it slow, it’s not programmatic.

I… Read more

2 comments, 689 reads

Posted in The Voice of the DBA on 2 March 2016