Search results matching tag 'Infrastructure'http://www2.sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Infrastructure&orTags=0Search results matching tag 'Infrastructure'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Database Trends &amp; Applications column: Database Benchmarking from A to Zhttp://www2.sqlblog.com/blogs/kevin_kline/archive/2013/07/24/database-trends-applications-column-database-benchmarking-from-a-to-z.aspxWed, 24 Jul 2013 11:55:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:50237KKline<a style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;" href="http://kevinekline.com/wp-content/uploads/2013/07/IMG_0415a.jpg"><img class="alignright size-medium wp-image-5727" alt="IMG_0415a" width="300" height="284" style="border:0px;cursor:default;float:right;" src="http://kevinekline.com/wp-content/uploads/2013/07/IMG_0415a-300x284.jpg"></a><p><span style="font-size:13.333333969116211px;font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:18.99305534362793px;">Have you heard of the monthly print and web magazine&nbsp;</span><a mce_href="http://dbta.com/" style="font-size:13.333333969116211px;font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:18.99305534362793px;" href="http://dbta.com/">Database Trends &amp; Applications</a><span style="font-size:13.333333969116211px;font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:18.99305534362793px;">&nbsp;(DBTA)?&nbsp;</span></p><span style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"></span><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;">Did you know I'm the&nbsp;<a mce_href="http://www.dbta.com/Articles/MoreNews.aspx?ContextID=329" href="http://www.dbta.com/Articles/MoreNews.aspx?ContextID=329">regular columnist covering SQL Server</a>? &nbsp;For the past six months, I've been writing a series of articles about database benchmarking culminating in the latest article discussing my three favorite database benchmarking tools:&nbsp;&nbsp;the free, open-source HammerDB, the native SQL Server Distributed Replay Utility, and the commercial Benchmark Factory from Dell / Quest Software. </p>
<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;">Wondering what else I wrote about in this series of six articles on database benchmarking? Pop on over to my latest database benchmarking article (<a style="font-family:Arial, Helvetica, sans-serif;font-size:10pt;" href="http://kevinekline.com/2013/07/24/new-on-dbta-com-database-benchmarking-tools-the-final-article-in-the-database-benchmarking-series/">http://kevinekline.com/2013/07/24/new-on-dbta-com-database-benchmarking-tools-the-final-article-in-the-database-benchmarking-series/</a>)&nbsp;<span style="font-size:13.333333969116211px;line-height:18.99305534362793px;">in the series to get a recap of all of the articles.</span></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"><span style="font-size:13.333333969116211px;line-height:18.99305534362793px;">Pictured (L-R): Scott Klein (</span><a target="_blank" style="font-size:13.333333969116211px;line-height:18.99305534362793px;" href="http://geekswithblogs.net/ScottKlein/Default.aspx">Blog</a><span style="font-size:13.333333969116211px;line-height:18.99305534362793px;">), me, and&nbsp;Tobiasz Koprowski (</span><a style="font-size:13.333333969116211px;line-height:18.99305534362793px;" href="https://twitter.com/#!/KoprowskiT">Twitter</a><span style="font-size:13.333333969116211px;line-height:18.99305534362793px;">&nbsp;|&nbsp;</span><a style="font-size:13.333333969116211px;line-height:18.99305534362793px;" href="http://koprowskit.eu/geek">Blog</a><span style="font-size:13.333333969116211px;line-height:18.99305534362793px;">) at the SQL Relay event in Glasgow, Scotland.</span><span style="font-size:13.333333969116211px;line-height:18.99305534362793px;">&nbsp;</span></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;">Have you ever run your own database benchmarks? If so, what tools did you use? &nbsp;Tell me what you think!</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;">Best regards,</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;">-Kevin</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"><a href="http://twitter.com/kekline">-Follow me on Twitter!</a><br></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"><a style="font-size:13.333333969116211px;line-height:18.99305534362793px;" href="https://plus.google.com/u/1/113032055249023350257?rel=author">-Google Author</a>&nbsp;</p>New On-Line Resources for Windows, Virtualization, and Cloud!http://www2.sqlblog.com/blogs/kevin_kline/archive/2013/05/22/new-on-line-resources-for-windows-virtualization-and-cloud.aspxWed, 22 May 2013 19:29:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:49181KKline<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;">Ever since returning from the UK for the SQLBits conference, I've been snowed under a mountain of action items. &nbsp;I've got such a backlog of things to get done, emails to answer, and family to not ignore that I'm starting to feel&nbsp;<em>really&nbsp;</em>guilty. &nbsp;</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;">So with that in mind, I wanted to whip out a quick blog post to let you know I'm still alive and thinking of y'all. &nbsp;What could be quicker and easier than some cool new resources you might not have seen? &nbsp;For your perusal: &nbsp;</p><ul style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"><li>Whitepaper: Managing Windows 7 and Windows 8 Side-by-Side<ul><li><a href="http://www.microsoft.com/en-us/download/details.aspx?id=37144">http://www.microsoft.com/en-us/download/details.aspx?id=37144</a></li></ul></li><li>Poster: Networking in Virtual Machine Manager<ul><li><a href="http://www.microsoft.com/en-us/download/details.aspx?id=37137">http://www.microsoft.com/en-us/download/details.aspx?id=37137</a></li></ul></li><li>Windows Server 2012: Core Network Companion Guide for Deploying IP Addressing in Branch Offices<ul><li><a href="http://www.microsoft.com/en-us/download/details.aspx?id=37034">http://www.microsoft.com/en-us/download/details.aspx?id=37034</a></li></ul></li><li>Become a Virtualization Expert in 20 Days ( Blog Article Series )<ul><li><a href="http://aka.ms/VirtExpert">http://aka.ms/VirtExpert</a></li></ul></li><li>Build Your Private Cloud in a Month ( Blog Article Series )<ul><li><a href="http://aka.ms/BuildYourCloud">http://aka.ms/BuildYourCloud</a></li></ul></li><li><span style="line-height:19px;">Windows Server 2012 “Early Experts” FREE IT Pro Study Group</span><ul><li><a href="http://earlyexperts.net/">http://EarlyExperts.net</a></li></ul></li></ul><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;">Let me know what you think. &nbsp;Thanks,</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;">-Kevin</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"><a href="http://twitter.com/kekline">- Follow me on Twitter!</a></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:13.333333969116211px;line-height:18.99305534362793px;"><a href="https://plus.google.com/u/1/113032055249023350257?rel=author">- Google Author</a></p>Learn More About SQL Server IO and Query Tuning in These Webcastshttp://www2.sqlblog.com/blogs/kevin_kline/archive/2012/12/14/learn-more-about-sql-server-io-and-query-tuning-in-these-webcasts.aspxFri, 14 Dec 2012 18:50:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46662KKline
<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.</p>
<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp;</p>
<h2 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">SSDs are a Game Changer for SQL Server Storage</h2>
<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">No, session is not exclusively about SSDs. &nbsp;But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks. &nbsp;As Bob Dylan said "Times, they are a'changin'". &nbsp;This session on Wednesday, December 19th at 11:30 AM EST, sponsored by Astute Networks, takes you through all of the basics of storage and IO tuning, regardless of the underlying storage technology. &nbsp;I'll show you how SQL Server handles storage structures, how to identify IO activity on Windows and SQL Server, and best practices for minimizing IO bottlenecks. &nbsp;Register now for:<a title="Kevin Kline's Storage IO Best Practices for SQL Server" href="http://bit.ly/UcXYI3">&nbsp;Storage IO Best Practices for SQL Server and a New Approach to Solving Application Performance Issues</a>.</p>
<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp;</p>
<h2 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">Write Better SQL Queries</h2>
<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">The next webcast on Wednesday, December 19th at 2 PM EST, is with me, Aaron Bertrand &nbsp;(<a href="https://twitter.com/#!/AaronBertrand">Twitter&nbsp;</a>|&nbsp;<a href="http://sqlblog.com/blogs/aaron_bertrand/rss.aspx">Blog</a>)&nbsp;and SQLCruise Impresario &amp; Microsoft MVP Tim Ford &nbsp;(<a href="https://twitter.com/#!/sqlagentman">Twitter</a>&nbsp;|&nbsp;<a href="http://www.ford-it.com/sqlagentman/">Blog</a>)&nbsp;as we take you through the query tuning process, discussing important DMVs to use during query tuning, as well as demonstrating several essential query tuning techniques that every SQL developer should know. &nbsp;Not only are we presenting an hour of top quality technical content, we’ll also be giving away some cool prizes, including the grand prize of a paid registration for the upcoming&nbsp;<a target="_blank" href="http://elink.sqlsentry.net/c/1/?aId=67857085&amp;requestId=b34612-273953cd-e600-4a18-979a-a9f2ded860bd&amp;rId=lead-a407ed107f65de119513001e0b614992-c233a49718324979b0d8efc0614ff5d0&amp;ea=aunefuonetre=pbz=vagrepreir&amp;dUrl=http%3A%2F%2Fsqlcruise.com%2F2013-cruises%3F_cldee%3DbmhhcnNoYmFyZ2VyQGludGVyY2VydmUuY29t&amp;uId=0">SQLCruise Miami</a>, a $1,395 value! &nbsp;Register now for:&nbsp;<a title="SQL Server Query Tuning Best Practices, Hosted by Kevin Kline, Aaron Bertrand, and Tim Ford" href="http://bit.ly/UskPPm">SQL Server Query Tuning Best Practices, Hosted by Kevin Kline and Aaron Bertrand with special guest Tim Ford</a></p>
<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp;</p>
<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">I hope to see you at both of these sessions next week! &nbsp;Best regards,</p>
<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">-Kev</p>
<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a title="Kevin E. Kline on Twitter" href="http://twitter.com/kekline">-Follow me on Twitter!</a></p>Let's Talk Licensing and Virtualization for SQL Serverhttp://www2.sqlblog.com/blogs/kevin_kline/archive/2012/12/13/let-s-talk-licensing-and-virtualization-for-sql-server.aspxThu, 13 Dec 2012 19:23:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46647KKline<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">I have two new articles up on&nbsp;<a title="Database Trends &amp; Applications magazine" href="http://www.dbta.com/">Database Trends &amp; Applications magazine</a>. &nbsp;I'd love to get your thoughts and feedback!</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a href="http://www.dbta.com/Articles/Columns/SQL-Server-Drill-Down/Welcome-to-the-Weird-Wild-World-of-Licensing-86588.aspx"><br></a></p><h2 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">Welcome to the Weird, Wild World of SQL Server Licensing</h2><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">Not long in the past, SQL Server licensing was an easy and straightforward process. You used to take one of a few paths to get your SQL Server licenses. The first and easiest path was to buy your SQL Server license with your hardware. Want to buy a HP Proliant DL380 for a SQL Server application? Why not get your SQL Server Enterprise Edition license with it at the same time? Just pay the hardware vendor for the whole stack, from the bare metal all the way through to the Microsoft OS and SQL Server....</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a id="ctl00_ContentPlaceHolder1_ctl00_ctl00_rptArticles_ctl01_IssueName" href="http://www.dbta.com/Newsletters/DBTA-E-Edition">DBTA E-Edition</a>&nbsp;-&nbsp;<a id="ctl00_ContentPlaceHolder1_ctl00_ctl00_rptArticles_ctl01_ArticleIssue" href="http://www.dbta.com/Newsletters/DBTA-E-Edition/3644-December-2012.htm">December 2012 Issue</a></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a href="http://www.dbta.com/Articles/Columns/SQL-Server-Drill-Down/Virtualization-Conquers-the-Database-86186.aspx"><br></a></p><h2 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">Virtualization Conquers the Database</h2><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">I was privileged to deliver a session entitled Managing SQL Server in a Virtual World at the PASS Summit 2012, the largest annual conference for Microsoft SQL Server. It was a packed house, literally at standing-room-only capacity. I delivered the session with my friend David Klee and we were swarmed by attendees after the session wrapped up. With almost 600 people in the room, we conducted one of those informal polls that speakers like to do along the lines of "Raise your hands if …" and the informal findings were very telling. Probably around 90% of the attendees used VMware and SQL Server in some capacity and at least 60% used it in production environments. Another important fact was that only 10% of the attendees were actually able to get information on the performance of the actual VMs themselves. Most had to get all of their information and support from the VM / System administration staff....</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a id="ctl00_ContentPlaceHolder1_ctl00_ctl00_rptArticles_ctl03_IssueName" href="http://www.dbta.com/Newsletters/DBTA-E-Edition">DBTA E-Edition</a>&nbsp;-&nbsp;<a id="ctl00_ContentPlaceHolder1_ctl00_ctl00_rptArticles_ctl03_ArticleIssue" href="http://www.dbta.com/Newsletters/DBTA-E-Edition/3600-November-E-Edition.htm">November E-Edition Issue</a></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp;</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a href="http://twitter.com/kekline">Follow me on Twitter!</a></p>Conquer Your Fear of Virtualization with a Free Day of Training at PASS!http://www2.sqlblog.com/blogs/kevin_kline/archive/2012/10/18/conquer-your-fear-of-virtualization-with-a-free-day-of-training-at-pass.aspxThu, 18 Oct 2012 16:50:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:45668KKline<p style="line-height:19px;">Click this link to register: <a href="http://www.houseofbrick.com/education/sqlserverbootcamp/Registration">http://www.houseofbrick.com/education/sqlserverbootcamp/Registration</a>. </p>
<p style="line-height:19px;"><a href="http://www.houseofbrick.com/education/sqlserverbootcamp/Registration"><img style="border:0px currentColor;width:922px;height:622px;float:right;cursor:default;" class="alignright size-large wp-image-2097" title="HOB Virtualization" alt="HOB Virtualization" src="http://kevinekline.com/wp-content/uploads/2012/10/HOB-Virtualization-1024x691.png" width="922" height="622"></a></p>
<p style="line-height:19px;">Presented by my buddy, David Klee at House of Brick, one of the nations top VMWare consultancies specializing in Oracle and SQL Server deployments.</p>
<p style="line-height:19px;">David has a great write-up of this boot camp at&nbsp;<a title="David Klee's Blog" href="http://www.davidklee.net/2012/10/01/virtualizing-your-business-critical-sql-servers-free-boot-camp-by-house-of-brick/">http://www.davidklee.net/2012/10/01/virtualizing-your-business-critical-sql-servers-free-boot-camp-by-house-of-brick/</a>.</p>
<object style="position:absolute;z-index:1000;" id="plugin0">
</object>Build Your Own Microsoft Operations Manager Packhttp://www2.sqlblog.com/blogs/kevin_kline/archive/2012/05/03/build-your-own-microsoft-operations-manager-pack.aspxThu, 03 May 2012 15:25:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:43125KKline<h2 style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><strong>Operations Manager Management Pack Development Kit</strong></h2><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">I just recently told you about&nbsp;<a title="Cool New Things in Microsoft System Center" href="http://kevinekline.com/?p=1941">some cool new things happening with System Center</a>&nbsp;- before I stumbled across this tidbit. &nbsp;Hey, if I could, I'd go back in time and add this entry to the previous one --- yeah, and totally NOT play the stock market to make a fortune through time travel. &nbsp;But I digress...</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">So the Operations Management Management Pack Development Kit applies to Microsoft Operations Manager 2012 and Microsoft System Center Operations Manager 2007. &nbsp;It&nbsp;provide the you with all of the info need to design and build a management pack intended of your own for monitoring an application via Operations Manager.</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">At last! You can now manage all of those FoxPro and Access 2.o apps you've still got in production. &nbsp;More info at:</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;padding-left:30px;"><a href="http://msdn.microsoft.com/en-us/library/ee533840.aspx">http://msdn.microsoft.com/en-us/library/ee533840.aspx</a></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;padding-left:30px;"><a href="http://blogs.technet.com/b/mpauthor/archive/2011/09/21/new-module-documentation.aspx">http://blogs.technet.com/b/mpauthor/archive/2011/09/21/new-module-documentation.aspx</a></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp;</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp;Let me know what you think! Enjoy,</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">-Kev&nbsp;</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp; Follow me on&nbsp;<a title="Kevin Kline's Twitter Feed" href="http://twitter.com/kekline">Twitter</a>!</p>How is Microsoft IT using the Cloud?http://www2.sqlblog.com/blogs/kevin_kline/archive/2012/05/02/how-is-microsoft-it-using-the-cloud.aspxWed, 02 May 2012 15:46:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:43124KKline<p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">Steve Balmer very publicly pronounced that Microsoft was “all in” for cloud computing and Windows Azure. &nbsp;So that means Microsoft is using cloud for its internal IT as well as building products to utilize the cloud. &nbsp;If you want to learn how Microsoft IT is using Windows Azure to move existing applications to the cloud and creating new applications for the cloud, click here:&nbsp;<a title="Microsoft IT Showcase on Windows Azure" href="http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7d5ba4e0-6ae2-4310-bf51-5aac2bf9b27f">IT Showcase on Windows Azure</a>.</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;"><a href="http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7d5ba4e0-6ae2-4310-bf51-5aac2bf9b27f"></a></p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">Let me know what you think. &nbsp;Accurate and informative? Or marketing fluff?</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">Thanks,</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">-Kevin</p><p style="font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;line-height:19px;">&nbsp;Follow me on&nbsp;<a title="Kevin Kline's Twitter Feed" href="http://twitter.com/kekline">Twitter</a>!</p>New White Paper: SQL Server Extended Events and Notificationshttp://www2.sqlblog.com/blogs/kevin_kline/archive/2012/04/25/new-white-paper-sql-server-extended-events-and-notifications.aspxWed, 25 Apr 2012 13:13:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:42932KKline<p>SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. &nbsp;There's PerfMon, and Profiler, and loads of Dynamic Management Views to check. &nbsp;But where to look?</p><p>As database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white paper, we will look at a couple technologies – event notifications and extended events – that can help you achieve these goals. With these two features, we’ll look at the error log and deadlocks, and demonstrate how you can get relevant information delivered as it occurs. We’ll also look at ways that run-time errors can be captured and used to help reduce the amount of time required to investigate issues.</p><p>This white paper, written by SQL Server MVP Jason Strate (<a title="Jason Strate's SQL Server Blog" href="http://www.jasonstrate.com/">blog</a>&nbsp;|&nbsp;<a title="Jason Strate's Twitter Feed" href="http://twitter.com/stratesql">twitter</a>), is a free download <em>but requires a registration</em>.&nbsp; <a title="Microsoft SQL Server Extended Events White Paper" href="http://www.quest.com/whitepaper/how-to-use-sql-servers-extended-events-and-notifications816315.aspx">Download the Extended Events white paper here</a>.</p><p>And, as always, I enjoy your feedback. &nbsp;Thanks!</p><p>-Kev</p><p>&nbsp;Follow me on&nbsp;<a title="Kevin Kline's Twitter Feed" href="http://twitter.com/kekline">Twitter</a>!</p>New on &quot;Database Trends &amp; Applications&quot;http://www2.sqlblog.com/blogs/kevin_kline/archive/2011/08/16/new-on-database-trends-applications.aspxTue, 16 Aug 2011 19:37:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:37854KKline<p>In last month's column, "2012 Might Really Be the End of the World as
We Know It," I described a number of major developments in the IT
industry that are likely to disrupt the life of database professionals
everywhere.&nbsp; I categorize those four disruptors - virtualization, cloud
computing, solid state drives (SSD), and advanced multi-core CPUs - into
two broad groups.&nbsp; I'm going to continue an analysis of these
disruptive technologies in inverse order.&nbsp; Today, let's discuss SSDs. </p>[READ MORE ON <em><a href="http://www.dbta.com/Articles/Columns/SQL-Server-Drill-Down/The-Changing-State-of-Hardware-77029.aspx" target="_blank" title="Kevin Kline's Database Trends and Applications Magazine Column">DATABASE TRENDS &amp; APPLICATIONS</a> </em>]Microsoft Document Watch for Operational Excellencehttp://www2.sqlblog.com/blogs/kevin_kline/archive/2011/08/08/microsoft-document-watch-for-operational-excellence.aspxMon, 08 Aug 2011 19:59:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:37621KKlineBack when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of <em>operational excellence</em>. I read everything I could on the topic. I made a list of favorites, which became somewhat shabby over time, as I dog-eared important pages and scribbled notes in the margins. (Perhaps that list of favorites might, in and of itself, make a good blog post). Fast-forward a decade and I'm still mightily interested in operational excellence for IT organizations. It's just that <em>so much </em>good material is available for free on the web.
Here's a run-down of several useful documents and downloads to improve overall operation performance for those of you in a Microsoft-centric IT organization:
<h3>Microsoft Operations Framework</h3>
<a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&amp;familyid=457ed61d-27b8-49d1-baca-b175e8f54c0c" title="Microsoft Operations Framework (MOF)" target="_blank"><em>Microsoft Operations Framework</em> (MOF) version 4.0 guide</a> is practical guidance for IT organizations. With the release of version 4.0, MOF now reflects a single, comprehensive IT service lifecycle—it helps IT professionals connect service management principles to everyday IT tasks and activities and ensures alignment between IT and the business.
<h3>Infrastructure Planning and Design</h3>
The <a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&amp;familyid=ad3921fb-8224-4681-9064-075fdf042b0c" title="Microsoft Infrastructure Planning and Design Guide" target="_blank"><em>Infrastructure Planning and Design</em> (IPD) guides</a> are the next version of Windows Server System Reference Architecture. The guides in this series help clarify and streamline design processes for Microsoft infrastructure technologies, with each guide addressing a unique infrastructure technology or scenario.
<h3>Microsoft Baseline Security Analyzer 2.2 (for IT Professionals)</h3>
The <em><a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&amp;familyid=02be8aee-a3b6-4d94-b1c9-4b1989e0900c" title="Microsoft Baseline Security Analyzer" target="_blank">Microsoft Baseline Security Analyzer</a></em> provides a streamlined method to identify missing security updates and common security misconfigurations. MBSA 2.2 is a minor upgrade correct minor issues and add optional catalog support.
<h3>Security Compliance Manager</h3>
The <a href="http://www.microsoft.com/downloads/details.aspx?displaylang=en&amp;familyid=5534bee1-3cad-4bf0-b92b-a8e545573a3e" title="Microsoft Security Compliance Manager" target="_blank">Microsoft Security Compliance Manager</a> provides centralized security baseline management features, a baseline portfolio, customization capabilities, and security baseline export flexibility to accelerate your organization’s ability to efficiently manage the security and compliance process for the most widely used Microsoft technologies.