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

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,111 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, 667 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,528 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, 740 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,702 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, 256 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,286 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,371 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, 831 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,679 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, 881 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,674 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,072 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,152 reads

Posted in The Voice of the DBA on 13 April 2018

Adding the KeyMap Extension in SQL Operations Studio

I’m playing with SQL Operations Studio a bit to get a feel for what works and what doesn’t. So far, I don’t love it over SSMS, but one of the main reasons is that many of my common keyboard shortcuts don’t work.

Then I saw this:

You can download the… Read more

0 comments, 1,627 reads

Posted in The Voice of the DBA on 12 April 2018

Trekking Through Formatting Forest on the #SQLPrompt Treasure Map

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 recently, and this post continues to move across the map.

Formatting Forest

Walking through a forest can be daunting.… Read more

2 comments, 1,399 reads

Posted in The Voice of the DBA on 11 April 2018

T-SQL Tuesday #101–Tools

This month’s T-SQL Tuesday is brought to you by Jens Vestergaard. The invitation for #101 is for essential SQL Server tools. Since I work for a tool vendor, you can guess that I’m going to be shaded that way.

This is the monthly blog party on the second Tuesday of… Read more

3 comments, 1,401 reads

Posted in The Voice of the DBA on 10 April 2018

Code Snippet Cove on the #SQLPrompt Treasure Map

I’ve been away a bit in the last week with personal and family commitments. As a result, I feel a bit out of touch with work, and I have some catching up to do. However, when I ran across the SQL Prompt Treasure Island, I had to take a… Read more

2 comments, 796 reads

Posted in The Voice of the DBA on 9 April 2018

RIP, Robert Davis

A sad day for me.

A Memorial and Grief fund has been set up, if you’d like to contribute.

Read more

0 comments, 297 reads

Posted in The Voice of the DBA on 5 April 2018

Date Fun with SQL Server

I saw a people discussing date formats on Twitter after PASS put out an advertisement for a webinar with a mm-dd-yyyy format. Plenty of people were annoyed and wanted to be sure that they realized that much of the world might misinterpret 3-2-2018 as Feb 3, as opposed to the… Read more

2 comments, 214 reads

Posted in The Voice of the DBA on 3 April 2018

Newer posts

Older posts