(Anoop Kumar) In a previous article, we discussed Dynamic Data Masking (DDM) and how DDM helps to secure PII/PHI data from unprivileged users. The DDM feature is available in SQL Server 2016 onwards as well as Azure SQL Database.
Tag: sql server
SQL Server Temporal Tables vs Change Data Capture vs Change Tracking – part 3
(Ameena Lalani) In part 1 and part 2 of this 3-part series, we talked about Change Tracking (CT) and Change Data Capture (CDC) features of SQL Server. Although, these pre-SQL Server 2016 data tracking technologies have their own uses, SQL Server 2016 Temporal Table is the far superior option. Let us
Five SQL Server maintenance steps you should take — ASAP
(Brien Posey) Putting off SQL Server administration tasks can lead to database problems. Enact these often-neglected maintenance items to help keep your SQL Server systems running smoothly.
How to Check if Your Database Server Is Protected Against Meltdown and Spectre
(Thomas LaRock) Last week I wrote about the Meltdown and Spectre vulnerabilities. Today I want to show you how to check if your database server is protected against Meltdown and Spectre.
SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use
(Pinal Dave) People generally ask me; how do I manage to find a blog topic for every day blogging? And my answer is – “Connect yourself to the ground, try to help people with the basics, have open eyes & ears and promise yourself to learn one new thing every day”.
Database File movement in SQL AlwaysOn Availability group: A walk-through
(Don Castelino) In this blog, we are covering the scenario of moving the database files of AlwaysOn Availability Group (AG) enabled database to another location on all replicas with minimum downtime.
Different Ways to Find SQL Server Orphaned Users
(Jeffrey Yao) SQL Server orphaned users are a common thorny issue in auditing. Microsoft has an article Troubleshoot Orphaned Users (SQL Server) that addresses one scenario, i.e. a SQL login (i.e. the login is not created from windows user / certificate / asymmetric key).
SQL SERVER – Introduction to Log Space Usage DMV – sys.dm_db_log_space_usage
(Pinal Dave) It has been quite a while since SQL Server 2017 has been introduced, however just recently I have been seeing interest for this project. Lots of users are just switching to SQL Server 2017 and I believe that is normal.
Azure Cosmos DB Consistency Levels
(Marcin Policht) The majority of traditional database management systems are responsible for making sure that any changes to their data are consistently reflected in the results of subsequent queries.
Five SQL Server database trends to be prepared for in 2018
(Michael Otey) Here’s a list of notable trends related to SQL Server that IT teams should be ready for over the next 12 months. Among them: increased use of the cloud, AI, Linux and containers.