-->
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: October 2017

DevOps Basics – Ignoring Files in Git

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.

One of the things you’ll run into at times is the need… Read more

1 comments, 1,081 reads

Posted in The Voice of the DBA on 30 October 2017

Basic FORMATting– #SQLNewBlogger

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

I saw the addition of FORMAT() to the T-SQL language, but didn’t play with it much. Recently it appeared in some code, and decided to experiment a bit.… Read more

0 comments, 963 reads

Posted in The Voice of the DBA on 25 October 2017

Redgate at Summit 2017

I’ll be heading out to the PASS Summit next week, spending Halloween in a conference center with a lot of other geeks. I know some of you won’t make it, and we’ll miss you, but I understand.

I’m meeting my colleagues from Redgate there, including the new editor of Simple… Read more

1 comments, 994 reads

Posted in The Voice of the DBA on 24 October 2017

SQL Clone Server Service Permissions

SQL Clone is amazing, and it can really save time and disk space for many organizations. I’ve got a series posted here on various little things I’ve learned about the product. There are also a number of articles on the Redgate Community Hub.

I was working on helping a… Read more

0 comments, 816 reads

Posted in The Voice of the DBA on 23 October 2017

Monday Night Networking at Summit 2017

Next week is the PASS Summit in Seattle. Thousands of SQL Server professionals are going, many coming Sunday or Monday for a pre-conference session before the main event. For a number of years, Andy Warren and I have run a networking dinner on Monday night, but we’re stepping back this… Read more

2 comments, 277 reads

Posted in The Voice of the DBA on 23 October 2017

SQL Data Generator–Getting a value based on another column

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it, SQL Data Generator is a part of the SQL Toolbelt. Give it a try today with an evaluation today.

One of the things that people often want to… Read more

0 comments, 1,050 reads

Posted in The Voice of the DBA on 19 October 2017

Rebooting Ubuntu Linux from the Command Line–#SQLNewBlogger

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

Since SQL Server 2017 is now out, and Linux is an option, I thought I’d write a bit more about little Linux things that admins might want to… Read more

0 comments, 276 reads

Posted in The Voice of the DBA on 18 October 2017

Quick SQL Prompt Updates in a Pattern

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool.  SQL Prompt will be yours as well if you give it a try.

We had a customer post a question today… Read more

0 comments, 938 reads

Posted in The Voice of the DBA on 17 October 2017

Using Backup-DbaDatabase for a Quick Backup

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. I have a short series on these items.

One of the core tasks of a DBA… Read more

0 comments, 349 reads

Posted in The Voice of the DBA on 16 October 2017

Getting the Random Module in SQL Data Generator

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it, SQL Data Generator is a part of the SQL Toolbelt. Give it a try today with an evaluation today.

I have SQL Data Generator, and use it regularly… Read more

0 comments, 322 reads

Posted in The Voice of the DBA on 12 October 2017

WAITFOR isn’t a function–#SQLNewBlogger

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

I needed to delay the execution of some code the other day. This was a test that was trying to simulate a few things happening, and one batch… Read more

0 comments, 874 reads

Posted in The Voice of the DBA on 11 October 2017

Using xp_delete_file

First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions, so you’d be better served by using Powershell or some other type of scripting mechanism. This procedure is not supposed to be supported in the future, so I’d remove this… Read more

2 comments, 307 reads

Posted in The Voice of the DBA on 9 October 2017

Simplified Networking with a Wsky USB NIC

I used to share an office with my wife. We both needed Internet connections, with both desktops needing Ethernet cables. That was fine when my DSL router was in the office, but at some point we got a new provider and the connection to another room, where we put the… Read more

0 comments, 287 reads

Posted in The Voice of the DBA on 6 October 2017

Compound FKs with SQL Data Generator

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it, SQL Data Generator is a part of the SQL Toolbelt. Give it a try today with an evaluation today.

A person was wondering about how data is generated… Read more

0 comments, 985 reads

Posted in The Voice of the DBA on 5 October 2017

Enabling Database Containment for an Instance – #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.

I wanted to test a contained database feature the other day and… Read more

0 comments, 357 reads

Posted in The Voice of the DBA on 4 October 2017

The New CU Schedule

Is my math right? The new CU servicing schedule for SQL Server 2017 is:

  • 1 CU per month for the first year
  • 1 CU per quarter through mainstream support (5 years)

That means by my count, we get this:

WITH myTally(n)
AS
(SELECT n = ROW_NUMBER() OVER (ORDER BY (SELECT…

Read more

0 comments, 843 reads

Posted in The Voice of the DBA on 3 October 2017

Test Your SQL Memory Setting with dbatools

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. I have a short series on these items.

One of the settings that has caused me… Read more

0 comments, 247 reads

Posted in The Voice of the DBA on 2 October 2017