Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...
This month’s collection of fixes from Microsoft includes 86 patches — but at least there were no zero-day bugs. Microsoft released 86 patches this week with updates for Office, Windows, and SQL Server ...
Database administrator with 14+ years of hands-on experience in database management and database design. After spending 15 years as a SQL Server DBA, I've witnessed numerous technological evolutions, ...
Microsoft Azure and Google Cloud offer a wide range of cloud computing services, but Azure is more enterprise-focused, while Google Cloud has a stronger focus on AI and machine learning. We may earn ...
Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced adding WITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup ...
Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...
A complete history of all [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] backup and restore operations on a server instance is stored in the **msdb ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results