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

Here is a feature that I have been waiting for since I started working with SQL Server 6.5: the ability to script the data from a table. When you deploy a SQL Server database, you often need to ...

Les plans de maintenance pour SQL Server existent depuis SQL Server 2000, mais ils ont toujours fait l'objet de critiques partagées. Cela s'explique en partie par leur approche quelque peu lourde, ...

L’arrivée d’un nouveau système de gestion de bases de données chez Microsoft est toujours un événement majeur. Microsoft SQL Server 2019 ne constitue pas une exception. Cette mouture regorge de ...

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

If you are an old hand at Microsoft SQL Server, you have probably used the SQL Server Agent (i.e., SQL Agent) service and MSDB database for the last 20 years. With a humble and largely unchanged ...

Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...