Click here to monitor SSC
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

Back for a Day

I hope everyone is well in Florida, but the hurricane caused a postponement of SQL Saturday Orlando. Fortunately I caught the note early enough on Wednesday and spent about an hour at lunch cancelling travel plans and moving my flight from DC to Orlando to Denver to an early… Read more

0 comments, 211 reads

Posted in The Voice of the DBA on 7 October 2016

Off Again

It’s another week of travel for me, starting early this morning. This is another crazy trip, and yes, I did this to myself. However, I am taking note this time and I’ve already declined and refused a few things for 2017 to try and avoid these trips.

My week:

  • Tues…

Read more

2 comments, 214 reads

Posted in The Voice of the DBA on 4 October 2016

My SQL Prompt GitHub Repo

Last year I published an article on SQLServerCentral from Guarab Vohra on using SQL Prompt with a VCS. I really like the article, and had been meaning to get my own SQL Prompt Snippet library into a repo, but kept putting it off.

If you don’t have a SQL… Read more

1 comments, 249 reads

Posted in The Voice of the DBA on 4 October 2016

Rename a Server with PowerShell

I’m sure many people are experimenting with VMs and SQL Server. If you’re like me, many of you just default to installing Windows 7/10 or Windows Server xx Standard for your testing. Those systems work fine, but I’ve been trying to build slimmer systems, which means looking at Server Core.… Read more

2 comments, 364 reads

Posted in The Voice of the DBA on 3 October 2016

Finding the Attribute

I was playing with some Extended Events recently. If you haven’t tried, I’d encourage you to do so. However, working with XML is not my favorite. I know I can get the GUI in SSMS 16.x to show me events, but I sometimes want to query.

Here was my quick… Read more

0 comments, 383 reads

Posted in The Voice of the DBA on 29 September 2016

Quick Tips–Using ii in #SQLPrompt

SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself to use a few of these and not just start to type with your old habits. This quick tip looks at one of those areas when inserting data into tables. Read more

0 comments, 1,365 reads

Posted in The Voice of the DBA on 27 September 2016

More Azure Database Creation in Powershell

I wrote about Azure SQL Database for T-SQL Tuesday #82, but I had a few mistakes in my process, at least from a cost standpoint. Since I’ll probably use this a bit more as I flesh out some CI/CD, I decided to document a bit more about the database… Read more

3 comments, 249 reads

Posted in The Voice of the DBA on 22 September 2016

Quick #SQLPrompt Tips – Expanding Wildcards

I tend to try and get code on the screen quickly and then start to remove things. I’m a visual person, and it’s helpful for me to see some tables, joins, filters, and columns as I’m structuring a query.

One of the ways I work quickly is with SQL Prompt Read more

0 comments, 219 reads

Posted in The Voice of the DBA on 15 September 2016

T-SQL Tuesday #82–Azure SQL Database

It’s T-SQL Tuesday time and this month we have Jeffrey Verheul giving us the topic of the cloud, or Azure SQL Database. It’s a good topic, given how many people are talking about working in the cloud. There are also the tremendous resources that Microsoft is investing in Azure,… Read more

1 comments, 290 reads

Posted in The Voice of the DBA on 13 September 2016

Bringing Database Devops to DevConnections

Another alliteration post. Maybe I’ll make all my titles tongue twisters to test your talents?

This is my new favorite session. I’m slated to deliver this at a few different conferences this fall, and hopefully you’ll come see it in Las Vegas at DevConnections on Oct 10-13.

The talk is… Read more

2 comments, 349 reads

Posted in The Voice of the DBA on 13 September 2016

Learning All About Always Encrypted at DevConnections

Like the alliteration in the title? I almost removed it, but decided it had a nice ring. Maybe that should be the title of my IT/DevConnections (Oct 10-13, 2016) session other than End to End Always Encrypted in SQL Server 2016.

I loved seeing encryption being natively built into SQL… Read more

0 comments, 237 reads

Posted in The Voice of the DBA on 6 September 2016

Team Purple

This is Down Tools Week at Redgate Software, and I’m visiting the office. I had hoped to dive into a team and participate, but scheduling and other commitments mean that I’m only working with a team part of the time.

We had our first standup yesterday. They tried desperately to… Read more

0 comments, 197 reads

Posted in The Voice of the DBA on 6 September 2016

Filtering Objects with DLM Dashboard

I’ve been looking at some of the features of DLM Dashboard as I go through work building database development pipelines. In this post I wanted to cover one of the lesser used features, filtering objects.

Note: DLM Dashboard is a free tool from Redgate Software. Use it to monitor the… Read more

0 comments, 251 reads

Posted in The Voice of the DBA on 31 August 2016

Finding out Who’s Touching Your Database at DevConnections

I’ve got a session this fall at the IT/DevConnections conference (Oct 10-13, 2016) called “Who’s Touching My Database?” This is something I’ve worked on for a few years, but never really gotten it to the point where I was ready to deliver it.

Earlier this year, with all the security… Read more

0 comments, 294 reads

Posted in The Voice of the DBA on 30 August 2016

SQL Saturday–Viking Edition

I’m off to the Viking Ship Museum for SQL Saturday #532. Actually, the Viking Museum will (hopefully) be a side trip on Friday before the actual event. The actual training will be at the Noroff campus in Oslo.

This is my first trip to Norway, and while it… Read more

0 comments, 519 reads

Posted in The Voice of the DBA on 25 August 2016

Output into a Table–#SQLNewBlogger

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

I often see people struggling to use triggers for auditing, or having issues with building them to handle multi row updates. However, there’s another choice: the OUTPUT… Read more

0 comments, 830 reads

Posted in The Voice of the DBA on 24 August 2016

Everki Versa Long Term Review

A couple years I was looking for a new laptop bag. I settled on the Everki Versa, which I’ve been using on my travels for 2015/2016. It’s been quite a few, which you can see on my speaking CV.

I decided to write a long term review… Read more

1 comments, 265 reads

Posted in The Voice of the DBA on 23 August 2016

PoSh on Ubuntu

I heard about the PowerShell announcement recently where the platform is porting over to Linux and OSX. I think this is part of the SQL Server on Linux project, where I assume we’ll start to see the functionality that we have on Windows appear on Linux platforms. OSX is a… Read more

1 comments, 1,031 reads

Posted in The Voice of the DBA on 19 August 2016

Rounding Challenges–#SQLNewBlogger

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

Rounding is an interesting activity, and one that I think people sometimes don’t pay enough attention to. Recently I saw a problem that intrigued me and I… Read more

4 comments, 303 reads

Posted in The Voice of the DBA on 18 August 2016

Remember the Alamo (with a SQL Saturday nearby)

This past weekend was the first SQL Saturday in San Antonio, TX. I was lucky enough to get the chance to go, and I was happy to do so. I like to support new events in new cities, and hopefully I can help keep them going in the future.

I… Read more

2 comments, 252 reads

Posted in The Voice of the DBA on 15 August 2016

Newer posts

Older posts