SQL Server Management Studio (SSMS ... Most people know that by highlighting an object (eg an SQL Agent job) and right-clicking, an option presents itself to generate a script of the said job.

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new ...

A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases. A fundamental skill for DBAs is to ...

database security and SQL Server job scheduling. Changes were also made to the suite’s RecoveryManager application, which features speed and reliability tweaks. SQL Server Management Suite 2.0 ...

In this two-part series, I'll tell you about some improvements Microsoft is making in SQL Server 2022 to improve cardinality estimates and deal with another common query optimization concern ...