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.

Agile Development – A DBA’s Initial Thoughts

I recently had the opportunity to attend a three day Agile development workshop.  At a very high level, Agile development values making small, iterative changes over short periods of time, unlike traditional software development methods that generally involve a large release at the very end of a project.  If you’ve… Read more

0 comments, 130 reads

Posted in Adam Kreul | Blog on 26 August 2015

Studying for the 70-462 Exam: Database Mirroring

If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the short guy in the back, standing on his tippy toes trying to make sure everyone remembers he was there.  Despite this, and the fact that it’s been marked as a… Read more

1 comments, 1,431 reads

Posted in Adam Kreul | Blog on 18 August 2015

10 Signs You’re Enjoying Your DBA Career Too Much

Most database professional recognize they have a good career path, and mostly enjoy the work they do.  It’s possible to cross the line of enjoying it a little too much though.  Here’s some guidelines to asses your situation:

1.  Instead of being excited for the weekend, you’re anxious for Monday… Read more

10 comments, 3,855 reads

Posted in Adam Kreul | Blog on 11 August 2015

Credentials and Proxies: Getting Started

If you’ve been a DBA for more than a day, you probably have a pretty good idea of what a login is.  However, did you know that you can access resources outside of SQL Server without granting the login permissions everywhere, and also run job steps under accounts that don’t… Read more

0 comments, 291 reads

Posted in Adam Kreul | Blog on 4 August 2015

SQL Server Audit: Getting Started

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited events can be written to the server application or security logs, or to a file where you specify the location (the most secure route).   SQL Server Audit is easy to… Read more

0 comments, 1,700 reads

Posted in Adam Kreul | Blog on 28 July 2015

4 Things You’ll Need Before Installing a Failover Cluster Instance

Your servers are either provisioned or racked, your sys admin has taken care of installing the Failover Clustering feature and creating the cluster itself, so you’re good to go to start installing SQL Server right?  Not quite – you still need a few other things and unless you’re a in… Read more

0 comments, 40 reads

Posted in Adam Kreul | Blog on 25 May 2015

The Case for Optimize for Ad Hoc Workloads

I recently was involved in a discussion about whether or not to enable the ‘Optimize for Ad Hoc Workloads’ server configuration setting.  My initial thought was to leave it disabled, since this is the default after all, and we didn’t have a specific situation where it was believed enabling this… Read more

0 comments, 194 reads

Posted in Adam Kreul | Blog on 19 May 2015

Taking (and passing!) the 70-461 Exam and Pursuing My MCSE Certification

Last week, I took the 70-461: Querying Microsoft SQL Server 2012 exam.  I decided recently to try and achieve getting my MCSE: Data Platform certification within the next six months.  Taking this exam was step one, and now I have four remaining.  Rather than spending a bunch of money on… Read more

2 comments, 234 reads

Posted in Adam Kreul | Blog on 12 May 2015

Better Together: Reduced Run Time and I/O

The run-time metric gets all the love, and for good reason.  It’s easily witnessed by end users and the one management cares about.  When DBAs have the task of cutting down the run time of a query, this typically starts in a non production environment, consisting of different server architecture… Read more

0 comments, 198 reads

Posted in Adam Kreul | Blog on 29 April 2015

Use the WordPress Revision Counter to Keep Shipping Posts

I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve wanted to (working hard on this though – at least one post a week!).  There is no getting around it – blogging is time consuming.  Especially technical blogging.  My first… Read more

0 comments, 248 reads

Posted in Adam Kreul | Blog on 24 March 2015

Combating the CXPacket Wait Type

Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of the list.  If this is the case for you as well, chances are your server isn’t on fire, but there could be room for improvement.

What Does It…

Read more

7 comments, 6,333 reads

Posted in Adam Kreul | Blog on 17 March 2015

Making Sense of PCIe SSD Use with SQL Server

When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to achieve 100,000 IOPS, the IT world went wild.  While Fusion IO certainly is a pioneer in the PCIe SSD space, this technology has come a long way in its short… Read more

0 comments, 4,358 reads

Posted in Adam Kreul | Blog on 10 March 2015

Configuring a Complete Memory Dump

Imagine this scenario: One of your servers just crashed, and you open a ticket with Microsoft for them to perform a root cause analysis and hopefully find a solution.  What you get instead is this: “Unfortunately, all we were able to capture was a mini dump that doesn’t provide us… Read more

4 comments, 403 reads

Posted in Adam Kreul | Blog on 6 November 2014

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, 6,509 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,821 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, 556 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, 2,028 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, 370 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

4 comments, 1,251 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, 578 reads

Posted in Adam Kreul | Blog on 7 November 2013

Older posts