adam_machanic.jpg

Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.
http://sqlblog.com http://sqlblog.com/blogs/MainFeed.aspx

Are your big queries using every available clock tick, or are they lagging behind? And if your queries are already going parallel, can they be rewritten for even greater speed? In this session you will learn how to take full advantage of parallelism.
Large, complex queries need memory in which to work--workspace memory--and understanding the how's, when's, and why's of this memory can help you create queries that run in seconds rather than minutes.
Attend this session to learn how to take charge of optimization, expertly mold your query plans, and gain a new set of tools for eliminating bottlenecks in even your most complex problem queries.

Blog posts RSS

Data Camp Sydney (Free) 25 May 2015
Hi Folks, on the 5th June (yes that’s Friday next week), I’m running a Data Camp day for the local Microsoft team. It’s being held at Cliftons in the city. We’ve got four topics for  the day: Azure SQL DB Azure DocumentDB Azure Machine Learning Azure Stream Analytics If you ...

701 24 May 2015
It’s your turn. You start blogging. You cannot start in July 2007 like I did – even if you have a Delorean . But you can start in July 2015. Here’s the thing: In 2023, eight more years will have passed. Will you have posted 700 blog posts by then? You can. How to I know? It’s possible. “What Do I ...

Latest MVA Offerings for SQL Server and for Windows 10 (Yes it’s time to start looking at this) 24 May 2015
The team at Microsoft Virtual Academy (MVA) have pushed out some new content that’s relevant to database people. First, if you’re wondering about using Azure for SQL Server, the Jumpstart for SQL Server in Azure VMs is worth a look. Longer term, I suspect we’ll mostly end up using SQL Server as a ...

700 22 May 2015
Adam Machanic ( Blog | @AdamMachanic ) emailed me way back in July 2007 and asked if I’d be interested in joining the awesome crew blogging at SQLBlog.com . I was honored to be asked and loved the idea of joining the bloggers here (“A group of really smart SQL Server bloggers… plus me”). And wow – ...

BI on your terms with SQL Server 2016 22 May 2015
The last few years Microsoft strategy was all about cloud first (or cloud only?), releasing new BI products and updates to existing products to the cloud in high pace without almost any investments in on-premises BI. In 2015 Microsoft seems to change its course, they now aim more on the ...