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

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, 167 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, 184 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

1 comments, 382 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, 246 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, 275 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

0 comments, 281 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, 1,905 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, 862 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

0 comments, 842 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

2 comments, 947 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

0 comments, 457 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, 248 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, 175 reads

Posted in The Voice of the DBA on 3 April 2018

Learning is Hard–March Goals Update

This is the third update for my goals for 2018. This is about 3 weeks after the last update, and it’s too soon. Not in time, but because I haven’t done a great job.

This was a busy month. March and April are prime volleyball season, so I’ve had… Read more

0 comments, 649 reads

Posted in The Voice of the DBA on 29 March 2018

Moving to AWS EC2

SQLServerCentral has been stuck in the past for some time, but we’ve finally decided to move. I’ve been asking for this, and it’s usually a resource issue. However, earlier this year we started to debate and examine the costs, and decided to pursue a move to EC2. We have other… Read more

1 comments, 1,158 reads

Posted in The Voice of the DBA on 28 March 2018

The 700 Milestone for SQL Saturday

This past weekend was SQL Saturday #700. Another milestone in the franchise of events, and I was glad to attend. This is my fifth or sixth Colorado Springs event, and everything ran great. The leadership has changed over the years, as has the structure and format, but attendance continues to… Read more

0 comments, 571 reads

Posted in The Voice of the DBA on 26 March 2018

Scripting Tables 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.

I’ve been experimenting with scripting some tables, and… Read more

0 comments, 1,226 reads

Posted in The Voice of the DBA on 23 March 2018

I learned about the order of logical operations #SQLNewBlogger

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

I had logic in a CS curriculum many years ago and I’ve worked with AND and OR statements for years. I’ve sometimes confused myself, but I usually ensure… Read more

3 comments, 2,361 reads

Posted in The Voice of the DBA on 22 March 2018

The 700 Milestone

I’ve watched various SQL Saturday milestones go by. I missed 100 in Brazil, but did manage to get to 200 in Philadelphia and 300 in Kansas City. 400 was in Torino, and I am sad about not making the effort to get there. 500 was Boston, but I had a… Read more

2 comments, 133 reads

Posted in The Voice of the DBA on 15 March 2018

The SQL Privacy Summit

This May 18th, Redgate is putting on a SQL Privacy Summit for people that are looking for solutions to help them comply with the GDPR regulations.  I’ll be heading over to participate, and I’m looking forward to hearing from customers and attendees about the challenges they’re facing.

The Details

Friday… Read more

0 comments, 1,078 reads

Posted in The Voice of the DBA on 14 March 2018

Older posts