I am currently a database administrator for Integrys Energy Services in De Pere, 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.
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
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