An open source project gives DBAs the ability to channel PowerShell for automating and scaling complex SQL Server tasks, starting with the most basic: database backups.
- By Joey D'Antoni
- 05/13/2020
There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ways to make life easier.
- By Joey D'Antoni
- 02/10/2020
Ransomware affects databases in very specific ways. Joey describes the mechanics of a SQL Server ransomware attack, what DBAs can do to protect their systems, and what security measures they should be advocating for.
- By Joey D'Antoni
- 01/21/2020
Microsoft has clarified the more confusing elements of SQL Server licensing and extended major benefits to customers. The catch is that Software Assurance is required to take advantage of them.
- By Joey D'Antoni
- 11/08/2019
From Big Data clusters to faster database recovery, here are the biggest changes Microsoft has made to its new flagship database server.
- By Joey D'Antoni
- 11/04/2019
Microsoft's portfolio of PaaS databases has grown way beyond Azure SQL. Here are its most important cloud-based database services, and exactly how each one works differently from the other.
- By Joey D'Antoni
- 09/16/2019
It's not 2008 anymore. Joey details the ins and outs of upgrading these aging Microsoft servers, including licensing changes, support options and potential pitfalls.
- By Joey D'Antoni
- 08/07/2019
Microsoft broke new ground in scalability when it launched Azure SQL Database Hyperscale. Here's what it took to make Microsoft's hyperscale vision work with the existing Azure infrastructure.
- By Joey D'Antoni
- 07/03/2019
Microsoft's ongoing investments in SQL Server are bearing fruit. Here's a rundown of the biggest announcements for database professionals from this year's conference.
- By Joey D'Antoni
- 05/06/2019
It's not enough to have a backup and recovery plan. Today's IT pros need to practice salesmanship and PR savvy to get through a disaster.
- By Joey D'Antoni
- 04/03/2019
Microsoft's drive to put Azure SQL Data Warehouse on more equal footing with SQL Server is finally paying off.
- By Joey D'Antoni
- 03/07/2019
IT is moving toward the cloud and virtualization, but don't write off hardware -- especially for highly critical systems. Here's a look at the newest generation of database hardware and how it impacts performance.
- By Joey D'Antoni
- 02/05/2019