Hi, Thanks for visiting. If you’re here, then you likely have a SQL Server problem you need to fix. You’re in the right place. Whether you need a consultant to solve a burning issue or you just need a question answered, I’m here to help. Feel free to email me at: derek@sqlserverplanet.com.
Background
I’m a native Californian based out of Los Angeles. My mission revolves around creating the right solution for the customer, as I don’t believe there’s such thing as a purist “one size fits all” solution for everyone. In order to accomplish this goal, I’ve found it takes a combination of listening closely to the customer’s needs then aligning that vision with a technical solution that will not only facilitate the client’s current objective, but provide a platform to take them well into the future.
My technical background involves working with SQL Server for 11 years. I understand its products and internals very well. In my past experiences, I’ve seen what works and what doesn’t work. I am confident I can put you in touch with the right solution for the job.
From a design perspective, I have over 8 years experience in Data Architecture. This includes Data Warehousing, Reporting Setups, Rules Engines and Schema designs and application interfaces. My methodologies center around modular designs that have minimal points of failure with minimal footprint. I believe in designing systems that move data as quickly as possible with the smallest impact on the source system.
From an optimization perspective, my specialties include strong T-SQL skills and an excellent understanding of the internals of SQL Server 2000 through SQL 2008. I have optimized many SQL Servers for all companies I have worked for and quickly (within days) 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 selection. I have also taken two advanced Microsoft Employee level SQL Server 2005 classes specializing in query optimization.
SQL Server Tuning Consulting
Being well versed in the 10 different areas that SQL Server can have a bottleneck, I am able to quickly identify and troubleshoot. Some of these bottlenecks include contention with processor, disk, blocking, memory, page file, network, recompilation, and process trimming. Applying this knowledge with the information gathered from performance monitor, DMVs and Profiler, I can quickly diagnose slowdowns on most systems. This article summarizes some of my troubleshooting methodologies.
N-Tier Troubleshooting
Often times, the slowness issues are not related to SQL Server. If you hire a consultant that only knows how to troubleshoot SQL Server, then you may never get to the bottom of the issue. I also have experience in N-tier troubleshooting. This is important because sometimes the slowness is not always SQL Server, but instead a bottleneck in another tier. Make sure to hire a consultant that can rule this out.
SQL Server Architecture
Besides SQL Server troubleshooting, I have held multiple architect positions. These positions include designing entire systems from the ground up, including rules engines, data warehouses, reporting systems, database schemas. Because my designs are modular and have minimal points of failure, I have a good history of creating dependable systems that require minimum maintenance which can be built upon rather than being re-built.
I have also developed many data flows. These include real-time operational reporting designs based on change data capture, data warehouse historical type 3 changing dimension refreshes, and many reporting solutions including scale out setups of reporting services. You can find a list of some of my consulting projects here.
Windows knowledge
Along with my SQL skills I am also versed in the internals of Microsoft Windows and it’s Subsystems. This includes a strong understanding of IIS / NTFS Security / Transport protocols, authentication, and networking. Along with hardware expertise, this is what you need in a consultant if you want your issues solved quickly.
If you are interested, call me at: 424-229-2775 (2SQL) or email me at: derek@sqlserverplanet.com
Thanks!
Popular search terms:
Hi Derek, in sql2000 i can see the sessions connected thru the lan doing “select * from sysprocesses”, now i’m working with a web application, the users are connected thru the internet. I can’t see all the sessions with sysprocesses. What can I do? How can I see them?.
Hi Marco,
It sounds like a permissions issue, however I wouldn’t want to give the web user access to see the sysprocesses personally. Aside from giving more permissions I don’t think there’s much you can do with SQL 2000 regarding that.
Derek
In order to shrink the Tempdev file by avoiding the restart of the production system we can adapt the below method ..but I am just keen how it will affect the performance of the over All Data Base System …
Will you please give the more detail on it..
DBCC FREESYSTEMCACHE (‘ALL’)
DBCC FREEPROCCACHE
USE [tempdb]
GO
DBCC SHRINKFILE (N’tempdev’ , 1000)
Thanks ..
Hello,
i was wondering if you provide any classes for teaching ?
Thanks
Alhanoof
Hi Alhanoof,
I currently don’t have a curriculum in place, however I can teach if there are any topics you would like to go over.
Thanks,
Derek