I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there ...

With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its vision of SQL Server as an information platform and not “just” a database.

SQL Server 2008 offers two options for collecting change tracking information within the database engine, using built-in features that offer reliability and performance advantages over tracking tables ...

Database Mail, a new addition to the SQL Server 2005 database engine, is as simple to use as it is useful. Destined to be the replacement for SQL Mail, Database Mail uses a Simple Mail Transfer ...

Microsoft's database releases from 2008 and 2010 reach end of extended support. In response, Redmond says, that for many customers, the time for cloud migration has arrived.

Using Extended Events Extended Events is a tracing feature built into the SQL Server database engine, starting with SQL Server 2008.

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

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...

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.