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

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, 927 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, 232 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,411 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, 250 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,678 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, 585 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, 228 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,936 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, 726 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, 212 reads

Posted in The Voice of the DBA on 7 June 2016

SQL Compare 12 Beta

The Beta is out. I’ve been waiting for this, and was glad to see Carly’s post on the product. I’ve been involved in looking at some early designs and functionality, and have been waiting for the product to get to the point I could play with it more.

Be sure… Read more

0 comments, 810 reads

Posted in The Voice of the DBA on 6 June 2016

Quick Tests for a Function

I was writing a poorly performing UDF the other day and then wanted to replace it with a better performing one. However, I wanted to be sure that the function was the acting the same externally. In other words, does all my code that calls the function work the same? Read more

0 comments, 1,417 reads

Posted in The Voice of the DBA on 2 June 2016

Another Recursive CTE–Doing Math

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

I showed how to write a simple recursive query recently that calculated an amount of money paid out each day. Now I want to extend this a… Read more

0 comments, 224 reads

Posted in The Voice of the DBA on 1 June 2016

Running Multiple Threads Quickly

Recently I was looking to generate a quick workload against an instance. I wanted to add to the amount of work my system was doing by executing a number of queries simultaneously. There are a variety of ways to do this, but I just wanted a quick set of queries.… Read more

0 comments, 291 reads

Posted in The Voice of the DBA on 31 May 2016

Just a week to SQL Saturday in Pensacola

Next week is  SQL Saturday #491 in Pensacola. I’ll be there, along with a number of other great speakers. It’s free SQL Server training, and a great place to vacation. There are a couple pre-conference sessions available as well if you are looking for some training.


Filed under: Blog Tagged:…

Read more

1 comments, 237 reads

Posted in The Voice of the DBA on 26 May 2016

A Basic Recursive CTE and a Money Lesson

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

When I was a six or seven year old, my Mom asked me a question. She asked if I’d rather have $1,000,000 at the end of the… Read more

8 comments, 254 reads

Posted in The Voice of the DBA on 25 May 2016

Changing Your PASS Credentials

I got an email today from PASS, noting that credentials were changing from username to email. That’s fine. I don’t really care, but I know I got multiple emails to different accounts, so which account is associated with which email?

I clicked the “login details” link in the email and… Read more

2 comments, 239 reads

Posted in The Voice of the DBA on 24 May 2016

Changing a Computed Column–#SQLNewBlogger

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

I was working with a computed column the other day, and realized I had the wrong definition. In this case, I was performing some large calculation, and… Read more

0 comments, 1,386 reads

Posted in The Voice of the DBA on 19 May 2016

The New Global Dashboard

Redgate recently released SQL Monitor 5.2, which is the latest upgrade to our monitoring/alerting/troubleshooting product for DBAs. This was the big change that the team has spent a lot of time developing and refining. It’s been available for a few weeks as a hidden URL, but with 5.2, this becomes… Read more

0 comments, 277 reads

Posted in The Voice of the DBA on 13 May 2016

SQL Nexus

I was lucky enough to be accepted to speak at SQL Nexus in Copenhagen and I attended the event a few weeks ago. This is the new Nordic SQL conference that seems to be replacing the SQL Rally. I’d never been to Denmark, but the trip was easy, and I… Read more

2 comments, 289 reads

Posted in The Voice of the DBA on 12 May 2016

Newer posts

Older posts