A few weeks back, XAML Guy posted the December TechNet Guru awards:
TechNet Guru Awards - December 2013
To give you a taste, here are the results of the technologies in my product areas (SQL Server, Power BI, and Small Basic)...
Also worth a mention were the other entries this month:
Ed Price: "A good solution and some great suggestions from Shanky in the comments! Examples would help." NN: "Another great article by Praveen which contains many methods to check Server and Windows Restart time." Samuel Lester: "Knowing when SQL Server restarted is nice, but knowing why it restarted is often the more important issue. The methods you highlight are creative and allow you to quickly find the first answer, but aside from determining if it was restarted due to an OS reboot, it would be nice to dig more into the topic of why. Great content on what could turn into a spectacular topic and set of troubleshooting steps." DRC: "• It mentioned about finding the "reason" for the SQL Server and windows restarts at the beginning but the details are missing in the article. . The query "SELECT create_date FROM sys.databases WHERE name = 'tempdb'" will not work if traceflag 3609 is ON which doesn’t create a new tempdb file during sql server startup. For windows: Method 1: Start Task Manager->Performance Method 1 shows only the uptime but doesn’t show the actual time of restart. If the server has been up for a long time, then the calculation is very difficult Method 2: This method helps you to figure out root cause for the restart. start -> run -> eventvwr The 2nd method will not help if event viewer logs are clreared. • We have a better method to find the system startup time where we don’t depend on any other logs or tools. C:\> systeminfo | find /i "Boot Time" "
And keep your eyes on the January results as January comes to a close:
TechNet Guru Contributions for January 2014
Here are the current entries for the technologies that I work on...
Current contributions for January:
Special thanks to XAML guy for hosting this contest!
• TechNet Guru Contributions • List of Award Winning TechNet Guru Articles
Hope you're having a great week!
- Ninja Ed