Question: What is the Default Datatype of NULL?
SQL SERVER – Missing Columns and Other Folders in SQL Server Management Studio (SSMS) in Object Explorer
On Random basis, I do get some emails and comments on my blog which makes me do some research and write more blogs to share my thoughts and findings. This blog is an outcome of one such email communication with a user. Let us learn about missing columns in SSMS.
SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet
There are many rules in SQL Server setup which are checked to make sure that the user is not seeing failure at the end of the installation. Most of the rules are generally passed, but few of them are known to generate warnings. One of such rule is Microsoft .NET Application Security which can be seen below.
Heimdall Data Auto-Caching for SQL Server – No Changes to Application
I found a unique caching solution that accelerates SQL Server. Heimdall Data auto-caches and auto-invalidates, removing complex configuration. It requires zero changes to your application and database. Try out the best possible solution for auto-caching.
SQL SERVER – Unable to Start SQL When Service Account is Removed From Local Administrators Group. Why?
One of my clients wanted to secure their SQL Server. One of the rules was that wanted to avoid running SQL Server service with an account which is part of local “Administrators” group. They wanted to provide the minimal permissions needed for the SQL server service account for SQL Server to function.
SQL SERVER – How to Pass Parameters to the Stored Procedure?
After so many years of existence of the stored procedures, I still see developers struggling to execute the stored procedure. Every other day I receive a question in an email asking how to pass parameters to the stored procedure.
SQL SERVER – Running CHECKDB with Minimum Repair Level
“How do I run CHECKDB with Minimum Repair Level?”
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.