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

From immutable ledgers in SQL Azure to in-memory cache in Cosmos DB, Microsoft is adding more features to its Azure data platform. Topics Spotlight: New Thinking about Cloud Computing ...

Microsoft's SQL Server toolbox is a complicated ecosystem, and differentiating one tool from another is a challenge. Vicky Harp, lead program manager of the SQL Server tools team, clarifies ...

Using a connection to Azure Arc, which is part of the SQL Server 2022 setup process, on-premises users can now also opt for cloud-enabled billing to manage consumption spikes or for ad hoc use cases.

Microsoft treats Arc’s database tools as two different options, separating the Arc-managed and locally hosted Azure data services from SQL Server.

Working with SQL Server Data Tools. Lenni Lobel, chief technology officer of Sleek Technologies and author of Programming Microsoft SQL Server 2012 (Microsoft Press), offered a walk through of the SQL ...

Using the Copy-DBAAgentServer command, you can bring over everything in the SQL Server Agent, including jobs, notifications, operators and alerts. Log-ins work in the same easy manner.

SQL Server Agent is a popular tool from Microsoft for scheduling programs to run on Microsoft's SQL Server database platform. A task is known as a "job," and it can be put on what is called a ...

SQL Server Data Tools: A Work in Progress. I've been playing around with the new SQL Server Data Tools, and although many have complained about missing features compared to the "Data Dude" Visual ...

SQL Advisor. SQL Server Data Tools: A Work in Progress. I've been playing with the new SQL Server Data Tools, and I'm impressed by the way Microsoft has gotten the product out for review and is ...