Author

ScreenConnect.com Remote Computer Connect Application

This website allows other people to control your PC Software from this website gives other people access to your PC – scammers might use it to secretly gain access to your personal info. If you’re asked to download software or give out your personal info, be sure it’s by someone you trust. Company Website https://www.connectwise.com/software/control... » read more

SQL Server Job Overlap

The SQL Server agent checks whether the job is already running before starting a new iteration. If you have long running job and its schedule comes up, it would be skipped until the next interval.

Transaction Log for TempDB is Full

Issue: The transaction log for database ‘tempdb’ is full due to ‘ACTIVE_TRANSACTION’ Fix: Restart server to clear up tempdb. Tempdb database is part of SQL Server System database and gets created every time SQL Server Service starts. Tempdb stores temporary operations (like sorting and grouping data output etc) and tables, it stores lots of  information in... » read more

Log Shipping vs Always On

AlwaysOn high availability group, HAG, is easier to maintain than log shipping. An AlwaysOn HAG gives you the flexibility of being able to fail over back and forth between your AlwaysOn replicas. Now lets take a look at Log Shipping. Without doing a cut and paste from the Microsoft books online there are five steps... » read more

Account Log On Permission

Log on as a batch job This policy setting determines which accounts can log on by using a batch-queue tool such as the Task Scheduler service. When you use the Add Scheduled Task Wizard to schedule a task to run under a particular user name and password, that user is automatically assigned the Log on... » read more

Break Up Large File by Creating Smaller Multiple Files with 7-Zip

You can use 7-Zip to create smaller multiple files. This is useful when you want to transfer large files and your VPN file transfer is very slow. You can specific how big to set each file. xxxxxx.7z.001xxxxxx.7z.002xxxxxx.7z.003 Select “Split to volumes, bytes” section option to split up the file to smaller files. Entering 20M for... » read more

Always On and SQL Service Account

Account Setup: Use the same account to run all SQL Server service for all node in the cluster. Account has Administrator permissions on all servers in node. Set in “Local Users and Groups”. Account has sysadmin SQL permission on all servers in node. Set in “Local Security Policy”. Account has log on as service policy... » read more

SQL Server Service Account

AlwaysOn Cluster Setup: Use the same account to run all SQL Server service for all node in the cluster. Account has Administrator permissions on all servers in node. Account has sysadmin SQL permission on all servers in node. Account has log on as service policy on all servers in node. Note: Always use SQL Server... » read more