|
|
|
|
|
|
|
|
|
Degrees
|
|
Programming Degree, Advanced Microsoft SQL Server classes
|
|
|
My Expert Service
|
|
I have 10 years experience with SQL Server and an excellent understanding of the internals of SQL Server 2000, 2005 & 2008.
I recently started the website SQLServerPlanet.com which provides informative articles on all versions of SQL Server.
In the past, I have optimized many queries for all the companies I worked for and in all cases have made dramatic improvements in the throughput of the systems. I have extensive knowledge in SQL Server's query optimizer and the options it chooses for generating query plans including statistical samples, join algorithms, and index optimizations.
I have also taken two advanced SQL Server 2005 classes specializing in query optimization and deployment which are the same classes available to internal Microsoft employees. Additionally I am well versed in the 8 different areas that SQL Server can have a bottleneck and can quickly identify and troubleshoot. These include contention with processor, disk, blocking, memory, page file, network, recompilation, and process trimming. Applying this knowledge with the information gathered from performance monitor, I can quickly diagnose slowdowns on most systems.
Along with my SQL skills I am also versed in the internals of Microsoft Windows and it's subsystems. This includes a good understanding of IIS / NTFS Security / Transport protocols, authentication, and networking.
In all my positions I have been a senior-level developer and Data Architect.
|
|
|
Experience & Qualifications
|
|
TSQL, Data Warehousing, Database Engine, Data Architecture, Data Transfer, Data Scrubbing, Optimization. N-Tier Troubleshooting. Expert-level understanding of IIS. C#, ASP.NET, and ASP.
|
|
|
Available Modes Of Communication
|
|
email/chat
|
|
|
|
|
Contact
SQL Derek
|
|
|
|
|
|
|