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
Containers and Virtualization Laerte Junior in Containers and Virtualization Provisioning SQL Server Instances with Docker With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior... 16 April 2018 12 min read
Darko Martinović Programming SQL Server with SQL Server Management Objects Framework SQL Server Management Objects (SMO) is a great tool for managing SQL Server. Darko Martinovic demonstrates how to use SMO... 09 April 2018 26 min read
Database Administration Seth Delconte in Database Administration Recover Data in SQL Server AWS RDS with the Help of BACPAC With Amazon RDS, it’s easy to have a SQL Server running in minutes. There are some limitations, though. Seth Delconte... 22 March 2018 15 min read
Database Administration Prashanth Jayaram in Database Administration Mount SQL Server DMVs and Custom Queries Using DBFS on Linux With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux,... 20 March 2018 14 min read
