This article shows how to use ApexSQL Complete, a free intellisense add-in. You can download ApexSQL Complete, and play along through the article.
SQL SERVER – Beginning Contained Databases – Notes from the Field #037
[Note from Pinal]: This is a new episode of Notes from the Fields series. Login and Users are very confused concept. Just yesterday I wrote about a difference between Login and User. In Latest version of SQL Server now we can also have a User without Login. This concept is not…
Read MoreSQL SERVER – Difference Between SQL Login and SQL User – SQL in Sixty Seconds #070
“What is the difference between SQL Login and SQL User in SQL Server?”
SQL SERVER – SSMS: Memory Consumption Report
The next in line in this series of reports is the “ Memory Consumption ” Report from SQL Server Management Studio. This is a goldmine of a report in my humble opinion and lesser respected. When I used to be consulted or land into performance tuning exercises for customers in the past, there is one question that gets repeated and echoed every now and then – “My SQL Server is eating away my RAM and it is not releasing it back even in non-peak hours”.
SQL SERVER – SSMS: Scheduler Health Report
Have you ever been to a music concert? It is the most humbling experience one can get as a music lover. The live music with hundreds of musicians in one stage brings goosebumps with the very thought. I have always been fascinated and wanted to experience this once in a…
Read MoreDeveloper’s Life – Every Developer is a Harry Potter
Harry Potter might not be a superhero in the traditional sense, but I believe he still has a lot to teach us and show us about life as a developer. If you have been living under a rock for the last 17 years, you might not know that Harry Potter…
Read MoreMySQL – How INSERT() Function Works for MySQL
You know there is an INSERT statement which is used to add data to a table. But did you know that there is an INSERT function which will replace certain characters within a string? INSERT() function in MySQL is used to insert a substring at the specified position up to…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.