While DMVs are some of the most powerful features of Microsoft SQL Server, they are still under-utilized due to the lack of awareness around them. Nevertheless, each release of Microsoft SQL Server comes with a new set of DMVs being introduced & existin...

In 1993, E.F. Codd, the acknowledged founder of relational databases, introduced the term Online Analytical Processing (OLAP). OLAP is intended for the non-data processing professionals like the business expert, and is expected to be intuitive, rapid, a...

...

HI All, Thought of starting sql server-2012 Tutorial. Feedback are most welcome....

SQL Server Error log is the best option for a DBA to identify any current or potential issues with SQL Server databases. These error log files contain a broad range of error messages that provide valuable information with respect to automatic recovery, ...

...

...

...

...

...