I want to enable notifications for SQL Agent for my backup jobs.I configured database mail and that works, it sent me a test message.However, when I go to tell the SQL Agent to use it, it sees ...

By using a single tool like PowerShell, you can access your data wherever it is stored. It does not matter if it is in the cloud in an Azure SQL database or in an on-premises MS-SQL server, MySQL or ...

Anyone out there have experience dealing with this?I'm having problems getting the SQL Mail component to work.Here's the setup:SQL Server 2000 running on Windows 2000 Server.SQL Server and the SQL ...

Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA.

However, SQL Server data files (MDF and NDF) can get inaccessible due to a variety of reasons and paralyze all business operations. What can be done, if there is no backup of the corrupt database ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...