cDickey / FastSqlServer - SQL Server Consulting
Azure SQL Managed
Gary: "Chris, all I can say is WOW!!!! Customers I spoke with today are amazed how fast everything feels."
Full SQL Server on Azure - multiple databases - SQL Agent - Profiler
3 Enterprise Edition servers synchronized for data redundancy. Automatic backups.
You can use a secondary SQL Server for read only queries using its CPU and RAM.
Batch mode processing in SQL 2019 can be a big win!
Memory-optimized tempdb metadata reduces PAGELATCH_UP waits
Scalar value functions are in-lined in SQL 2019.
Take advantage of live query plans using lightweight execution statistics profiling.
Contact me. Use advanced performance features in SQL Server 2019. Deploy SQL Server to Azure
Tony: "The speed and performance increases are literally jaw-dropping..."
Andrew: "Our SQL looks awesome now, the CPU utilization... It's down to 20% now..."
Chris: "Awesome. You saved us thousands of dollars and a lot of man hours."
Andy: "Honestly, I've never seen the site run this fast...absolutely amazing. My team is amazed."
Thomas: "Thank you so much for helping us and guiding us so our SQLserver spins like a Formula one racing car."
Who are my clients?
Email SQL Server Consulting to boost the expertise of your technical staff
Advanced tuning and development capabilities for Microsoft SQL Server and .NET
Is a fast system important to your business? Invest in expert consulting to get the job done right.
Are you still running SQL Server 2008, 2012 or 2014? Upgrade to SQL Server 2019 combined with a pro tuneup.
Why SQL query optimization is hard - David DeWitt, Microsoft Jim Gray Systems Lab
- SQL Server Performance Expert - FastSqlServer.com
- SQL Server 2019 or 2017 for Speed - Get the Benefits of New Features
- SQL Server .NET CLR Components - C# - Regular Expressions, Compression
- C# 8 Async + .NET + SQL Server - Concurrent Processing, Reliable Transactions
- ASP.NET MVC + HTML5 - High Performance and Secure Web Applications
- .NET Core + Angular - The latest improvements in Web Applications
Chris Dickey consulting has helped clients across the USA
Tell the Story of Success
"When I think SQL performance problems, I think Chris Dickey."
"Thanks for the amazing job. The speed and performance increases are literally jaw-dropping..."
"I think we may have to hang your picture here. They are telling me you worked a miracle.
Everything is incredible! I really appreciate your help."
"Awesome. Thanks for the quick fix on that. You saved us thousands of dollars and a lot of man hours. We were going to dump that system for something else."
"After months of struggling with our interface DB performance and having regular deadlocks, Chris Dickey came in and within 3 days improved our performance by 200%. After spending less than 60 hours on our environment our total improvement was well beyond 400% and we experienced no more deadlocks. Needless to say we have forwarded Chris' contact information to companies that we knew had similar challenges."
"Fixed, ran ninjaly faster."
"Yes we moved to sql 2005 and the speed is absolutely incredible. All loans all day long price under 30 seconds. Some scenarios are under 10 seconds. We have customers specifically calling or emailing to say whatever we did to keep it up, the speed is unbelievable."
"The improvement you made for that process was so drastic that when someone was out sick and they had less man power to do the time cards they still finished early."
"Here's what our Vice President had to say: I can't tell you how pleased I am that the database issues that have been plaguing us are finally getting tamed!"
I make SQL Server rock!
>> >>> >>>>
22 years of SQL Server Consulting experience enable me to eliminate tough performance problems fast.
Quick performance improvements will improve your business.
Go fast in days, not months. Give me a phone call to discuss how I can speed up SQL Server for you.
San Diego, California
I have assisted clients across the USA
30 years working with SQL Server since 1989 release
I have a SQL Server 1.0 install 5 1/4 floppy disk!
22 year focus on SQL Server performance consulting
30 years of software experience: C++, C#, T-SQL, ASP.NET
University of California San Diego
Professional Association for SQL Server
Beautiful Wonderful Jeannette Irene Le-Saint
FastSqlServer / TuneSqlServer consulting clients
- back to top
How To Get a Secure, Reliable and Great Performing Business System
Increase your company's bottom line with fast and reliable access to secure information.
Make better informed decisions on time. Satisfy the information needs of your customers and employees. Reduce IT headaches and overhead! Earn higher profits running your business on Microsoft .NET applications hosted on Windows Server 2019 and SQL Server 2019.
The combination of Microsoft Windows Server 2019, SQL Server 2019 and the .NET Framework provides the secure, powerful platform and tools that you need to succeed. cDickey.net consulting has the professional skills needed to implement a great system on that foundation. Chris Dickey started development using ASP.NET, VB.NET, C# and ADO.NET in July of 2000 after training at the Microsoft Professional Developers Conference. He also started using ASP when it was first previewed years earlier. I have more than 20 years of proven experience using Microsoft server technologies (Lan Manager, Windows NT, Windows Server 2003, Windows Server 2019, SQL Server 4.x/6.x/7.0/2000/2005/2008/2012/2014/2016/2017/2019, IIS). Chris Dickey also has a 25 year history writing software which includes using C, C++, C#, Basic, VB, Win32 API and T-SQL. Proven software development includes ASP and ASP.NET web sites and scalable transaction processing components interacting with SQL Server 2017. I also have experience upgrading Microsoft Access systems to SQL Server, ASP.NET and SQL Server Reporting Services.
Effective software needs to solve business problems not just be a techie expedition. Yes, we are techie experts in the IT building blocks: SQL Server 2019, Windows Server 2019, IIS, TCP/IP networking, .NET Cor and Framework, json Web Services, C#, ADO.NET and ASP.NET. But, we combine that advanced technical know-how with years of proven business experience to architect the secure and reliable system that will satisfiy your business requirements.
cDickey.net Consulting Provides Advanced .NET Expertise You Need to Succeed
- Microsoft SQL Server performance tuning, application design, T-SQL development
- Web site performance tuning - IIS, ASP.NET, SQL Server
- json Web Services - .NET core development, deployment on IIS
- Client/Server software development - .NET core, VB.NET, C#, ADO.NET, VC++, Win32 API
- Upgrade ASP web sites to ASP.NET MVC - VB.NET and C# coding
- SQL Server Replication - dynamic partitioned Merge, Transactional
- Upgrade Microsoft Access MDB files to SQL Server
- Convert Access Forms to ASP.NET apps
Reliable high performance web sites using The Right Stuff: SQL Server 2017 + Microsoft ASP.NET
Practical experience has delivered successful systems for my clients. Microsoft SQL Server, Windows Server
and IIS (Internet Information Services) provide the strong foundation. Designing for performance and tuning database systems and
web sites using correct techniques makes for success. I have solved SQL Server and web site performance problems for many clients in as little as 20-40 hours. I have built replicated SQL Server systems with up to 18 servers distributing data through WAN links connecting sites in cities across the United States.
is a graduate of the University of
California, San Diego
in Management Science
and Systems Engineering
Performance, Reliability and Security you need to succeed!
Books - some old ones - history
This web site developed and hosted by cdickey.net consulting
San Diego Sql Server