SQL LIKE statement to search for string patterns in SQL Server data with examples SQL LIKE NOT IN, SQL LIKE Wildcard, SQL LIKE Query, etc.

In this tip we look at how you can easily update statistics for all tables in all databases on a SQL Server instance.

Learn how to use specific perfmon counters for SQL Server and how to use these to monitor and improve SQL Server performance.

Learn about several free external tools that you can connect to Power BI to assist in development and deployment of your Power BI reports.

Learn how to use SQL window functions in SQL Server for easier code development and improving performance with these code examples.

Learn TSQL tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server.

In this tip we will look at using a Streaming Dataset in Power BI to visualize real time data using the streaming service Azure Stream Analytics job.

In this article we look at some of the things you should be aware of when building a VM to run SQL Server, such as vCPUs, disks, memory and more.

In this tip we look at different approaches to change the SQL Server collation for the instance, database and table columns.

Learn to use ALM (built-in versioning) and enterprise ALM (Azure DevOps integration) with Power App source files for editing and versioning.

In this article we look at T-SQL code you can use to load historical stock prices into SQL Server for analysis using Stooq as the data source.

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

This tip looks at a simple script you can use to rebuild all SQL Server indexes for all specified databases.

One very important design aspect when creating a new table is the decision to create or not create a clustered index. We will take a look at a few points to help with the decision.

In this article we look at using streams in Snowflake to set up a change data capture scenario where only new or modified rows are processed.

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

This tip looks at numerous ways in SQL Server to clear cache when cache performance issues arise in SQL Server.

Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.

In this tip we look at how to import JSON files using SQL Server Integration Services.

In this article we look at some of the differences and similarities with working with dates in SQL Server, Oracle and PostgreSQL.