SQL Server: Script to find Installation Date, time and Authentication Mode

In this post, I am sharing a TSQL script to find the installation date, time and authentication mode of SQL Server. The DBA can use below script to find the detail on server properties for different SQL Servers. You can also use this to prepare a report for different SQL Servers and can compare the […]

March 22, 2016 SQL Server, SQL Server DBA Script

March 21, 2016

SQL Server: Script to find Heap Table without having an Index

March 20, 2016

MySQL: Search String using Regular Expressions (REGEXP)

March 19, 2016

PostgreSQL: Update the Table data using Subquery

March 18, 2016

SQL Server: Script to find the status of Trace is running or not

March 17, 2016

SQL Server: Truth about assigning variables using SET versus SELECT

March 16, 2016

SQL Server: Script to change the Recovery Model of a Database

March 15, 2016

SQL Server: Script to find Index Average Fragmentation in Percentage

March 14, 2016

SQL Server: Script to make Database Read Only and Read Write

March 13, 2016

NoSQL: Data Model, What is the Graph Based Store Database (Day 7)

Older posts Newer posts

About Me!