-->
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: May 2018

Getting SQL Agent going for SQL Server on Linux–#SQLNewBlogger

It’s actually a simple procedure, but I thought I’d write a short note to help me remember. The procedure is documented in Books Online.

When I first started playing with this version, I noticed that SQL Agent was disabled. That’s not great, since SQL Agent is a great tool for… Read more

1 comments, 246 reads

Posted in The Voice of the DBA on 31 May 2018

Cleaning up Azure Client IPs

I travel around, and as a result, I may find myself accessing my Azure databases from different locations. Since it’s a quick click and login to add my IP from SSMS, I’ll end up with multiple ones. I don’t want to leave systems open for a long time, and certainly… Read more

0 comments, 211 reads

Posted in The Voice of the DBA on 29 May 2018

Hands off dbatools updates

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 downsides of an active project… Read more

1 comments, 2,168 reads

Posted in The Voice of the DBA on 25 May 2018

One Week to Music City Tech

Next week is Music City Tech, a three day conference consisting of Coding, Agile, and Data tracks, takes place in Nashville on May 31-June 2. There are a lot of great sessions on the schedule, covering a lot of software development topics.

I’ll be delivering two talks, one… Read more

0 comments, 605 reads

Posted in The Voice of the DBA on 24 May 2018

Jobs in PoSh to Create a Load

I saw this from Argenis Fernandez, and thought it was wonderful.

1..128 | % { start-job -name ‘job name’ -scriptblock { & sqlcmd -S instanceName -U sa -P ‘iLovePoSh’ -i /home/username/test.sql } }

Create 128 threads, each running a background job in PowerShell to connect to an instance and… Read more

0 comments, 711 reads

Posted in The Voice of the DBA on 23 May 2018

Update Oddness for SQL Server

I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I started the process the other day. My first step was to patch SQL Server 2016 with SP2.

This went as many patches have gone for me, which is fairly boring… Read more

2 comments, 203 reads

Posted in The Voice of the DBA on 22 May 2018

Music City Data

I’ve never spoken in Tennessee. I’ve wanted to visit, but the I’ve only managed to drive through a part of the state or transfer in the airport. That changes at the end of this month.

Music City Tech, a three day conference consisting of Coding, Agile, and Data tracks,… Read more

0 comments, 240 reads

Posted in The Voice of the DBA on 17 May 2018

Reaching the Refactoring Redoubt with #SQLPrompt

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I wrote about Code Snippet Cove first, and this post finishes my movement around the map. The other items I’ve read about are:

Read more

0 comments, 189 reads

Posted in The Voice of the DBA on 14 May 2018

Finding Tabs in SSMS–#SQLNewBlogger

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

Someone posted this as a question and I thought it was worth noting. I use SQL Prompt for formatting, and never worry if there are tabs in code,… Read more

0 comments, 260 reads

Posted in The Voice of the DBA on 10 May 2018

First Wave of Sessions for PASSSummit Now Available

The first wave of sessions for the #PASSSummit have been released. You can see the list at: http://www.pass.org/summit/2018/Learn/ConferenceSessions.aspx

I am honored to have a session on the list. This year, I’ll be doing a session called Minimizing the Impact of Data Breaches in Dev and Test Databases. This is… Read more

0 comments, 813 reads

Posted in The Voice of the DBA on 9 May 2018

Relaxing on the Tab Management Terraces with #SQLPrompt

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I’ve written about a few of the other items on the map:

Read more

0 comments, 1,130 reads

Posted in The Voice of the DBA on 9 May 2018

T-SQL Tuesday #102–Getting Started

It’s time for another blog party, on the second Tuesday of the month. For this month’s T-SQL Tuesday, Riley Major has a couple of invites. One is on giving back, which is good, but doesn’t fit me. 

The second option is to explain how and why we got started, so… Read more

0 comments, 685 reads

Posted in The Voice of the DBA on 8 May 2018

Randomizing Names with Data Masker

Data Masker for SQL Server is pretty cool. It can reduce your attack surface area and exposure under the GDPR or any other regulation. There are plenty or rules and templates to help you anonymize data, in ways you might not have expected. Data Masker is a part of SQL… Read more

0 comments, 2,562 reads

Posted in The Voice of the DBA on 7 May 2018

Moving Birthdays with Data Masker

Data Masker for SQL Server is a fantastic product, and one that can reduce your attack surface area and exposure under the GDPR or any other regulation. There are plenty or rules and templates to help you anonymize data, in ways you might not have expected. It’s a part of… Read more

0 comments, 756 reads

Posted in The Voice of the DBA on 4 May 2018

Defining FKs in CREATE TABLE–#SQLNewBlogger

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

One of the important things that a database developer can do is to define Foreign Keys (FK) at table creation. This is a good time to do this… Read more

2 comments, 2,727 reads

Posted in The Voice of the DBA on 3 May 2018