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

Archives: November 2018

SQL in the City December 2018

The last 2018 edition of SQL in the City Streamed is coming in a few weeks. You can register today and join us for a set of talks on December 12 that talk DevOps, compliance, and more.

I have to deliver the keynote, which I’m working on now, taking information… Read more

0 comments, 350 reads

Posted in The Voice of the DBA on 29 November 2018

Take the State of DevOps Survey

Kendra wrote a nice piece on this the other day, and I agree.

Take the Survey

The data that comes out of this helps to influence executives and managers. You can show them results, which might get them to help you change your job.

This is also a way that… Read more

0 comments, 332 reads

Posted in The Voice of the DBA on 29 November 2018

Adding the Constraint Name to the PK at the End of Create Table–#SQLNewBlogger

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

A good habit to get into is to explicitly name your constraints. I try to do this when I create tables to be sure that a) I have… Read more

1 comments, 2,838 reads

Posted in The Voice of the DBA on 28 November 2018

Early Bird SQL Bits Pricing

You can register today and save for the next few days. It’s only £799 for the full SQL Bits 2019 conference until Saturday. If you’ve ever  been, you know this is the best SQL Server conference out there, at least, that’s how I feel, and I go to a lot… Read more

1 comments, 277 reads

Posted in The Voice of the DBA on 28 November 2018

TDE and DDM

Someone asked a question about TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking), which are two different technologies that are in the security area. As I’ve mentioned in the Stairway to Dynamic Data Masking, DDM is not a security technology. It makes programming some obfuscation easy, but it’s… Read more

0 comments, 2,054 reads

Posted in The Voice of the DBA on 26 November 2018

Learning from PASS Summit Feedback

I got my feedback the other day, and was a bit surprised by a comment. I wasn’t having a great day and posted a note on Twitter. Not the best idea, but I did get some validation back that others support me and appreciate (and enjoy) when I speak.… Read more

1 comments, 751 reads

Posted in The Voice of the DBA on 21 November 2018

A Problem with POWER()

I ran into an interesting problem while working with the POWER() function. I was trying to do some binary conversions and had a statement like this to process powers of 2.

SELECT POWER(2, n)

This was designed to take a value and return a power of 2. I then used… Read more

3 comments, 792 reads

Posted in The Voice of the DBA on 20 November 2018

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, 1,891 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, 775 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, 851 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, 989 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, 239 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, 2,238 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,803 reads

Posted in The Voice of the DBA on 2 November 2018