Studying for the 70-462 Exam: Database Mirroring

• by Adam-Kreul

• Adam Kreul | Blog

If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the...

2015-08-27 (first published: 2015-08-18)

2,372 reads

Agile Development – A DBA’s Initial Thoughts

• by Adam-Kreul

• Adam Kreul | Blog

I recently had the opportunity to attend a three day Agile development workshop.  At a very high level, Agile development...

2015-08-26

602 reads

10 Signs You’re Enjoying Your DBA Career Too Much

• by Adam-Kreul

• Adam Kreul | Blog

Most database professional recognize they have a good career path, and mostly enjoy the work they do.  It’s possible to cross the...

2015-08-11

4,636 reads

SQL Server Audit: Getting Started

• by Adam-Kreul

• Adam Kreul | Blog

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited...

2015-08-06 (first published: 2015-07-28)

3,425 reads

Credentials and Proxies: Getting Started

• by Adam-Kreul

• Adam Kreul | Blog

If you’ve been a DBA for more than a day, you probably have a pretty good idea of what a...

2015-08-04

1,444 reads

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

• by Adam-Kreul

• Adam Kreul | Blog

Your servers are either provisioned or racked, your sys admin has taken care of installing the Failover Clustering feature and...

2015-05-25

464 reads

The Case for Optimize for Ad Hoc Workloads

• by Adam-Kreul

• Adam Kreul | Blog

I recently was involved in a discussion about whether or not to enable the ‘Optimize for Ad Hoc Workloads’ server...

2015-05-19

790 reads

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

• by Adam-Kreul

• Adam Kreul | Blog

Last week, I took the 70-461: Querying Microsoft SQL Server 2012 exam.  I decided recently to try and achieve getting...

2015-05-12

775 reads

Better Together: Reduced Run Time and I/O

• by Adam-Kreul

• Adam Kreul | Blog

The run-time metric gets all the love, and for good reason.  It’s easily witnessed by end users and the one...

2015-04-29

1,021 reads

Combating the CXPacket Wait Type

• by Adam-Kreul

• Adam Kreul | Blog

Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of...

2015-03-24 (first published: 2015-03-17)

7,369 reads