SQL Shack - articles about database auditing, server performance, data recovery, and more

Time 2022-09-15 14:14:14

Web Name: SQL Shack - articles about database auditing, server performance, data recovery, and more

WebSite: http://www.sqlshack.com

ID:315974

Keywords:

about,database,auditing,SQL

Description:

SQLShack

Getting started with Azure SQL Managed Instance

September 14, 2022 by Daniel Calbimonte

Introduction

In the previous article, Getting started with Azure SQL, we learned the basics to create an Azure SQL database.

Read more »

Manage SQL Databases in CentOS: Backup and Restore SQL Database

September 12, 2022 by Nisarg Upadhyay

In this article, we will learn how we can backup and restore the SQL Database in CentOS. This article is the second article on the topic Manage SQL Server on CentOS. In my previous article, Install SQL Server on CentOS, we learned how we could install and create a SQL Database in CentOS.

Read more »

Understanding Azure Cosmos DB backup options

September 9, 2022 by Manvendra Singh

This article will explore backup options available in the Azure Cosmos DB service. Backups are very important to safeguard our data in case of data corruption, data deletion, system failure, or any unforeseen circumstances like DR. We have planned, configured, and managed it for our on-prem databases whether it is SQL Server, Oracle, DB2, or system files on various machines. DBAs and Infrastructure admins have ensured to keep a backup of all these systems to safeguard their data. Similarly, we must also secure our data hosted in a cloud environment for any services whether it is Azure VMs, Azure SQL, Cosmos Db accounts, or any other services. Today we will talk about backup options available to secure cosmos DB databases and their contents.

Read more »

How to configure periodic backup for an Azure Cosmos DB account

September 7, 2022 by Manvendra Singh

This article will talk about the periodic backup policy of the Azure Cosmos DB service offered by Azure cloud. I have already explained the backup options available for Cosmos DB in my last article. I would recommend you read it by accessing the attached link “Understanding Azure Cosmos DB backups” to understand the backup policies of Azure Cosmos DB. Today, I am going to explain one of the backup options Periodic backup, and steps about how to configure it for a cosmos DB account.

Read more »

Getting started with Data Explorer pools in Azure Synapse

September 5, 2022 by Gauri Mahajan

In this article, we will learn how to set up and configure Azure Data Explorer based data processing capability on Azure Synapse.

Read more »

Exploring Azure SQL Database Geo-Restore

September 2, 2022 by Rajendra Gupta

This article explains Azure SQL Database Geo Restore using geo-replicated backups for disaster recovery.

Read more »

Deploy a SQL Server container using Azure Kubernetes Services (AKS)

August 31, 2022 by Rajendra Gupta

This article deploys a SQL Server container using Azure Kubernetes Services (AKS).

Read more »

Template Gallery in Azure Synapse Lake Database

August 29, 2022 by Gauri Mahajan

In this article, we will learn how we can create tables in the Azure Synapse Lake Database instance first and bind it with data later.

Read more »

Configuring tables and relationships in Azure Synapse Lake Database

August 26, 2022 by Gauri Mahajan

In this article, we will learn how to configure properties and relationships in Azure Synapse Lake Database.

Read more »

Manage SQL Databases in CentOS: Install SQL Server on CentOS

August 24, 2022 by Nisarg Upadhyay

In this article, we will understand how we can manage a SQL Database in CentOS 8.0. This article is the first article on the topic Manage SQL Server on CentOS.

Read more »

Deploy Azure SQL Elastic Pools for Azure SQL Database

August 23, 2022 by Rajendra Gupta

This article gives an overview and deployment steps for SQL Elastic Pool for Azure SQL database.

Read more »

Getting started with Azure Synapse Lake Database and Lake tables

August 19, 2022 by Gauri Mahajan

This article will get you started with Azure Synapse Lake Database and Lake tables.

Read more »

Managing memory-optimized file groups of SQL Database

August 17, 2022 by Nisarg Upadhyay

This article explains how to manage a memory-optimized filegroup of SQL Database. The memory-optimized filegroup contains the memory-optimized tables and table variables. I have written two articles that explain how we can migrate the disk-based tables to memory-optimized tables. Now, we will learn how to add memory-optimized filegroups in a SQL database. I will cover the following topics in the article.

Read more »

Rebuild system databases for SQL Server on Linux and Windows

August 15, 2022 by Rajendra Gupta

This article explores the process for rebuilding system databases – Master, MSDB, and Model for SQL Server on Linux and Windows.

Read more »

Getting started with PostgreSQL on Docker

August 12, 2022 by Aveek Das

In this article, we will learn how to get started using PostgreSQL on Docker. PostgreSQL is one of the most popular open-source databases that is being used by a lot of developers. It is highly stable and has a large community that maintains and supports the database development lifecycle. PostgreSQL can be installed on any operating system like Windows, macOS, and Linux. With the rise in containerization technologies, PostgreSQL can now also be installed using Docker.

Read more »

Configure cross-platform SQL Server Always On Availability Groups

August 10, 2022 by Rajendra Gupta

This article for the Always On Availability Groups series will show how to configure SQL Server Always On Availability Groups between Windows and Linux SQL instances.

Read more »

Managing file groups of SQL Databases

August 8, 2022 by Nisarg Upadhyay

IN this article, we are going to learn how we can manage the filegroup of SQL Database in SQL Server. The SQL Server has four filegroups.

Read more »

SSMS 2016 – A FAQ manual

August 5, 2022 by Daniel Calbimonte

Introduction

In this article, we will answer the most common questions related to SSMS 2016 like these ones:

What is SSMS 2016? How to install SSMS 2016? What SSMS versions exist? Is SSMS 2016 compatible with any SQL Server version? What changes were made in SSMS 2016? How to uninstall SSMS 2016? Read more »

SQL Server Data Tools for Visual Studio 2015

August 3, 2022 by Daniel Calbimonte

The SQL Server Data Tools for Visual Studio 2015 are tools used for different purposes like:

Working in relational database projects. Creating multidimensional or tabular databases in Analysis Services. Using Integration Service projects to import and export data. Building Reports in reporting services. Read more »

SQLPackage utility to export Azure SQL Databases

August 1, 2022 by Rajendra Gupta

Azure SQL Database does not support native database backups. Therefore, you cannot use it to move from the Azure cloud to on-premises SQL Server. You can use the data-tier application BACPAC file format for exporting database schema and data from the Azure database. This BACPAC file is helpful to deploy on an Azure SQL Database, Managed Instance, and on-premises SQL Server.

Read more »

Managing Cosmos DB using Azure storage explorer

July 29, 2022 by Manvendra Singh

This article will explain how to perform various activities for Azure cosmos DB using Azure storage explorer. The storage explorer is a very useful desktop utility that helps admins to manage Azure storage without accessing the Azure portal. We can also connect to Azure Cosmos DB accounts using this tool but this feature will be deprecated in the future. As of now, it is supported so I decided to explore it for cosmos DB activities.

Read more »

Import data using R in Power BI

July 27, 2022 by Gauri Mahajan

In this article, we will learn how to configure Power BI to work with R and source the required datasets from it for reporting in Power BI Reports.

Read more »

Enable Azure Storage diagnostics – Storage Metrics and Storage logging

July 25, 2022 by Manvendra Singh

Azure storage is a core cloud storage service that is used by almost all application or database deployments. We use it in SQL Server for various requirements like for backing up our databases directly to blob storage or some clients prefer to host their databases in Azure blob storage to leverage snapshot backups functionality. Today, I will explore how to monitor and troubleshoot blob storage issues in the Azure cloud by looking into storage metrics and storage logging features of Azure storage. We can configure or enable both configurations to view graphs and visualize their metrics like how storage is performing in the Azure cloud during each transaction. We will be discussing two storage diagnostics features Storage Metrics and Storage Logging which are extensively used to identify a storage problem in the Azure cloud.

Read more »

How to perform Process Mining using Power BI

July 20, 2022 by Gauri Mahajan

In this article, we will learn how to perform Process Mining with Power BI.

Read more »

Five beneficial Azure Data Studio Extensions for SQL developers

July 19, 2022 by Esat Erkec

This article will mention five helpful Azure Data Studio extensions that may help to improve the SQL developers’ productivity.

Read more »Page 1 of 10212345...102030...»Last »

Follow us!

Popular

SQL Convert Date functions and formats SQL Variables: Basics and usage SQL PARTITION BY Clause overview Different ways to SQL delete duplicate rows from a SQL Table How to UPDATE from a SELECT statement in SQL Server SELECT INTO TEMP TABLE statement in SQL Server How to backup and restore MySQL databases using the mysqldump command CASE statement in SQL SQL Server functions for converting a String to a Date SQL WHILE loop with simple examples Overview of SQL RANK functions INSERT INTO SELECT statement overview and examples SQL multiple joins for beginners with examples The Table Variable in SQL Server Understanding the SQL MERGE statement SQL percentage calculation examples in SQL Server SQL Server table hints – WITH (NOLOCK) best practices SQL Server Common Table Expressions (CTE) SQL Not Equal Operator introduction and examples SQL varchar data type deep dive

Trending

SQL Server Transaction Log Backup, Truncate and Shrink OperationsSix different methods to copy tables between databases in SQL ServerHow to implement error handling in SQL ServerWorking with the SQL Server command line (sqlcmd)Methods to avoid the SQL divide by zero errorQuery optimization techniques in SQL Server: tips and tricksHow to create and configure a linked server in SQL Server Management StudioSQL replace: How to replace ASCII special characters in SQL ServerHow to identify slow running queries in SQL ServerSQL varchar data type deep diveHow to implement array-like functionality in SQL ServerAll about locking in SQL ServerSQL Server stored procedures for beginnersDatabase table partitioning in SQL ServerHow to drop temp tables in SQL ServerHow to determine free space and file size for SQL Server databasesUsing PowerShell to split a string into an arrayKILL SPID command in SQL ServerHow to install SQL Server Express editionSQL Union overview, usage and examples

Solutions

Read a SQL Server transaction logSQL Server database auditing techniquesHow to recover SQL Server data from accidental UPDATE and DELETE operationsHow to quickly search for SQL database data and objectsSynchronize SQL Server databases in different remote sourcesRecover SQL data from a dropped table without backupsHow to restore specific table(s) from a SQL Server database backupRecover deleted SQL data from transaction logsHow to recover SQL Server data from accidental updates without backupsAutomatically compare and synchronize SQL Server dataOpen LDF file and view LDF file contentQuickly convert SQL code to language-specific client codeHow to recover a single table from a SQL Server database backupRecover data lost due to a TRUNCATE operation without backupsHow to recover SQL Server data from accidental DELETE, TRUNCATE and DROP operationsReverting your SQL Server database back to a specific point in timeHow to create SSIS package documentationMigrate a SQL Server database to a newer version of SQL ServerHow to restore a SQL Server database backup to an older version of SQL Server

Categories and tips

►Auditing and compliance (50) Auditing (40) Data classification (1) Data masking (9) Azure (287) Azure Data Studio (46) Backup and restore (108) ►Business Intelligence (481) Analysis Services (SSAS) (47) Biml (10) Data Mining (14) Data Quality Services (4) Data Tools (SSDT) (13) Data Warehouse (16) Excel (20) General (39) Integration Services (SSIS) (125) Master Data Services (6) OLAP cube (15) PowerBI (95) Reporting Services (SSRS) (67) Data science (21) ►Database design (227) Clustering (16) Common Table Expressions (CTE) (11) Concurrency (1) Constraints (8) Data types (11) FILESTREAM (21) General database design (100) Partitioning (13) Relationships and dependencies (12) Temporal tables (12) Views (16) ►Database development (416) Comparison (4) Continuous delivery (CD) (5) Continuous integration (CI) (11) Development (145) Functions (105) Hyper-V (1) Search (10) Source Control (15) SQL unit testing (23) Stored procedures (34) String Concatenation (2) Synonyms (1) Team Explorer (2) Testing (35) Visual Studio (14) DBAtools (35) DevOps (23) DevSecOps (2) Documentation (22) ETL (74) ►Features (212) Adaptive query processing (11) Bulk insert (16) Database mail (10) DBCC (7) Experimentation Assistant (DEA) (3) High Availability (35) Query store (10) Replication (40) Transaction log (59) Transparent Data Encryption (TDE) (21) Importing, exporting (50) Installation, setup and configuration (121) Jobs (42) ►Languages and coding (685) Cursors (9) DDL (9) DML (6) JSON (17) PowerShell (77) Python (37) R (16) SQL commands (196) SQLCMD (7) String functions (21) T-SQL (274) XML (15) Lists (12) Machine learning (37) Maintenance (98) Migration (50) Miscellaneous (1) ►Performance tuning (868) Alerting (8) Always On Availability Groups (82) Buffer Pool Extension (BPE) (9) Columnstore index (9) Deadlocks (16) Execution plans (125) In-Memory OLTP (22) Indexes (79) Latches (5) Locking (10) Monitoring (100) Performance (196) Performance counters (28) Performance Testing (9) Query analysis (121) Reports (20) SSAS monitoring (3) SSIS monitoring (10) SSRS monitoring (4) Wait types (11) ►Professional development (68) Professional development (27) Project management (9) SQL interview questions (32) Recovery (33) Security (84) Server management (24) SQL Azure (269) SQL Server Management Studio (SSMS) (90) SQL Server on Linux (18) ►SQL Server versions (177) SQL Server 2012 (6) SQL Server 2016 (63) SQL Server 2017 (49) SQL Server 2019 (57) SQL Server 2022 (2) ►Technologies (328) AWS (45) AWS RDS (56) Azure Cosmos DB (28) Containers (12) Docker (9) Graph database (13) Kerberos (2) Kubernetes (1) Linux (43) LocalDB (2) MySQL (49) Oracle (10) PolyBase (10) PostgreSQL (31) SharePoint (4) Ubuntu (13) Uncategorized (5) Utilities (21) Helpers and best practicesBI performance countersSQL code smells rulesSQL Server wait types

© 2022 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy

TAGS:about database auditing SQL

<<< Thank you for your visit >>>

Hot Websites