As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

To SQL or NoSQL? That’s the database question But as technological lines blur, there's not always a clear-cut answer.

Microsoft announced several improvements to Microsoft Azure of interest to developers: Azure SQL Database auditing improvements, support extension, and a cloud-based PowerShell. Among the auditing ...

In SQL Server Management Studio (SSMS), you can see the SQL Server database state. Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function ...