Feb 122019
 
Azure Data Studio

Azure Data Studio continues to grow on me. I previously wrote about getting my favorite keyboard shortcuts to work, which made me very happy, but now for a feature I love even more – saving result sets to Excel!

Yes, I know, spreadsheets can be evil. They can even be places where good datasets go to die, but it’s important to remember that they’re a necessary evil. Sometimes you just need a result set in a spreadsheet, whether you want it to be in one or not.

In SQL Server Management Studio, there’s no single-step way to save a result set to Excel. Most commonly I will just copy/paste a result set into a spreadsheet, but depending on the size of the result set and the types of data involved, that doesn’t always play nicely.

But Azure Data Studio does it WAY better, trust me. If you want that result set in a spreadsheet, just save it as one and poof – you have an Excel file!

Try It Yourself!

In Azure Data Studio, query the dataset of your choosing. I’m using my Chicago Parking Tickets database. Once you have your results, look at the icons on the right side of the window.

(click to enlarge)

The second icon from the top will save the entire result set to Excel. Click it, pick a filename and folder to save it to and you’re good to go.

But wait – there’s more!

You can also save a subset of the results directly to Excel. Select the rows, columns, or block of interest (you can click and drag to select within the results!) and then right-click. You’ll get a dialog where you can choose to save the selection:

Whichever method you choose, Azure Data Studio makes it very simple to save results directly to a spreadsheet. Happy querying!

Feb 052019
 

I’m very honored to have one of my PASS Summit sessions chosen for the PASS Data Expert Series, taking place this Thursday, February 7th!

This is an awesome opportunity to see some of the top-rated sessions from this year’s PASS Summit. Included is my session on SQL Server Management Studio, which ended up being the second-best attended session of the entire conference. I will be available to answer any questions that come up during the presentation.

Sound awesome? Register today! I hope to see you there!

Jan 282019
 

We have just under two months to go until SQL Saturday Chicago 2019!

This year we received 148 abstracts from 63 different speakers, and we are very pleased to announce our schedule. Thank you to all who submitted!

I hope to see you on Saturday, March 23, 2019, at Benedictine University in Lisle for what will be a wonderful day of free training, networking, and career development. (Lunch is available for $15.)

We have once again broken our previous record for registration (set last year), and are now at capacity. But fear not! There are still ways you can attend:

Join our waiting list, as spots may open up. As the date nears, people often find they are unable to attend and then cancel their registration. As this occurs, people will be moved off the waiting list in the order that they joined. REGISTER HERE for our waiting list.

Register for a pre-conference session and be guaranteed a spot. We are offering 5 full-day pre-conference sessions on Friday, March 22.
These in-depth workshops are being conducted by experts in their respective fields. Pre-conference registration includes lunch. Additionally, pre-conference attendees can bypass the SQL Saturday waiting list and are guaranteed a spot. You can find out more information and register for pre-conference sessions at the links below:

I hope to see you here in March!

Jan 232019
 

I am very proud and happy to be a Friend of Redgate for a sixth year!

If you’re not familiar with the Friends of Redgate program, we work with the Redgate development and product teams to provide feedback on existing products, new tools, and feature enhancements. You can also find us doing things like speaking at events, writing articles on Redgate tools, and participating on the Redgate forums. Last year, I even got to present at SQL in the City Summit in Chicago as a result of being in this program.

Redgate is a wonderful organization to be associated with. Not only do they make great tools and publish some very helpful books, but they’re also extremely community-oriented. They sponsor many functions such as user group meetings and SQL Saturdays, and also put on their own events, such as SQL in the City Streamed and SQL in the City Summit.

Thank you so much, Redgate. I’m looking forward to another awesome year!

Jan 142019
 

I’m very happy to be taking part in a panel for the PASS HA/DR Virtual Group!

Topic: Ask Me Anything about SQL Server High Availability and Disaster Recovery

Panel: David Klee, Ed Leighton-Dick, Anthony Nocentino, Bob Pusateri

Date/Time: Tuesday 15 January 2019, 18:00 UTC

Register Here

Over the past year, our meetings have had LOTS of questions that typically cause us to go well beyond our scheduled hour. This time, we’re dedicating an entire meeting to them! Bring whatever questions you might have about HA/DR features, architectures and anything else!

I really hope to see you there!