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

Fun with Savepoints–#SQLNewBlogger

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

I haven’t spent a lot of time with savepoints, but I did find a question recently and thought I’d take a moment to dig into how they work.… Read more

0 comments, 131 reads

Posted in The Voice of the DBA on 15 November 2018

Random Pix from the 2018 PASS Summit

A few memories from me. First, a beautiful late arrival view.

My first session feels a little lonely

It started to fill a bit later

A few selfies, Angela

Mala

Bert

David

Brent

TJ

and my view during a break after Thursday’s sessions.

Where’s my room?

It’s a wrap

After… Read more

0 comments, 258 reads

Posted in The Voice of the DBA on 12 November 2018

Vote for the PASS Board of Directors

Voting is open for the PASS Board of Directors. It’s a non-event this year, with three open positions and three candidates. That’s disappointing, as I would hope to see new candidates, new blood, and some change in the organization. I’m not complaining, since I didn’t run, but I hope that… Read more

0 comments, 352 reads

Posted in The Voice of the DBA on 9 November 2018

Creating a Quick Dashboard Widget

I read Carlos Robles blog on creating an Azure Data Studio (ADS) insight widget and decided to try this for myself. I decided to try and get a list of object types and a count of each. Following instructions, here’s what I did.

First, I wrote a query that would… Read more

0 comments, 808 reads

Posted in The Voice of the DBA on 8 November 2018

A Busy Summit

I’m only at the PASS Summit for two days, but they will be busy. If you’re at the event and want to find me, here’s my schedule. If you do see me, please feel free to say hi. If I can’t stop to chat for long, it’s because I’m… Read more

0 comments, 171 reads

Posted in The Voice of the DBA on 7 November 2018

Setting Memory–#SQLNewBlogger

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

I had a great time away, and upon my return, I found lots of emails and messages to review from work. One of these was a note that… Read more

0 comments, 445 reads

Posted in The Voice of the DBA on 5 November 2018

Adding SQL Search to Azure Data Studio

There are a limited number of extensions available for Azure Data Studio (ADS), but one that came out early is SQL Search. This is highlighted as a recommended extension from Microsoft. Redgate worked with them early on in the lifecycle of the product to get this extension working, including helping… Read more

0 comments, 1,587 reads

Posted in The Voice of the DBA on 2 November 2018

Data Classification in SQL Server 2019

One of the areas that Redgate is working on is making data classification easier. Microsoft added some capabilities to SSMS 17.5 and Redgate has an EAP out for the next version of our data catalog tool.

Azure SQL Database has had some advanced options they were building into the… Read more

0 comments, 2,736 reads

Posted in The Voice of the DBA on 24 October 2018

Webinar: The end of support for SQL Server 2008

Coeo is a partner with Redgate Software. Tomorrow they are hosting a webinar on what your position will be if you are still running SQL Server 2008 or R2 now. Extended support ends next year and now is the time to start your preparations.

Register now and tune in tomorrow,… Read more

0 comments, 262 reads

Posted in The Voice of the DBA on 23 October 2018

Better Keyboard Extensions in Azure Data Studio

I used to use ALT+X to execute queries in SSMS. I spent years with this shortcut, but as I started to present more, CTRL+E felt more natural. I’ve now grown used to that, so when I typed CTRL+E in Azure Data Studio (ADS), I was less than pleased.

Even trying… Read more

0 comments, 1,923 reads

Posted in The Voice of the DBA on 23 October 2018

Time for SQL in the City Summit–Chicago

This week is the last live SQL in the City Summit this year. It’s this Friday at the Microsoft office in Chicago, and if you’re nearby, you can still register with “stevejones” as the code.

We’ve presented this program in New York and London this month, and we’ll be showcasing… Read more

0 comments, 620 reads

Posted in The Voice of the DBA on 22 October 2018

Installing Azure Data Studio

Azure Data Studio is the newest tool from Microsoft for working on the data platform. Last year we saw the preview release of this, called SQL Operations Studio. No one liked the name, and as the tools team at Microsoft worked to update the tool, they changed the name this… Read more

4 comments, 3,363 reads

Posted in The Voice of the DBA on 19 October 2018

How does data file size relate to log file size?–#SQLNewBlogger

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

The other day I saw someone asking about a way to determine which databases have a log file larger than a data file. It’s an interesting query, but… Read more

0 comments, 85 reads

Posted in The Voice of the DBA on 15 October 2018

The Security Weak Link

I saw this cartoon, which I think is great: Data Security. It’s from John Klossner, and it perfectly shows that humans are, and probably always will be, a weak link.

I look at this in two ways. First, we need to account for and accept that our users will… Read more

0 comments, 1,936 reads

Posted in The Voice of the DBA on 11 October 2018

Quick PoSh SQL Provision Databases for New Developers

As part of some presentation work, I wanted to demonstrate some onboarding of new developers. To that end, as part of a demo, I wanted to build a script that would take a few parameters and generate some SQL Provision databases for development. The idea is that an admin can… Read more

0 comments, 244 reads

Posted in The Voice of the DBA on 4 October 2018

The Developer’s Guide to Azure–A Good Overview

Someone sent me a link a few weeks back  about a free book from Microsoft. It’s the Developer’s Guide to Azure, and you can download it in Kindle or other formats. I actually got it for the Kindle on my phone and went through it in my spare time… Read more

0 comments, 2,301 reads

Posted in The Voice of the DBA on 3 October 2018

Redgate Releases Sept 2018–Practicing DevOps

At Redgate, we build tools to help you build software in the entire DevOps cycle. In fact, I love this new graphic that shows the areas that we focus on in the entire software development cycle.

We don’t just preach DevOps, we live it. As an example, here are the… Read more

0 comments, 217 reads

Posted in The Voice of the DBA on 1 October 2018

Understanding a UK Keyboard for a US developer

One of the very interesting parts of my job is that I run into UK keyboards on a regular basis. Redgate is a UK company and most of the trade show laptops that they bring to events are UK layouts. Our VMs are built in the UK, and when I… Read more

0 comments, 904 reads

Posted in The Voice of the DBA on 28 September 2018

Off to #SQLSat Pittsburgh

I’ve never been to Pittsburgh. Actually, in all of my speaking and traveling, I don’t think I’ve even flown through the airport. I’ve been wanting to rectify this, and quite a few friends, like Bill and Konstantine, have been asking me to come for years. The timing hasn’t worked out… Read more

4 comments, 857 reads

Posted in The Voice of the DBA on 28 September 2018

Finding Objects in a Schema #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 things I needed to do recently was move some objects from one schema to another. I wrote about moving an object between schemas recently, but… Read more

5 comments, 870 reads

Posted in The Voice of the DBA on 27 September 2018

Older posts