Database Maintenance Plans: A Primer

Database Maintenance Plans: A Primer

Databases and newborns have a lot in common.  They both require constant care.  They both require constant monitoring.  They also may both puke on you in the middle of the night.  Unlike newborns, however, you can set up automated maintenance plans for databases.  If you’re starting a new gig as a DBA, making sure your […]

By October 14, 2014 0 Comments Read More →
Why I’m Not Excited About Hekaton (In-Memory OLTP)

Why I’m Not Excited About Hekaton (In-Memory OLTP)

A while back I had written a post about why I’m excited about Hekaton (now called ‘In-Memory OLTP’ – not sure why, Hekaton is much more fun to say), and while I am certainly still excited about this new feature, it does have some significant barriers to entry.  Here’s a quick hit list of a […]

By September 17, 2014 5 Comments Read More →
A CLR Application:  Deleting Three Billion Rows

A CLR Application: Deleting Three Billion Rows

In one of SQL Server Central’s recent daily newsletters, Steve Jones’s editorial was inquiring whether or not anyone has been using the CLR (common language runtime) integration within SQL Server.  Recently, a change in a business process dictated that we needed to delete over 3 billion rows from a 16 billion row table – not […]

By March 6, 2014 2 Comments Read More →
Fight Career Frustration With Learning

Fight Career Frustration With Learning

If you work in IT, the office becomes your second home.  It’s where we make a living, and most of us take a lot of pride in the work we do.  We feel good when we’ve put in a successful day at the office, however we also have those days where instead of feeling successful, […]

By February 28, 2014 10 Comments Read More →
I’m on Twitter! @AdamKreul

I’m on Twitter! @AdamKreul

I’m just a little late to the party, but no time like the present, right?  I plan to be very active responding to #sqlhelp requests, and will be posting my latest blog posts.  I would greatly appreciate a follow (@AdamKreul), and would be happy to return the favor!  

By February 15, 2014 0 Comments Read More →
Make Your Storage Administrator Your Best Friend

Make Your Storage Administrator Your Best Friend

That guy or gal over there going on and on about spindles and IOPS – that’s your SAN admin.  For the sake of your SQL Server environment, you two need to develop a solid relationship.  Here’s some basic SAN lingo to get you started: LUN LUN is an acronym for Logical Unit Number.  Each volume […]

By February 12, 2014 2 Comments Read More →