SqlDeep - SQL and BI technologies in depth

How to generate SSAS OLAP database creation script from deployed Multidimensional and Tabular database In this article we will show you how to export whole SSAS Multidimensional and Tabular database objects from published databases with…

Deleting the Information from Large Tables Most of the time it happens for Developers or DBA’s or BI experts to delete all the information of a table consisting of several thousands of records. To this end, there are various methods…

Introduction Maintaining data integrity and durability are among the basic principles of any RDBSM. As one of the well-known RDBMSs, SQL Server is no exception to this rule and has benefited from the concept of Transactions. Based on the…

In this article we will show you how to create SQL Server SSL Certificate template and sending SSL Certificate Signing Request (CSR) from that template to CA server, also we will issue requested certificate and use it on SQL Server machine.…

In this article we will show you how to install and configure your first CA service across your domain environment. This step is essential if you want to encrypt SQL Server communications via SSL certificates (Until Microsoft SQL Server…

While working as a DBA or developer, there might be some cases that you need to keep a very limited number of records in a large table and remove the remaining records (for example, you may wish to keep 1000 records in a table containing…

Introduction As you know, transactions are units of work which performed against a database. SQL Server makes uses of this concept for Consistency and Durability of data in a system. Due to Atomicity feature, transaction or all the…

Adds a log file to a file group when recovery cannot complete on a database due to insufficient log space (error 9002). After the file is added, sp_add_log_file_recover_suspect_db turns off the suspect setting and completes the recovery of…

Adds a data file to a filegroup when recovery cannot complete on a database due to insufficient space on the file group (error 1105). After the file is added, this stored procedure turns off the suspect setting and completes the recovery of…

Query Store notice If you use the Query Store feature, and you have previously installed Cumulative Update 2 (CU2) (14.0.3008.27), the following requirement applies to you: After you install Cumulative Update 3 (CU3) (14.0.3015.40) or a…

SQL Server 2019 package native to Ubuntu 18.04 ecosystem, fully supported for production use, starting with CU3.…

SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical IO, and memory that incoming…