|
|||||
|
Just received the confirmation email from Joe Sack, Acting Program Manager Microsoft Certified Master – SQL Server, that I passed the lab exam and am now a Microsoft Certified Master: SQL Server 2008. A link to the blog post on “The Master Blog” is here: http://blogs.technet.com/b/themasterblog/archive/2010/07/31/breadth-and-depth-say-hello-to-randall-neth.aspx  I have just submitted a session to speak at SQL Saturday on October 2 in Kansas City, MO. I plan on speaking on the Microsoft Certified Master (MCM) program. Essentially covering the entire experience from applying for, what you learn, what is expected of you, instructors, relationships built, and pretty much everything in between. I also plan on submitting some other topics just trying to narrow down the selection, leaning towars SAN/Storage design, virtualizing SQL, and/or Effective DataWarehouse design. Information on the event can be found here: http://www.sqlsaturday.com/53/eventhome.aspx The first meeting of the SQL Server/Oracle PASS Virtual Chapter is upcoming on July 14th. Steve Simon of State Street Corporation will discuss Query Performance and Data Access Layers. http://oracle.sqlpass.org/Home.aspx The overview of the meeting is shown below: How often have our SQL Servers and Oracle Servers been bogged down with a myriad of users issuing lengthy and poorly constructed or poorly performing queries against our tables and views. More often than not, nearly bringing our systems to their knees. Nowhere is this truer than within the financial world where heavy number crunching is par for the course. This beginners to intermediate level hands-on presentation is aimed at the SQL Server / Oracle developer and business analyst alike and will show the attendee how we have managed to eliminate 90 % of our poorly performing queries by creating data access layers which provides our end users with a suite of well developed and tuned SQL Server /Oracle FUNCTIONS with which to render their data. The presentation will discuss the high level principles and concepts behind our data access layer, the ways in which data access layers may be implemented with both products, the scenarios under which we have benefited from their usage and then compare and contrast some of the poorly performing queries that we once had..with some more efficient and effective queries that we have now provided to our end users. |
|||||
|
Copyright © 2012 Randall Neth – BI, SQL, & SharePoint - All Rights Reserved |
|||||
