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

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, 108 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, 121 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, 193 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, 136 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, 172 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, 758 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, 791 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, 445 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,311 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, 612 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,589 reads

Posted in The Voice of the DBA on 3 May 2018

Securing Test and Dev Environments at the SQL Privacy Summit

Redgate Software is putting on a one day SQL Privacy  Summit on May 18 in London at the Grange Tower Bridge. This is a chance to see how you can ensure compliance with the GDPR while keeping up the modern pace of DevOps software development. Our goal is to… Read more

0 comments, 226 reads

Posted in The Voice of the DBA on 26 April 2018

Watching the Sands of Suggestion in #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 Code recently, and this post continues to move across the map.

Incredible Suggestions

The first thing that most people notice… Read more

3 comments, 2,217 reads

Posted in The Voice of the DBA on 24 April 2018

Checking Tempdb 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.

In SQL Server 2016, the setup program was… Read more

0 comments, 1,331 reads

Posted in The Voice of the DBA on 20 April 2018

The Prompt Actions Menu

A quick post on SQL Prompt here. Someone is asking about the Prompt Actions menu. This is the menu that appears when you highlight code. I’ve got a quick animation of this working.

In the gif, I highlight code, click the Actions icon, and then I can add a BEGIN..END… Read more

0 comments, 811 reads

Posted in The Voice of the DBA on 19 April 2018

Python Jupyter Notebooks in Azure

There’s a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I can’t remember who, but I did click on the Azure Notebooks link and was intrigued. I’ve gotten Jupyter notebooks running on my local laptop, but these are often just on… Read more

2 comments, 2,613 reads

Posted in The Voice of the DBA on 18 April 2018

An Open Letter to PASS and John Q Martin

Dear Mr. Martin and the PASS Organization,

In the spirit of advocating for change in a public way, I’m writing this letter to ask you to revisit your policies and processes and embrace the transparency that we, members of the PASS organization, deserve with regards to the SQL Saturday events. Read more

10 comments, 847 reads

Posted in The Voice of the DBA on 18 April 2018

Webinar: 6 Principles of the GDPR and SQL Provision

On April 24, I’ll be hosting a webinar that talks about the GDPR and how you can help ensure compliance in your development environments. I’ll talk about some of the issues and show how SQL Provision can help.

The GDPR is complex, but it certainly does ask us to protect… Read more

0 comments, 2,612 reads

Posted in The Voice of the DBA on 17 April 2018

Exploring the Caves of Code Analysis in #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 a few of the items, and this post continues on with a feature that was added last year to SQL Prompt,… Read more

2 comments, 2,045 reads

Posted in The Voice of the DBA on 16 April 2018

Remove-DbaBackup 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 important item for any system administrator to… Read more

0 comments, 2,126 reads

Posted in The Voice of the DBA on 13 April 2018

Older posts