Security Priyanka Chouhan in Security SQL Server vulnerabilities and assessment SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article, Priyanka Chouhan describes how to... 21 April 2022 11 min read
Database DevOps Phil Factor in Database DevOps But the Database Worked in Development! Preventing Broken Constraints Database table constraints such as foreign keys and default values ensure reliability of the data. In this article, Phil Factor demonstrates a way to find... 08 January 2020 19 min read
Editorials Kathi Kellenberger in Editorials Why the Database Must be Part of DevOps According to Microsoft, DevOps is “the union of people, process, and products to enable continuous delivery of value to our end users.” The definition doesn’t... 01 January 2020 3 min read
Data Privacy and Protection David Poole in Data Privacy and Protection Database Security, People and Processes Protecting data is not easy, but it is critical. In this article, David Poole discusses database security and the behaviors needed to build secure systems.… 20 December 2019 17 min read
Database DevOps Rahul Varshneya in Database DevOps Establishing a DevOps Organization In this article, Rahul Varshneya explains some of the benefits and reviews the stages of establishing a DevOps organization.… 08 October 2019 7 min read
Editorials Kathi Kellenberger in Editorials The Data-Philes Team Meet the Time Traveler The year is 1999, somewhere in Cambridge, UK. Kathi, a member of the Data-Philes team, is reading a memo sent from her manager. The memo... 11 September 2019 4 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection DevOps security privacy and compliance Robert Sheldon continues his DevOps series with a look at DevOps security, privacy, and compliance. … 10 September 2019 11 min read
Editorials Kathi Kellenberger in Editorials Hiding What You Shouldn’t See Back when I was working on a master’s degree, one of our professors told us a story about a colleague who learned how to navigate... 12 August 2019 3 min read
Software Delivery Robert Sheldon in Software Delivery DevOps application delivery pipeline Robert Sheldon explains the DevOps Application Delivery Pipeline and some of the terms such as Continuous Integration and Continuous Delivery. … 15 July 2019 12 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 the most pressing reason is... 21 June 2019 26 min read
Editorials Kathi Kellenberger in Editorials Why DBAs Must Embrace DevOps A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement in either situation is bad.... 09 May 2019 3 min read
Security Robert Sheldon in Security Introduction to SQL Server Security — Part 5 SQL Server contains many built-in views and functions that can be used to understand what is going on “under the hood,” and security is no... 23 April 2019 21 min read
Editorials Kathi Kellenberger in Editorials Scary Stories from the Trenches If you have worked with databases long enough, you probably have many frightening stories to tell about things that have gone awry on the job... 03 April 2019 3 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 4 The sa account is the most powerful account in a SQL Server instance, and most DBAs disable it. There are several other built-in accounts that... 26 March 2019 19 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 database. This makes the database... 25 February 2019 14 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 2 In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting permissions to users, logins, and... 28 January 2019 23 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 testers must not contain private... 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 and protecting data, but planning... 31 December 2018 14 min read
BI Robert Sheldon in BI Power BI Introduction: Visualizing SQL Server Audit Data — Part 9 SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view... 29 November 2018 21 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection SQL Server Auditing for HIPAA and SOX – Part 4 Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements... 13 November 2018 13 min read
