How to Filter a SQL Server Audit with a Predicate
The post How to Filter a SQL Server Audit with a Predicate appeared first on SQLServerCentral.
Uncategorized
MuleSoft Integration with Azure Key Vault
Introduction MuleSoft Anypoint is a platform that helps to aggregate and integrate data from different source systems. As […]
Microsoft Build Announcements for Data Professionals
This week was Microsoft Build. After four years, it was back in person in Seattle and available online. […]
Microsoft Fabric: Enabling your Free Trial
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start […]
How to Create a SQL Database on a New Drive ...
This article explains different methods to move a SQL database into a new directory of Ubuntu Linux. This […]
Capitalize on your investments with the new centrally managed Azure ...
Introducing the new centrally managed Azure Hybrid Benefit for SQL Server. Today, Microsoft is pleased to announce the […]
5 reasons to join us at Securely Migrate and Optimize ...
The post 5 reasons to join us at Securely Migrate and Optimize with Azure appeared first on Microsoft […]
Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud ...
The post Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud Data Management Approaches appeared first on […]
DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
The post DAX CASE Statement Functionality with IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Snowflake Temporary Tables vs. Transient Tables
The post Snowflake Temporary Tables vs. Transient Tables appeared first on SQLServerCentral.
Shrink Database Log Files One by One
I have about 25-30 client databases on my computer for testing purposes when I support or do new […]
How to use the SQL WHERE Clause with Examples
The post How to use the SQL WHERE Clause with Examples appeared first on SQLServerCentral.
The Basics of PostgreSQL Views
Article Overview This article will help you to understand what is a database view in general and in […]
SQL Server 2022: Intel® QuickAssist Technology overview
Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced […]
PostgreSQL Basics: Object Ownership and Default Privileges
In the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) […]
A Simple Tutorial for DML Triggers
Introduction The trigger is a method provided by SQL Server to programmers and data analysts to ensure data […]
Steps to add a new disk to SQL Server failover ...
The post Steps to add a new disk to SQL Server failover cluster instance and move a user […]
PostgreSQL Temporary Table
Overview In this tutorial, we will learn about a PostgreSQL temporary table and its usage. We will study […]
Petit guide de Transact SQL – Partie 1
Des types de données aux tables temporelles… Ce petit guide est constituée de 4 parties qui vont être […]
Schedule Jobs on a Clustered SQL Server
High availability or Always On is achieved in SQL Server using Cluster. Clustering is a logical collection of […]
Privileges and Roles in SQL Server, Oracle and PostgreSQL – ...
The post Privileges and Roles in SQL Server, Oracle and PostgreSQL – Part 1 appeared first on SQLServerCentral.
Extend your Power BI Reports with Analysis Services 2022 Data
The post Extend your Power BI Reports with Analysis Services 2022 Data appeared first on SQLServerCentral.
Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime ...
In this article, we are going to talk about nullable and non-nullable columns specifically related to Postgres databases. […]
The Data Fabric – Future of Data Management
Data is the new gold and is truly an asset to any enterprise. As predicted by IDC, the […]
Backup Directly to a GCS Bucket in SQL Server 2022
SQL 2022 is here! Lets back up our databases directly to GCS! This new release of SQL Server […]
Encrypt SQL Server Stored Procedures to Protect Source Code
The post Encrypt SQL Server Stored Procedures to Protect Source Code appeared first on SQLServerCentral.
Configure Contained Availability Groups for High Availability in SQL Server ...
The post Configure Contained Availability Groups for High Availability in SQL Server 2022 appeared first on SQLServerCentral.
Azure Data Studio 1.41 release
We are less than one month into 2023 and already have a new release of Azure Data Studio […]
Dynamic ELT with Azure Data Factory – Part 3 of ...
In Part 1 of this series, we talked about the art of data ingestion where we discussed the […]
How to Import Data in Power BI Using R
Introduction In this article, we will learn how to import data in Power BI using R. R and Python […]
SQL Server Function Examples with JSON Files
The post SQL Server Function Examples with JSON Files appeared first on SQLServerCentral.
SQL Server point in time recovery
The post SQL Server point in time recovery appeared first on SQLServerCentral.
Verifying Trees
Introduction Employee lists in organizations are often maintained in spreadsheets or database tables which record each employee’s number, […]
PostgreSQL Basics: Roles and Privileges
Authentication Authorization Verify that the user is who they claim to be. This can be through password, […]
Technical Considerations for Data Ingestion – Part 2
In part one of this series, we discussed how to prepare for the ingestion of data. In this […]
How to work with web information, maps, and images in ...
Introduction Sometimes, we need to work with images in Power BI. This tip will be about the FIFA […]
Bucket Sort Algorithm in Python to Sort a List of ...
The post Bucket Sort Algorithm in Python to Sort a List of Array Values appeared first on SQLServerCentral.
Database Sharding to help Improve Performance and Maintenance Tasks
The post Database Sharding to help Improve Performance and Maintenance Tasks appeared first on SQLServerCentral.
Using pre-commit to prevent simple mistakes
There is no level of experience or intelligence where we cease to make mistakes. The simpler the mistake […]
How to Create a Box and Whisker Plot in Power ...
The post How to Create a Box and Whisker Plot in Power BI Desktop appeared first on SQLServerCentral.
How to Create a Power BI report using MySQL data
Introduction In this article, we will learn to create a Power BI report using MySQL data. The article […]
Using sp_prepare and sp_execute to utilize prepared SQL statements
The post Using sp_prepare and sp_execute to utilize prepared SQL statements appeared first on SQLServerCentral.
Ethical Hacking Tutorial
Are you afraid of the word hacking? Ironically, it is legal hacking that is benefiting us. If this […]
The Importance of a Good Data Model in Power BI ...
The post The Importance of a Good Data Model in Power BI Desktop appeared first on SQLServerCentral.
Secure File Transfer Protocol (SFTP) support for Azure Blob Storage
The post Secure File Transfer Protocol (SFTP) support for Azure Blob Storage appeared first on SQLServerCentral.
The Lock Escalation Threshold – Part 3
The post The Lock Escalation Threshold – Part 3 appeared first on SQLServerCentral.
Building a SQL Computational Framework for MACD Indicators
The post Building a SQL Computational Framework for MACD Indicators appeared first on SQLServerCentral.
Heapq Module in Python: Using Heaps and Priority Queues
The post Heapq Module in Python: Using Heaps and Priority Queues appeared first on SQLServerCentral.
SQL Server 2022: How Auto-Drop Statistics Work
Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, […]
Artificial Intelligence with Power BI
Executive Summary Artificial intelligence is transforming businesses across the world. There are several tools and technologies to realize […]