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

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, 162 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, 157 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, 219 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, 171 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, 256 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, 386 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, 233 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, 243 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, 553 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, 297 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, 557 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, 208 reads

Posted in The Voice of the DBA on 2 October 2017

This Made Me Laugh: SQL v NoSQL

It’s a humorous history lesson on SQL (and product promotion), but it opens like this:

SQL awakens to fight the dark forces of NoSQL

From there it looks at the beginnings of SQL and the growth of NoSQL, going through a few sections, like

Part 1: A New Hope

and Read more

2 comments, 4,037 reads

Posted in The Voice of the DBA on 29 September 2017

All Day DevOps–A Free, Virtual Conference

All Day DevOps is coming on Oct 24. This is a 24 hour event, with 100 sessions live, online. You can register now and join in the event, watching from work, home, or even the train on your commute.

The schedule is packed, with speakers from all over the world… Read more

0 comments, 731 reads

Posted in The Voice of the DBA on 28 September 2017

Getting a New R Package–#SQLNewBlogger

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

I was trying to test an R script the other day and got this:

> library(randomForest)
Error in library(randomForest) : 
  there is no package called ‘randomForest’

A common… Read more

0 comments, 1,150 reads

Posted in The Voice of the DBA on 27 September 2017

SQL Clone, Redgate Licensing, and Cookies

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.

SQL Clone is a fantastic tool… Read more

2 comments, 242 reads

Posted in The Voice of the DBA on 26 September 2017

Oct 2, 2017 is the GA date for SQL Server 2017

Announced today at Microsoft Ignite, the general availability date is Oct 2, for Windows, Linux, and Docker. Time to get ready to upgrade.


Filed under: Blog Tagged: sql server, syndicated

Read more

1 comments, 259 reads

Posted in The Voice of the DBA on 25 September 2017

Sign up for Game Night

This year PASS is hosting Game Night as an official event, providing the room and support. Kevin Hill (b | t) is going to lead the event, and everyone should thank him for stepping up. If you’re willing to volunteer and help organize, let Kevin know.

Game Night… Read more

0 comments, 189 reads

Posted in The Voice of the DBA on 25 September 2017

SQL Grouping on Sums (with testing)

I ran across a post recently that I thought was an interesting T-SQL problem. The user wanted to group values into a running total, but the groups would reset based on a sum.

In this case, the user had this set of data:

Their goal was to run through these… Read more

0 comments, 217 reads

Posted in The Voice of the DBA on 25 September 2017

Cookie Consent

More of an FYI, but the EU Cookie Consent law goes into effect on Oct 1. Maybe this matters to you, maybe not. In my case, I may be in limbo as I work for a UK company even though I live in the US. Certainly I want EU visitors… Read more

0 comments, 327 reads

Posted in The Voice of the DBA on 25 September 2017

Older posts