When performing backup with scripts its not easily possible to get the percentage complete of the running backup. This simple script will show status of […]
How to get list of new or modified database objects?
This simple query tells us if there were any database objects created within the last 24 hours. You can modify the DATEADD parameters to get […]
Top SSIS Sites
https://www.mssqltips.com/sql-server-tip-category/17/integration-services-development/ Will populate more later.
Download SSMS and SSDT
Link to the latest version of SQL Server Management Studio download (SSMS) Link to the latest version of SQL Server Data Tools (SSDT) for Visual […]
How to setup Database Log Shipping?
The goal of this setup is the following. We have data being collected with many users hitting the database during production hours and we want […]
How to get total row count of all database tables?
This script will create a temp table and store the name of the database table and total row counts for each table in the database. […]
Connecting TFS to any version of Visual Studio
http://blog.jessehouwing.nl/2013/10/connecting-to-tfs-from-any-version-of.html#tfs2013 Will add more details.
How to install Active Directory Snap in for Windows 10
Download and install Active Directory Users and Computers snap-in: Visit the Remote Server Administration Tools for Windows 10 page Select Download, select the correct operating […]
SSRS Report Run History
The following query shows report history for a report name (Employee Attendance Report) in the WHERE clause. This is a great way to check what […]
How to reboot a remote computer or server?
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 […]