solutioncenter.apexsql.comSolution center - Solutions for DBAs and Developers

Solutions Products Downloads Prices SupportTools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server ApexSQL Compare and Sync Toolkit for SQL Server Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server Spotlight Cloud hosted SQL Server monitoring and diagnostics LiteSpeed High-speed SQL Server backup, compression and restore What’s new What’s nextDatabase administration Automate critical tasks for database administration Auditing and compliance Database backup Disaster recovery Forensic auditing Index defragmentation Inventory management Load testing Object level restore Server compare SQL job automation SQL Server monitoring Transaction log reading Transactional replication Database development Integrate database changes and automate deployments Continuous delivery Continuous integration Data compare Data import/export Data masking Database DevOps Database documentation Database modeling Dependency analysis Developer productivity Development best practices Documentation Multi-DB script execution MySQL data compare MySQL documentation MySQL schema compare Object decryption Object refactoring Packaging and deployment Schema and data scripting Schema compare Script comparison SharePoint documentation SQL formatting SQL Server documentation SQL source control SQL unit testing SSAS documentation SSIS documentation SSIS package compare SSRS documentation Statement auto complete Static code analysis Test data generation Text and object search Solution centerSolution center How to automate event data extraction using SQL audit reporting API Introduction In a scenario where SQL audit data requires special processing, reviews, and analysis, it can be accomplished by designing an in-house custom application to read the data and provide desired output and visualization. Since the ApexSQL Audit central repository database uses a proprietary design with encryption applied, a custom database will have to be used to provide data to the said in-house application. December 15, 2021 Extract SQL Auditing data into Power BI Growing datasets and information in the modern digital age become considerable businesses’ assets as data drives many important decisions for organizations. Therefore, many companies are challenged with keeping a close eye on data governance processes that expand together with the amount of data being accumulated. To an extent, SQL auditing data is not an exception, and it might play an important role while screening for potential data breaches, learning about activity trends and data flows. December 15, 2021 How to export SQL Server data to a text file format Text file represents a document that contains information in plain text. Any text editor and most popular web browsers are suitable for viewing or editing text file formats. Also, all smartphones are equipped with suitable applications that can open and edit text file formats. As such, text file formats are the most relevant file formats for sharing information between users. SQL Server users, among other things, can export data in text file format, which will be explained further in the article. April 14, 2021 How to configure SQL auditing data central repository automatic backups Although ApexSQL Audit provides high versatility for SQL auditing, it lacks internal functionalities for data repository redundancy or disaster recovery. There is the capability to archive the central repository but that would require further manual manipulation to backup those archives and create some disaster recovery plan. Inheritably, the active repository remains unattended. For disaster recovery, the application will have to rely on the native SQL Server backup method. April 6, 2021 How to decrypt stored procedures on multiple SQL databases Problem Before we show how to decrypt stored procedures, we need to give some background about this concept. When stored procedures are built in the SQL Server, their body text is reachable to all that have required permissions to access the data. Because of that, it’s simple to expose underlying content during created stored procedures and analyze that content through the SQL Server Management Studio, Windows PowerShell, or any commercial tool. As a result of data transparency, a SQL database can become vulnerable and compromised by any type of cyber-criminal activity. This is where encryption comes into place. March 3, 2021 Exporting SQL Server data to a CSV file This article will explain how to export SQL Server data to a CSV file type. CSV represents a file format where plain text values are separated by a delimiter, usually comma symbol (Comma-Separated Values). It is one of the most common format types for any spreadsheet program. CSV files are easy to organize and edit, and can be used by many different business software programs for data analysis. Large amounts of data can be better organized with CSV files, and those files can be easily edited and created by different spreadsheet applications. February 26, 2021 Using Ignore comparison script options to define database changes Challenge Database development in a multiuser environment has its challenges on a daily level even without including the database source control. But when the database source control is included, based on the chosen source control system, those challenges can multiply by the number of database developers working on the same database. February 19, 2021 How to import data into a SQL database from Excel Importing data in SQL database is playing an important role when working with SQL servers. There are various techniques and tools to facilitate data entry into the SQL database. This article will explain how to import data in an SQL database from an Excel file by using two methods: SQL Server Management Studio (SQL Server Import and Export data wizard) ApexSQL Pump January 27, 2021 How to script SQL objects, format, and run SQL scripts on multiple SQL Server instances A part of DBA’s and developer’s role is to migrate SQL Server databases between hosts or migrate from a local development environment to a live hosted environment. It requires copying all database objects such as database schema, tables, stored procedures, functions, indexes, etc. For this, different methods can be used depending on a requirement such as a database backup restore, object SQL scripts, BACPAC files, etc. January 12, 2021 How to export SQL Server data to Excel This article will explain how to export data from SQL databases to Excel file format by using two methods: SQL Server Import and Export Wizard – Microsoft’s native way to copy data from a source to a destination ApexSQL Pump – a third-party SQL data pump tool for importing and exporting SQL Server data to different file types January 5, 2021 How to query data using a SELECT statement in SQL Server The SELECT statement in SQL is the most used of the DML statements and it’s used for fetching data from tables in SQL Server. This article is intended for DBAs and developers who want to get familiar with all the major components of the SELECT statement and what this statement is all about. January 4, 2021 How to use Dynamic data masking on Azure SQL Database SQL databases can contain a lot of data, including a lot of sensitive data. This sensitive information can easily be misused. Mask SQL Server data is of great importance when the SQL database contains a lot of sensitive data. Microsoft has offered a dynamic data masking feature that has been implemented in SQL Server 2016 and later versions, as one of the solutions for protecting sensitive data in SQL databases. December 22, 2020 How to find and safely rename SQL objects in SQL Server databases Frequently, developers and...