Using NOLOCK hint for SQL Server updates or deletes can problematic in this tip we look at how to identify these problematic statements.

This article covers what data flows are in Azure Data Factory and how to get started with using data flows in ADF.

In this article we look at how you can create file snapshot backups for your on-premises SQL Server databases.

I am going to take the Microsoft exam 70-764, Administering a SQL Database Infrastructure. I would like to know what materials I can use to study and help pass this exam.

In this article we look at how to schedule SQL statements in Snowflake by using tasks with a step by step example of how this can be done.

Learn about CData ADO.NET adaptor for Snowflake and SSAS Multidimensional to query Snowflake data with SSAS and Power BI.

Learn how to build and use a calendar table in SQL Server to make it easier to figure out and use dates and date ranges for queries.

One nice feature of SQL Server is identity columns, but if you need to add or drop the identity property for an existing column it is not that easy.

Using the NOLOCK hint for doing updates or deletes in SQL Server can be problematic. This tip includes code to quickly find these problem statements.

In this article learn how to update data in a SQL Server table from another table using a JOIN, the MERGE statement or a subquery.

Valuable SQL Server Performance Tuning tips, tutorials, how-to's, scripts, and more for SQL Server DBAs.

There are often times when you need to access data from MySQL from within SQL Server. You could export and import the data, but another option is to create a linked server from SQL Server to MySQL. In this tip we walk through how this can be done for MyS

In this tip we look at how you can implement a type 2 slowly changing dimension with SQL Server Integration Services.

Learn how to transfer data via a CSV file from a SQL Server database to a Pandas dataframe and then subset the dataframe in Python.

Learn five things you should know about SSRS to help you build and create better reports using SQL Server Reporting Services.

Learn how to execute the same batch of SQL Server commands X number of times using the SQL Server GO command.

Learn about filtered indexes in SQL Server with this example along with pros and cons and how SQL Server handles filtered indexes.

Learn about Dataverse which is part of the Power Platform. The article explains advantages and how this could be used for Power Apps and Power BI.

Learn about SolarWinds Database Insights which combines two enterprise-ready products: Database Performance Analyzer (DPA) and SQL Sentry.

Learn about CData SSIS connectors for Salesforce and QuickBooks Online integration then upload data to Snowflake data warehouse.