Database Administration Robert Sheldon in Database Administration Storage 101: Welcome to the Wonderful World of Storage Understanding all the storage options available today is not easy. In this new series, Robert Sheldon will explain what you... 03 December 2019 13 min read
Database Administration Forrest McDaniel in Database Administration How Does Accelerated Database Recovery Work? Accelerated Database Recovery is new with SQL Server 2019 and Azure SQL Database and used to decrease the time for... 26 November 2019 12 min read
Editorials Kendra Little in Editorials SQL Server Management Studio is as Relevant as Ever After fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management... 24 September 2019 3 min read
Database Administration Joshua Feierman in Database Administration How to Use SQL Audit and Azure Log Analytics to Comply with Audit Rules You can use SQL Audit to record changes to security, access to tables, and more to help you meet compliance... 09 September 2019 16 min read
Database Administration K. Brian Kelley in Database Administration The End of SQL Server 2008 and 2008 R2 Extended Support Many organisations still run their companies on SQL Server 2008 or 2008 R2. There are many reasons to upgrade, but... 21 June 2019 26 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration Navigate Linux for SQL Server DBAs Kellyn Pot’Vin-Gorman shows how to navigate Linux for SQL Server DBAs, using aliases, setting up environment variables, and examining processes.… 17 June 2019 18 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 6 SQL Server has many tools used to make it secure. In this article, Robert Sheldon demonstrates several of these features... 29 May 2019 15 min read
Database Administration Greg Larsen in Database Administration Resumable Online Index Create and Rebuild Operations Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this... 05 March 2019 14 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 3 SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the... 25 February 2019 14 min read
PowerShell Greg Moore in PowerShell Using a Server List to Control PowerShell Scripts PowerShell is the preferred tool for many DBAs when automating SQL Server administration. In this article, Greg Moore demonstrates how... 29 January 2019 13 min read
Database Administration Greg Larsen in Database Administration Protecting SQL Server Data Using Static Data Masking In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and... 07 January 2019 19 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 1 Security is often considered the most important of a database administrator's responsibilities. SQL Server has many powerful features for security... 31 December 2018 14 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration How to Linux for SQL Server DBAs — Part 3 DBAs running SQL Server on Linux will not only need to understand SQL Server security well, they will also need... 07 December 2018 14 min read
Database Administration Laerte Junior in Database Administration What Is SQLPSX? SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior... 29 October 2018 12 min read
Database Administration Robert Sheldon in Database Administration Adaptive Query Processing in SQL Server 2017 As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new... 01 October 2018 17 min read
Database Administration Phil Factor in Database Administration Extended Events Workbench The Extended Events (or XEvents) feature has been part of SQL Server since 2008, but many database professionals struggle to... 27 September 2018 34 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration How to Linux for SQL Server DBAs — Part 2 SQL Server DBAs are typically quite familiar with security and best practices in Windows but may not understand how security... 26 September 2018 17 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration How to Linux for SQL Server DBAs — Part 1 As running SQL Server on Linux becomes more common, DBAs must learn and become comfortable with the Linux OS. In... 29 August 2018 11 min read
Database Administration Kathi Kellenberger in Database Administration Questions About Kerberos and SQL Server That You Were Too Shy to Ask Kerberos authentication is a topic that many database administrators avoid. It’s really not that difficult to understand, but it’s also... 21 August 2018 12 min read
PowerShell Greg Moore in PowerShell Introduction to PowerShell with SQL Server Using Invoke-SQLCMD PowerShell is the preferred scripting tool used by Windows and Active Directory administrators. It can also be used to administer... 08 August 2018 10 min read
