I have seen scores of expert developers getting perplexed with SQL Server in finding time only from datetime datatype. Let us have a quick glance look at the solution. Let us learn about how to get Time in Hour:Minute Format from a Datetime as well as to get Date Part Only from Datetime.
SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server
When I am not blogging, I am typically working on SQL Server Optimization projects. Time and again, I only have access to SQL Server Management Studio that I can remotely connect to server but do not have access to Operating System, and it works just fine. At one point in…
Read MoreSQL SERVER – Forgot the Password of Username SA
I just received a call from an old friend with whom I used to work in Las Vegas. He told me about a password-related issue he faced in his organization. They had changed the password of username SA and now they are not able to recall the new password. I…
Read More
SQLAuthority News – Author Visit – Virtual Tech Days August 2009
Microsoft India has organized a premier online technical event Microsoft Virtual TechDays between August 19-21, 2009. I had presented two technical sessions and they were greatly received by audience. I had received 50+ request for providing PPT for all the attendees. It was great FREE event and I suggest that…
Read MoreSQL SERVER – Introduction to SQL Server 2008 Profiler – Complete
Introduction SQL Server Profiler is a powerful tool that is available with SQL Server since a long time; however, it has mostly been underutilized by DBAs. SQL Server Profiler can perform various significant functions such as tracing what is running under the SQL Server Engine’s hood, and finding out how…
Read MoreSQLAuthority News – Proposed eGov Standards Policy – Benefit for All or Only A Chosen Few
Does the proposed eGov Standards Policy benefit all or only a chosen few? As a wider audience comes to accept new technology, so the technology itself grows. The recent debate in India on the eGov Standards policy has been a point of contention for some time. I would like to…
Read MoreSQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
Note : Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The…
Read More