Planning to move your SQL Server instances to any of the major public cloud platforms requires considerations for both high availability and disaster recovery. Attend this webinar to learn the differences and similarities between AWS, Azure and Google.
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...
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 take a look at one approach to downgrade a SQL Server database to a lower version of SQL Server since a simple backup and restore will not work.
In this tip we look at some scripts you can use to monitor your database activity and usage based on the size of the SQL Server transaction log backups.
In this tip we look at a script that you can use to get better insight on your database tables to help you make some decisions about the data and also the structure of the table.
In this tip we look at how to handle SQL Server database concurrency issues using Entity Framework Core for both pessimistic and optimistic concurrency.
In this tip we look at a SQL Server script you can use to determine if you can convert your big integer columns to smaller integer data types to save storage space.
In this tip we look at two new features of SQL Server Management Studio that are worth getting, high definition interface support and increased query results output size to 2MB.
In this tip we continue our series on best practices for improving T-SQL performance with tips on sargability, parameter sniffing, covering indexes and more.
This tip leverages a prior tip introducing the hierarchyid data type with examples for creating and querying a bill of materials table with hierarchyid values.
In this tip we look at different queries you can use to directly get information about SQL Server Agent Jobs instead of using SQL Server Management Studio.
In this tip we cover some of the various SSAS tips that I wish I knew when I started working with SSAS. I hope you find these tips useful so you can get the most out of SQL Server Analysis Services.
This step by step tip will help you get started with SQL Server Execution Plans. It is an overview of SQL Server Execution plans including the steps for queries to execute.
This article will help you decide between three different change capture alternatives and guide you through the pipeline implementation using the latest available Azure Data Factory V2 with data flows.
In this tip we look at a T-SQL script you can use to quickly find the last time the server was rebooted and also the last time the SQL Server service was restarted.
