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

Adam Kreul | Blog

I am currently a Senior DBA for Integrys Energy Services in Green Bay, WI. I’ve been a DBA since 2008 and have worked primarily with SQL Server versions 2005 and above supporting databases as large as 6TB.

Although my title says “DBA”, I also play the role of SAN administrator and data warehouse developer. I love learning and applying new technology and have a passion for making the environment I support as fast as possible. My blog is syndicated from www.adamkreul.com and you can follow me on Twitter at @AdamKreul.

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… Read more

0 comments, 4,978 reads

Posted in Adam Kreul | Blog on 14 October 2014

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… Read more

5 comments, 7,295 reads

Posted in Adam Kreul | Blog on 17 September 2014

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… Read more

2 comments, 404 reads

Posted in Adam Kreul | Blog on 6 March 2014

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…

Read more

10 comments, 1,746 reads

Posted in Adam Kreul | Blog on 28 February 2014

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! Read more

0 comments, 254 reads

Posted in Adam Kreul | Blog on 15 February 2014

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… Read more

2 comments, 1,100 reads

Posted in Adam Kreul | Blog on 12 February 2014

Configuring the RecycleTime SSRS Setting

If you administer a SQL Server Reporting Services server, chances are you’ve had users complain the report manager is loading slow.  You go out the report manager to investigate, and it loads normally.  You have the end user try again, and this time it works fine for them too.  You… Read more

0 comments, 366 reads

Posted in Adam Kreul | Blog on 7 November 2013

Why I’m Excited About Hekaton

I recently read Microsoft’s research paper on Hekaton, the new in-memory database engine in SQL Server 2014.  When I first heard about it, I was pretty excited, but after reading the deep dive specs, I’m ecstatic.  I highly recommend checking out the research paper in its entirety, but… Read more

4 comments, 873 reads

Posted in Adam Kreul | Blog on 22 October 2013

SQL Server Partitioning: Getting Started

Partitioning is a feature that has been around since SQL Server 2005.  It allows for users to split a table across multiple filegroups.  Multiple filegroups means the opportunity to store a table across multiple volumes.  If you have a SAN that has disk tiers, you can use partitioning to store… Read more

0 comments, 435 reads

Posted in Adam Kreul | Blog on 12 October 2013