Many developers become sluggish when it comes to learning TSQL stored procedures and deal with functions and triggers. As we, all know the famous saying “If necessity is the mother of invention, then laziness is sometimes its father” then welcome the tricky way of doing what you want in SQL without writing complex TSQL syntax.... Continue Reading →
SQL Server: Cleaning all Database Tables and Reset Identity Columns by forcing Truncate or Delete
We all know that during the development process of any software or web application connected to an SQL Server database, all the tables contain what we call 'trash' data which is non useful data entered by developers for testing their code. This data should be removed before the delivery of the application to the client,... Continue Reading →
SQL Server Configuration Manager – Cannot connect to WMI provider
I was trying to access my SQL Server 2008 R2 Network Configuration to enable Tcp/Ip connections to my server through the SQL Server Configuration Manager from the Configuration Tools. But suddenly an error message appeared indicating that I can't access my configuration manager through the WMI provider. The error message that popped up is shown... Continue Reading →