This is a fun thought exercise…. in MS SQL Server, use a linked server to compare how many rows are in each table of a backup development server with how many rows are in the actual production server. This would be especially relevant if you just did a database backup from prod into development and now want to see a few hours later on what tables the most growth is happening on…Continue reading “TSQL Query to Compare Row Counts of Tables in a Local and a Remote Database”
Author: Justin Cooney
I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.
TSQL How to Query the Recovery Model and Log Location of all Databases
If you are maintaining the databases on a server, you’ll likely want a comprehensive view of what each database’s recovery model is as well as where the database and log files are stored. An added bonus is seeing how large each file has grown so you can shrink them if necessary. You can see this all in one place using a handy query…Continue reading “TSQL How to Query the Recovery Model and Log Location of all Databases”
Temporarily Bypassing the GPO: Access to TEMP has been restricted by your Administrator
It can happen that when you are trying to install new software on your device, the installation gets only so far and then mysteriously vanishes without completing the installation. This can happen for various reasons, but in this example, we’ll handle the cause as a policy set by system administrators to protect users from malware trying to exploit their system.Continue reading “Temporarily Bypassing the GPO: Access to TEMP has been restricted by your Administrator”