It is possible to use the SQL Server Agent to execute PowerShell scripts. If you've worked with the SQL Server Agent to run jobs on your server, you already know that whenever you define a job step, ...

The CDW allows you to copy a database from one SQL Server to another along with associated Logins. It generates a Job that executes an SSIS package that, by default, uses the SQL Server Agent Service ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

The RDBMS formerly known as SQL Server vNext is now out as SQL Server 2017 Community Technology Preview 2.0. The RDBMS formerly known as SQL Server vNext is now out as SQL Server 2017 Community ...

Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to ...

SQL, or the structured query language, is a specialized programming language designed for working with databases. There are a few different variations of SQL from different organizations and projects, ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...

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 ...

Over the years, servers have suffered terribly from malicious attacks that users had to take precautions now and then. Because of that, internet users need to determine how to repair a database in an ...

The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...