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

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, 118 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, 236 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, 289 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, 224 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, 234 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, 448 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, 287 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, 463 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, 200 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, 3,801 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, 634 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,043 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, 236 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, 253 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, 184 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, 210 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, 322 reads

Posted in The Voice of the DBA on 25 September 2017

How Mature are you in Database DevOps?

I remember seeing the Carnegie Mellon Software Capability  Maturity Model (CMM) when I was in university. It was fascinating, and I was sure this was the way to write software. Across many jobs and many years, I realized that few organizations even try to become more efficient and capable in… Read more

0 comments, 705 reads

Posted in The Voice of the DBA on 22 September 2017

What’s a SQL Compare Snapshot?

I saw a short video from Grant Fritchey on the Redgate channel that shows how to cerate a snapshot in SQL Compare. I think snapshots are great, and there are lots of uses (more on that later), but I do find sometimes I use the term and people are confused. Read more

0 comments, 297 reads

Posted in The Voice of the DBA on 21 September 2017

Test Database Compatability with dbatools

I really like the dbatools project. This is a set 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 items that few DBAs think… Read more

0 comments, 1,772 reads

Posted in The Voice of the DBA on 20 September 2017

Older posts