To restart or shut down a remote computer: Click Start, then All Programs, then click Accessories, and click Command Prompt. Else just search for cmd […]
How to manage your your career and finances for retirement?
This article is simple and I have added my own experiences to help guide your retirement goals. Everyone is different so take what tips may […]
How to get server disk space on SQL
Run the following extended stored procedure and you will get the disk space in MBs on each drive on your server. EXEC MASTER..xp_fixeddrives​
How to fix DBCC errors?
How to repair your database when you get DBCC errors. Put the database in single user mode. ALTER DATABASE YourDBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE; […]
Missing SSIS Toolbox
In multiple different versions of Visual Studio (2010-2017) the toolbox tend to disappear in designer mode when working on SSIS packages. Select “SSIS” then “SSIS […]
How to get PC service tag and model information?
How to get service tag information. 1. Type wmic under start menu and hit enter. 2. It will open a cmd command and there type […]
Rename Database By closing connections
When trying to rename database with open database connections its always a pain as the admin has to kill those connections. Instead of going that […]
How to restore a deleted report on reporting services?
First get the copy of the ReportServer database backup and restore it. Use the following step to restore. In SSMS right click the database folder […]
How to read registry entries for SQL?
Following query shows all the registry values on the server. select[registry_key],[value_name],[value_data]from [sys].[dm_server_registry]
How to get SQL Service details?
Run the following query under context of any system or user database to get the sql server database engine account and the account for sql […]