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
11,037 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,616 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,231 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,446 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,337 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
Comments posted to this topic are about the item Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers