Documentation is never a favorite task for developers. This article describes how you can use database system catalogs to make generating column descriptions less labor-intensive and also jump start a data dictionary or catalog.
2020-01-14
3,817 reads
Microsoft has a new virtual core offering of Azure SQL database called serverless and this offering optimizes the price performance tradeoff and simplifies performance management for databases with intermittent and unpredictable usage.
2020-01-14
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,927 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,507 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,190 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
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Thanks in advance for any clues on this. I am trying to write a...
Comments posted to this topic are about the item Backup to Immutable Storage
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers