During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

This project is a classic 3-Tier Windows Forms Application in C# that implements basic CRUD operations (Create, Read, Update, Delete) for managing user records. It's a structured, maintainable ...

So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...

How do I assign permissions to users to see SQL Agent Jobs? Your email has been sent You can give your users rights to check if reports have run or jobs are complete without granting full admin rights ...

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.