In this webinar we will cover how to use the tools SQL Server provides to capture execution plans, how to read an execution plan and how to write better queries to improve performance.
In this tip we look at how turning on Forced Parameterization for a SQL Server database can impact the usefulness of Filtered Indexes in that database.
Learn about how SQL Monitor saves significant time for operational tasks and performance monitoring for large SQL Server environments with instances on premises, in the cloud, running in virtualized environments, clusters, and Availability Groups.
In this article we look at Azure Data Factory's Mapping Data Flow which has become a promising solution for big data lake cleansing and transformations.
In this article we look at how to run SQL Server queries with Entity Framework Core using the DbSet.FromSql method, parameterized queries, stored procedures and using the Database.ExecuteSqlCommand property.
In this tip we look at a comparison of a SQL Server cursor and a While Loop to show how to perform the same operations using the two different looping mechanisms.
In this tip we look at ways to sort alphanumeric strings in SQL Server by decomposing all numeric values and sorting the string based on numeric sorting rules.
There is often the need to compare both data and database structures from two databases either on the same server or on different servers. Most text editors have a built-in process to allow you to do a diff and identify any differences between the two fi
In this tip we look at how to retrieve data related to SQL Server Agent jobs, schedules, history and more using system tables, views and stored procedures.
In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.
In this article we look at the different types of control flow activities that are available in Azure Data Factory as well as look at how to use the Execute Pipeline activity.
In this tip we look at a simple stored procedure you can create to determine which data or log files on your SQL Server instance are experiencing latency issues.
In this tip we will look at the different types of SQL Server replication, including the pros and cons and some scenarios where replication might be suitable.
Poor data quality for any reason is very expensive in terms of man hours and decision making to all organizations. There are a number of ways to address the issue with both SQL Server Reporting Services and Power BI. Learn about Melissa's solution...
