Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

DBTA – IT Employers Must Adapt to the Looming DBA Shortage

Originally appearing in my monthly column at Database Trends & Applications magazine.

In the first of this three-part series, I described some of the findings contained in an intriguing new survey published by Unisphere Research, a division of Information Today, Inc. In that article, I covered the macroeconomic and… Read more

2 comments, 42 reads

Posted in Kevin E. Kline on 29 July 2015

Professional Development – Set the Bar High

Originally appearing at ForITPros.com.

Henry Ford is reported to have once said, “Whether you think you can or think you can’t – you’re right.”

That’s great insight. Too often people place self-imposed and artificial limitations on themselves. They tell themselves that they cannot accomplish something because they aren’t smart… Read more

0 comments, 90 reads

Posted in Kevin E. Kline on 23 July 2015

DBTA – Does the Looming Shortage in DBAs Spell Opportunity?

Originally appearing in my monthly column at Database Trends & Applications magazine.

In my last column, available HERE, I described some of the findings contained in an intriguing new survey sponsored by Ntirety, a remote database administration service provider, and published by Unisphere Research. You can read the… Read more

0 comments, 85 reads

Posted in Kevin E. Kline on 22 July 2015

Professional Development – Interviews are a Two-way Street

(Originally appearing at ForITPros.com).

I was recently chatting with a friend who was seeking advice about difficulties in their job. This was a job which, a year ago, she described as her dream job. It quickly became evident to her that it was actually a nightmare job. The company,… Read more

0 comments, 655 reads

Posted in Kevin E. Kline on 16 July 2015

DBTA – Delayed Durability—The SQL Server 2014 Transaction Log Hack!

Originally appearing in my monthly column at Database Trends & Applications magazine.

Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging.

Why turn off the transaction log? It is… Read more

0 comments, 117 reads

Posted in Kevin E. Kline on 15 July 2015

Professional Developement – Digging for Gold

Originally appearing at ForITPros.com.

Andrew Carnegie, once the wealthiest man on earth, came from humble beginnings. As a young boy, he worked a number of odd jobs. His hard work, industrious nature, and persistence eventually led him to become the largest steel manufacturer in the United States.

Once, during… Read more

0 comments, 139 reads

Posted in Kevin E. Kline on 9 July 2015

DBTA – For #SQLFamily, a Most Wonderful Time of the Year!

Originally appearing in my monthly column at Database Trends & Applications magazine.

It’s the holiday season, a time for cheer and goodwill towards men. That got me thinking about the whole “most wonderful time of the year” tune playing in the background and how that has some special implications… Read more

0 comments, 111 reads

Posted in Kevin E. Kline on 8 July 2015

SQLVacation Slides and Scripts

First came the in-person roadtrip.

That Kline family won’t be nearly as good at this as us Griswolds!

Two weeks riding the highways from Nashville, TN to Chicago, IL to St. Louis, MO and back.

One thousand four hundred miles in a minivan with my wife and four daughters.

Eight… Read more

0 comments, 110 reads

Posted in Kevin E. Kline on 2 July 2015

Professional Development – The Stradivarius of Teams

Originally appearing at ForITPros.com.

A world-class violinist was on campus for an artist-in-residence program. While at lunch he was discussing what he perceived to be the similarities between management and great music. Said the violinist, “I have glorious music, a splendid instrument, and an exquisite bow. All I need… Read more

1 comments, 122 reads

Posted in Kevin E. Kline on 2 July 2015

DBTA – Russian Hackers Steal 1.2b Internet Credentials: Or, Why the Heck Does this Keep Happening?!

I’m decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I’ll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them… Read more

0 comments, 101 reads

Posted in Kevin E. Kline on 1 July 2015

#SQLVacation Finale in the Music City – Nashville, TN

 

All good things must come to an end and, after logging almost 1400 miles on the road, the #SQLVacation road trip returns to its home city – Nashville, TN, the “Music City”. Eight SQL Server users groups, eight matching blog posts, two hundred t-shirts, and many hundreds of… Read more

1 comments, 125 reads

Posted in Kevin E. Kline on 26 June 2015

#SQLVacation Postcard from Evansville, Indiana

Our long #SQLVacation is nearly at an end because our stop in Evansville, IN is our last roadtrip location for the family and the penultimate (i.e., second to last) technical session of the journey. It’s a bittersweet, fersher.

Evansville is such a beautiful place that it was name La Belle… Read more

1 comments, 138 reads

Posted in Kevin E. Kline on 24 June 2015

#SQLVacation and the Gateway to the West

The Griswolds had an experience they’ll never forget in St. Louis. And we’ve had ours too, but in a very good way. We’d vacationed in St. Louis two years ago and had a great time. We’ve seen the sights, gotten the pictures, and have the t-Shirts. I still love to… Read more

1 comments, 110 reads

Posted in Kevin E. Kline on 23 June 2015

#SQLVacation meets Abraham Lincoln

In the movie, National Lampoon’s Vacation, Clark and Ellen Griswold decide to lead their family, including the kids Rusty and Audrey, on a cross-country expedition from the Chicago area to the Los Angeles amusement park Walley World, touted as “America’s Favorite Family Fun Park.” Ellen sensibly wants to fly, but… Read more

1 comments, 128 reads

Posted in Kevin E. Kline on 22 June 2015

#SQLVacation Postcard from the Miracle Mile, Chicago, IL

Of the hundreds of cities that I’ve visited around the world, Chicago is one of my favorites. The food. The museums. The architecture. The scenery. It’s all good – except for those outrageously cold winters. So I was really excited when my family agreed that they’d enjoy spending their summer… Read more

0 comments, 133 reads

Posted in Kevin E. Kline on 19 June 2015

#SQLVacation Postcard from Downers Grove, IL

I’ve been to Chicagoland many times over the years. During the 1990’s, when I worked for Deloitte, I occasionally traveled to the practice office in downtown Chicago or to the tax practice in Deerfield. In the later 1990’s and early 2000’s (a.k.a. “the aughts”), I frequently traveled to the original… Read more

1 comments, 133 reads

Posted in Kevin E. Kline on 18 June 2015

#SQLVacation Postcard from Indianapolis, IN

For some people, Indianapolis means one thing, and one thing only – the Indianapolis Motor Speedway (a.k.a “The Brickyard”)  and the Indianapolis 500. In my case, it means several times speaking at IndyPASS, the local SQL Server User Group, over the last 10 years. I first spoke at… Read more

0 comments, 148 reads

Posted in Kevin E. Kline on 16 June 2015

#SQLVacation Postcard from Louisville, KY

 

Along the banks of the mighty Ohio River, in sight of the shores of Indiana, lies beautiful Louisville, KY. Louisville is a place with a strong connection for me. (No, not because I drink bourbon, although that’s a pretty good reason to like the place, come to… Read more

0 comments, 139 reads

Posted in Kevin E. Kline on 15 June 2015

ICYMI: Parameter Sniffing, Friends with Partition Benefits, and SELECT INTO Parallelism – SQL Server Performance

Great topics for further reading about tuning SQL Server performance:

Exploring SQL Server 2014 SELECT INTO Parallelism

Joe Sack (b | t) provides us with a peak into the performance improvements and new behaviors of SQL Server 2014 in the way it can now parallelize large SELECT INTO… Read more

2 comments, 130 reads

Posted in Kevin E. Kline on 6 April 2015

Advice to New Bloggers

PREAMBLE

If you’ve been reading my blog for a while, you know that I travel and speak quite a lot. A frequent question I’m asked at these events is “I want to start blogging, but don’t know where to start. What do you recommend?” This is a such a common… Read more

5 comments, 224 reads

Posted in Kevin E. Kline on 31 March 2015

Older posts