Helping businesses improve reliability and efficiency of SQL Server
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But why keep this important visual warning at the bottom of the screen? In this post, I show how to move the SSMS status bar to the top and make the connected environment much harder to overlook.
In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion and recompiling sps and views
In SQL Server, there are various scenarios in which you may want to consider recompiling a query or a stored procedure to ensure optimal query performance. Recompilation generates a new query execution plan, and it can be necessary when the existing execution plan is no longer suitable.
Last week, in the post Common Mistakes in SQL Server - Part 4 I explained about the Auto Growth configuration in SQL Server and how it can adversely impact. This week, I am going to explain a very important thing that is often skipped. It is a common mistake that can indeed lead to performance problems. Implicit Conversion can cause unexpected performance issues and hinder query optimization. This week in Common Mistakes in SQL Server - Part 5 let's speak about the Implicit Conversion.
Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your attention to a database configuration that is often missed. If this value is not configured with care, it can cause I/O and CPU spike, and can also cause physical fragmentation.
Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part 2. This week in this article Common Mistakes in SQL Server - Part 3 I will discuss the Null Value and how it can cause an issue!!
The Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary key – an identifier column. This is the Common Mistakes in SQL Server Part 2
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is the Common Mistakes in SQL Server - Part 1.
In this article, I share a Microsoft SQL Server Security Checklist developed from my experience reviewing client environments, including organizations working toward PCI DSS compliance. Use it as a practical SQL Server security best-practices checklist to identify security gaps, reduce risk, and strengthen your database environment.
Security! This is the word that comes to mind of every concerned person when it comes to storing, accessing, and sharing the data and database or database server. In this article I share some of the pointers that can help you understand How to Secure SQL Server. At times when applications are run in geographically restricted areas, there is less chance of their exploitation. However, […]
I have seen this question many a time that people have asked “The Cloud or On-Premise – is it a go or no go?”. This is something that has been discussed and debated, in detail for a longer period of time. Let’s see what it is and if it is a go or no go? […]
This weekend I was working, as usual, holding the on-call and listening to my favorite singer Kishor Kumar. And, my friend Rakesh call me in jeopardy. One of his clients has reported that one of their Cluster Service failed to bring clustered role online or offline. And, that the cluster is failing back to the […]
