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

Placeholders for Emergencies

A long time ago I worked in a large corporation where we managed lots of servers, each of which performed a variety of different functions. Some were Exchange, some SQL, some file servers, etc. and they would come and go at a frightening pace.

We had monitoring in place, but… Read more

7 comments, 6,645 reads

Posted in The Voice of the DBA on 24 November 2014

Encryption in Colorado Springs – Encrypting in the Application?

Last night was my annual presentation at the Colorado Springs SQL Server User Group. I try to make sure I get down there at least once a year, and it’s been only once a year for the last few years. Far too busy, and I’m sorry for that, but I… Read more

0 comments, 727 reads

Posted in The Voice of the DBA on 20 November 2014

Practical Problems with CI

I agree. Continuous Integration has issues in the real world, at least it probably does in many companies. The more tests you have, the more likely you refactoring or changes will break something. The more things break, the more people will look to leave them alone, deferring the "fix"… Read more

2 comments, 647 reads

Posted in The Voice of the DBA on 20 November 2014

SQL Konference 2015

My first speaking date of the new year is scheduled. I’ll be at the SQL Server Konference 2015, near Frankfurt, Germany. Red Gate arranged things, and I’m looking forward to heading over and renting a car to drive in Germany.

And speaking, of course.

I don’t know the agenda… Read more

0 comments, 709 reads

Posted in The Voice of the DBA on 19 November 2014

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, 8,121 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,868 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, 851 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, 722 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, 535 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, 4,903 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, 811 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, 681 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, 538 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, 704 reads

Posted in The Voice of the DBA on 3 November 2014