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

Long Term Pebble Classic Review

I got a Pebble Classic watch for Christmas a few years ago, in Dec 2014 to be clear. That’s (as of now) about 18 months of use. I haven’t used it every day, but I’ve used it often, and here are a few things that I wanted to put down… Read more

2 comments, 220 reads

Posted in The Voice of the DBA on 1 July 2016

Basic XML Node Query–#SQLNewBlogger

 

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

I saw a question recently about querying an XML document. Certainly avoid this in the database if you can, but there are times you need to.… Read more

0 comments, 261 reads

Posted in The Voice of the DBA on 30 June 2016

The Desktop Rebuild–Part 3

This is the last part of this series, at least for now. If you haven’t seen Part 1 and Part 2, feel free to check them out.

After I got through Part 2, I was working again. In fact, I continued to chocotaley install a few things, but for… Read more

2 comments, 261 reads

Posted in The Voice of the DBA on 29 June 2016

Better Explorer on High dpi Displays

I’ve got a high dpi display on my laptop. The recommended resolution is 2560×1704. That’s small. I have had all kinds of issues with SSMS, VS, and various other applications, including a few from Redgate.

The other day I was looking at the Explorer window from about 2 feet away… Read more

4 comments, 200 reads

Posted in The Voice of the DBA on 29 June 2016

Better ReadyRoll Script Naming

One of the things that I like about ReadyRoll is that the product will automatically build new scripts that are named in a sequential order. This usually results in a few scripts that look like this:

As you can see, these scripts aren’t very intuitive. In fact, if you get… Read more

0 comments, 218 reads

Posted in The Voice of the DBA on 28 June 2016

The Desktop Rebuild–Part 2

You can read part 1, but that’s more about the (initial) hardware changes. This one looks at getting moving on the new desktop. Note, that since I changed the MB/CPU/Boot disk, I decided to reinstall Windows as well on a new disk to ensure I wouldn’t have more issues. Read more

1 comments, 231 reads

Posted in The Voice of the DBA on 27 June 2016

Debuting Talks at the Summit

This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for the first time, but on topics that I think make better events. These are opinions and thoughts, not mandates or demands. I’ve written previously on choosing speakers.

One of the… Read more

3 comments, 195 reads

Posted in The Voice of the DBA on 27 June 2016

The Desktop Rebuild–Part 1

I’ve had an aging desktop for some time. I originally bought it from Glenn Berry (b | t), who I think gets a new machine every quarter or two. Seriously, I think there is a computer in every room of his house, and he has a lot of rooms.

In… Read more

3 comments, 215 reads

Posted in The Voice of the DBA on 24 June 2016

Selecting Speakers for the Summit

This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for the first time, but on topics that I think make better events. These are opinions and thoughts, not mandates or demands.

I attended, well, listened to, the PASS Speaker Selection… Read more

6 comments, 229 reads

Posted in The Voice of the DBA on 23 June 2016

Not a Great Search

Tldr: A bit of a rant. I’m not spending a bunch of time crafting this.

I have mixed feelings about searching for information on Microsoft sites. It kind of works, kind of doesn’t. I know that there are resource constraints to upgrading their sites, but I’m more and more annoyed. Read more

2 comments, 221 reads

Posted in The Voice of the DBA on 22 June 2016

Starting ReadyRoll with an Existing DB

I’ve been working with ReadyRoll quite a bit the last few months, and wanted to start putting out some information. I’m looking to do a longer series, but here’s a quick post on getting started.

When you install ReadyRoll, you get a new project type under SQL Server.

This is… Read more

0 comments, 961 reads

Posted in The Voice of the DBA on 22 June 2016

LAST_VALUE–The Basics of Framing

I did some work a 3-4 years ago, learning about the Windowing functions and enjoying them so much I built a few presentations on them. In learning about them, and trying to understand them, I found some challenges, and it took some experimentation to actually understand how the functions work… Read more

0 comments, 247 reads

Posted in The Voice of the DBA on 20 June 2016

The RGE

I first heard this little acronym from Grant Fritchey (b | t). He used it when talking about backups and restores, and I like it. However I realize that I’ve never actually noted what it is, so a short blog to do so today.

An RGE is a… Read more

5 comments, 1,447 reads

Posted in The Voice of the DBA on 17 June 2016

When were statistics updated?–#SQLNewBlogger

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

I ran across the STATS_DATE function recently, and it’s one that I hadn’t used in production code. I’m not sure how this escaped me, as it was… Read more

2 comments, 267 reads

Posted in The Voice of the DBA on 16 June 2016

A Better (Free) Search in SSMS

A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we released. Free as in beer, so go get it.

Why use SQL Search?

There are a number of good reasons, which Ike Ellis of Crafting Bytes does a good… Read more

0 comments, 2,774 reads

Posted in The Voice of the DBA on 15 June 2016

It’s 2016 RLS for T-SQL Tuesday #79

It’s T-SQL Tuesday time again. I missed last month, being busy with travel, though I should go ahead and write that post. Maybe that will be next week’s task.

In this case, Michael J Swart is hosting this month’s blog party and he asks us to write about something to… Read more

1 comments, 607 reads

Posted in The Voice of the DBA on 14 June 2016

Learning Azure Data Platform

One of the issues I’ve seen with Azure is that is changes rapidly. It’s cool in that new things get added and problems get addressed. There’s also a buzz with learning and working with Azure from many people, including lots of MVPs. This means we get lots of things written… Read more

0 comments, 241 reads

Posted in The Voice of the DBA on 13 June 2016

SQL Prompt Prevents Stupidity

I upgraded my SQL Prompt recently, mostly as a habit. The team led by David and Aaron are always adding cool new features, and have almost never broken my flow, so I usually take the changes they’ve made whenever they appear. In this case, I got an unexpected surprise.

While… Read more

10 comments, 1,980 reads

Posted in The Voice of the DBA on 9 June 2016

OBJECT_ID()–#SQLNewBlogger

 

One of the things that is needed in quite a few functions is the object_id of a particular table/view/procedure/function in SQL Server. For example, I was looking at STATS_DATE recently, and it has this definition.

STATS_DATE (object_id, stats_id)

In the past, I’d run something like this:

DECLARE @i INT…

Read more

2 comments, 757 reads

Posted in The Voice of the DBA on 8 June 2016

InsideSQL–The Deep Dive

There’s a new conference in London next week, the InsideSQL conference on June 14th. It’s at the CodeNode venue, near Liverpool Stree and the Moorgate stations.

And I want to go.

I can’t. I’m a bit traveled out, my family is a bit tired of travel overall, and I need… Read more

0 comments, 228 reads

Posted in The Voice of the DBA on 7 June 2016

Newer posts

Older posts