How to repair corrupted WMI Repository?
Windows Management Instrumentation (WMI) is the infrastructure for management data and operations on Windows-based operating systems. WMI is the Microsoft
Read moreLearnSQL
How to find the Isolation level being used by a Database?
Hi Friends, Recently i was preparing a Dashboard sheet for one of our critical Box. The Client was having a
Read moreCompare Data in Two SQLServer Tables without Any 3rd-Party Tool
For comparing data in tables you don’t need any 3rd party tool, SQL Server ships with the tablediff utility which
Read moreWhat all changes require a restart of SQL Service?
Question of the day: What all changes require a restart of SQL Service? Let’s say you get a request to
Read moreAuto-Truncate Log in Full Recovery Model
FULL Recovery model: This means that all database changes are fully logged and ideally the log records should stay in
Read moreSQL Server Password Audit for SQL Server Logins
SQL Server Password audit is a must for all SQL Servers. Weak or Blank passwords are invitation to trouble and
Read moreBuilt in Functions in SQL Server 2012
Microsoft SQL Server 2012 introduced 14 new built in functions. These new functions are: Conversion functions PARSE TRY_CONVERT TRY_PARSE Date
Read moreWhy the size of the backup file changes?
Hi Friends, Have you ever noticed, while taking a compressed backup the file which gets created initially has a different
Read moreUnable to open Maintenance Plans in SSMS
Hi Friends, A few days back, I got a backup failure alert regarding one of our most critical SQL Instance.
Read moreMemory Configuration Changes | SQL Server 2012
Hi Friends, There are a few changes in SQL Server 2012 in Memory Manger, and a DBA should be aware
Read more