-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Geek

Dharmendra is a SQL Server/Microsoft Data Platform professional with over eight years of experience. He enjoys helping others in the SQL Server community and does this by contributing on blogs, speaking at several SQL events. His passion and focus is to explore and share more and more on SQL Server.

Archives: January 2017

SQL Server Service Information

DMV: sys.dm_server_services

Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them is “sys.dm_server_services” which  return a whole host of important information relating to the SQL Server services that includs;

  • Service Name
  • Startup Type
  • Startup_Type_Desc
  • Status
  • Status_Desc
  • Process_id
  • Last Startup Time

Read more

0 comments, 106 reads

Posted in SQL Geek on 11 January 2017

Disk Space Monitoring using SQL Server DMV

DMV : sys.dm_os_volume_stats

Being a SQL Server database administrator, you may often receive alerts or asked by Senior DBAs to check, if the disk space is running out of space on SQL Server.

Before SQL Server 2008 R2 SP1, the best way to check on available disk space from within… Read more

4 comments, 311 reads

Posted in SQL Geek on 9 January 2017

New String Function – TRIM – in SQL Server vNext

As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at the beginning and the end of the string. To achieve that, you may have used the string functions RTRIM and LTRIM. You may wish to have the TRIM function… Read more

0 comments, 227 reads

Posted in SQL Geek on 6 January 2017

When was SQL Server installed?

In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve the SQL Server Installation date, we have to check the login “NT Authority\System” creation date which gets created at the time of SQL Server installation. You can check… Read more

0 comments, 68 reads

Posted in SQL Geek on 4 January 2017

Identifying Blocking Chain in SQL Server

HAPPY NEW YEAR 2017!!

I hope you all had a good Christmas and New Year. I always try to review my skills as a DBA and explore different option to make my job easier. Recently, I was working on the blocking issue of SQL Server and found that there were… Read more

2 comments, 246 reads

Posted in SQL Geek on 1 January 2017