Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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

T-SQL Tricks – Custom Templates

I wrote about the Template Explorer, which comes with the SQL Server tools and is visible in Management Studio (SSMS). It’s handy, but there are limited code items in there. What if I want more?

That’s easy. Suppose I decide that I often need to create procedures with the EXECUTE… Read more

3 comments, 7,433 reads

Posted in The Voice of the DBA on 19 November 2014

Use -eq in Powershell

I was writing a quick script to work with files and I only wanted to process one file for each execution of a loop. I could have done this multiple ways, but I threw this together:

$fileEntries = [IO.Directory]::GetFiles(“d:\placeholder”);
$delete = 1;
foreach($fileName in $fileEntries)
{
if ($delete = 1)
Read more

0 comments, 5,409 reads

Posted in The Voice of the DBA on 17 November 2014

T-SQL Tricks – Templates in SSMS

There are lots of little tricks that you can use to become more proficient, and efficient, at writing T-SQL. Here’s a short one that might be more for administrators, but I think for developers it’s very handy as well.

SQL Server tools have included templates for years. I first started… Read more

0 comments, 309 reads

Posted in The Voice of the DBA on 12 November 2014

T-SQL Tuesday #60 – Something New Learned

It’s been five years, and that’s amazing. Not many things last for a year, much less five, but the T-SQL Tuesday party, started by Adam Machanic (B|T)., has been amazing and lots of fun for me.

This month, Chris Yates hosts and his theme is Something… Read more

1 comments, 260 reads

Posted in The Voice of the DBA on 11 November 2014

Expected Variables–T-SQL Testing

After I wrote about creating tables that contain the results I expected, I wondered if I could do the same thing with variables. I was thinking that I’d like to better self-document my tests, and I’d like to be able to do this:

declare @TimeElapsed.Expected int = 25;

It turns… Read more

0 comments, 213 reads

Posted in The Voice of the DBA on 10 November 2014

PASS Keynote–Dr. Rimma Nehme

I missed the PASS welcome, but I did arrive to see Cloud Databases from Dr. Rimma Nehme.

We begin with a few references to Dr. DeWitt, who has given amazing keynotes. It’s a tough act to follow, but Dr. Nehme goes in her own direction. Dr. Nehma is highly… Read more

1 comments, 3,863 reads

Posted in The Voice of the DBA on 6 November 2014

Wednesday PASS Keynote–Microsoft

We open with video, quite long. It’s two parts. The first being a community thanks and embracing of the community. Perhaps a little cheesy, but I do like that executives at Microsoft realize this isn’t just a conference where workers show up and learn. It’s a closer knit community.

The… Read more

0 comments, 209 reads

Posted in The Voice of the DBA on 5 November 2014

Wednesday PASS Keynote–Tom LaRock

We’re live at the opening keynote for the PASS Summit, on Wednesday, Nov 5, 2014. Tom LaRock opens the conference learning with a welcome to everyone, those here in person, and those at home watching on PASS TV.

Tom introduces the board, and say they’ll be in the Community Zone,… Read more

0 comments, 184 reads

Posted in The Voice of the DBA on 5 November 2014

Multiple AGs

Today was my pre-con with Allan Hirt on AlwaysOn. It was great, and I learned a few things. I knew a bit about AGs, but Allan has a ton of experience, and he talked about some architectural things that I didn’t understand.

We had virtual labs, which worked flawlessly. I… Read more

4 comments, 201 reads

Posted in The Voice of the DBA on 5 November 2014

Setting Expectations–T-SQL Testing

I don’t know who started this pattern, as I’ve seen it in a few places. It could have been Sebastian Meine or Dennis Lloyd. Maybe it was Dave Green, who did the Pluralsight course on tSQLt. Not sure, but I like it.

If I’m looking to set up a… Read more

0 comments, 229 reads

Posted in The Voice of the DBA on 3 November 2014

Quick Schema Auditing

I was working on a demo recently and needed to show that a little monitoring can help you catch schema changes. At first I looked at SQL Audit and DDL Triggers, but then I ran across a short custom metric on the SQL Monitor Metrics site that my company, Red… Read more

2 comments, 239 reads

Posted in The Voice of the DBA on 29 October 2014

Default Framing–Window Functions

I’ve been playing with the window functions in T-SQL a bit, and I find them very interesting. They certainly solve some problems very well, in a way that’s much easier than has been available in T-SQL.

However there are some things you need to understand. One of these things is… Read more

2 comments, 6,418 reads

Posted in The Voice of the DBA on 27 October 2014

Off to London

Today I’m off across the Atlantic again. SQL in the City 2014 kicks off in London and I have 3 talks to give on Friday. Plus a keynote.

Today is keynote practice, last minute packing, and then off to the airport for my flight overnight to London. This will be… Read more

0 comments, 212 reads

Posted in The Voice of the DBA on 22 October 2014

Learning Options in Seattle Next Month

The 2014 PASS Summit takes place next month. Actually a few weeks, on Nov 3-7, 2014 in Seattle. While many people attend the conference, there are some additional options for learning that you might think about in addition to the conference itself. While the conference is great, getting deeper dives… Read more

2 comments, 194 reads

Posted in The Voice of the DBA on 16 October 2014

Networking at the PASS Summit

The 2014 PASS Summit is coming up in a few weeks and thousands of SQL Server professionals will be coming to Seattle for the event. Many will arrive early, and many will be there for the first or second time in their careers.

Many of them will be that guy Read more

2 comments, 5,790 reads

Posted in The Voice of the DBA on 15 October 2014

T-SQL Tuesday #59–My Hero

It’s October, and another busy fall is underway for me. It’s also the second Tuesday, so it’s T-SQL Tuesday time again. The invite this month is from Tracy Mckibben, and it’s a neat topic. Not really a technical one, but a fun one that I like.

My Hero! is the… Read more

0 comments, 201 reads

Posted in The Voice of the DBA on 14 October 2014

Final Prep for SQL in the City

I can’t believe this will be the fourth SQL in the City in London next week. It’s amazing to me that we’ve managed to build this great series of one day events that is so popular with SQL Server professionals.

I’m heading back to London next week, a quick trip,… Read more

0 comments, 393 reads

Posted in The Voice of the DBA on 13 October 2014

SQL in the City 2014 – Two countries in two weeks

I have had a fairly busy travel schedule the last few years. While I don’t love sitting on airplanes and being away from home, I do look forward to the events and seeing the amazing #SQLFamily and community we have for SQL Server. I’ve also learned a few tricks to… Read more

0 comments, 207 reads

Posted in The Voice of the DBA on 9 October 2014

Making Better Presentations–Practice

This is part of a series of tips for speakers on how to make your presentations better.

There’s one thing that makes a big difference for many speakers.

Practice

Practice makes perfect, but more importantly, practice develops familiarity. Everyone gets a little nervous on stage, everyone struggled to memorize their… Read more

2 comments, 230 reads

Posted in The Voice of the DBA on 6 October 2014

Newer posts

Older posts