In the event of a breach of personal data, any organization must produce proof that they understand what data they hold and where, and how it is being used, and that they have enforced the required standards for access control and security. To make all this possible, it is essential to build a complete model of the data and its lineage, and a data catalog is the first step in this process.
2020-01-14
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
2020-01-13
10,983 reads
In this tip we look at how to insert and delete data via SQL Server views.
2020-01-13
Learn about programmatically obsoleting unused SSRS reports from your Report Server.
2020-01-10 (first published: 2017-04-26)
15,555 reads
As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design considerations for porting a SQL Server schema to Cassandra. The first article explains the Cassandra primary key.
2020-01-10
Learn how to set up Polybase in containers to access an Oracle database.
2020-01-09
5,204 reads
In this tip we look at what happens if we replace the SQL Server model database with a regular user database
2020-01-09
2020-01-08
Even simple changes that don't look like they will affect anything often do.
2020-01-07
2,432 reads
Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]
2020-01-07
10,276 reads
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Recently, our dev teams approach me for advice on improving their huge heap table...
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Comments posted to this topic are about the item Why Your Index Isn't Being...
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers