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.
Archives: October 2013
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
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