SQL Server Tips, Articles and Training

Microsoft Fabric Monitoring with Metrics App and Data Activator

Learn about Metrics App and Data Activator for monitoring and taking necessary administrative action to control Microsoft Fabric capacity.

SQL Bulk Insert Command Examples

Learn about the SQL Server BULK INSERT command and how to use it to import text data in a SQL Server database table.

Build a Secure SQL Server REST API in Minutes

Build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise.

Popular Right Now

1 - Handling error converting data type varchar to numeric in SQL Server

2 - Connecting to SQL Server Using SQLCMD Utility

3 - How to Read Log File in SQL Server using TSQL

Disaster Recovery in the Cloud: Understanding Challenges and Strategies for SQL Server

SQL Server Performance Tuning Checklist

Get Free SQL Tips

Python

Data Quality Management Issues in Time Series Analysis Resolved with Python

In this tutorial, we delve into critical aspects of data quality management when working with time-series data and we will use Python to demonstrate.

Temp Tables

Mastering SQL Server Local and Global Temporary Tables

In this article, we walk through the syntax for SQL Server local and global temporary tables and also use cases for when and how to use them.

Azure Synapse Analytics

Azure Synapse Analytics and Power BI Integration

In this article, learn how to integrate Power BI reports with data from Azure Synapse Analytics in this step-by-step tutorial.

Microsoft Fabric

Microsoft Fabric Lakehouse OPTIMIZE and VACUUM to Cleanup Parquet Files

In this article, we will explain how the OPTIMIZE and VACUUM commands can assist in maintaining the tables in the Microsoft Fabric Lakehouse.

Python

Python String Function Examples - Concatenate, Split, Replace, Upper, Lower

Learn how to manipulate strings in Python with these string functions: concatenate, split, replace, upper, lower, and more.

Professional Development Certifications

AZ 104 Exam Preparation for Microsoft Azure Administrators

Get ready for and pass the Microsoft Azure Administrators AZ-104 Exam with this study guide with lots of useful resources.

DevOps

How to use GitHub Actions to Deploy Database Changes After a Commit

In this article, we look at how to use GitHub Actions to deploy database changes after a commit to the Main branch in a GitHub repository.

Stored Procedures

SQL Server Temporary Stored Procedures

Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.

Microsoft Fabric

Microsoft Fabric Lakehouse Table Maintenance Options for High Performance - Part 1

In this tip, we'll discuss the various maintenance options for ensuring performance doesn't degrade for lakehouse tables when using Microsoft Fabric.

Power BI

Combine Text Strings in Power BI Using DAX

Learn various ways to concatenate strings in Power BI such as using CONCATENATE, COMBINEVALUES and using an ampersand.

Power BI

Calculate Values for the Same Fiscal Week in a Previous Fiscal Year with Power BI and DAX

Learn how to use DAX logic in Power BI to enable calculating values for previous year's weeks compared to that of the current year.

SQL Server Management Studio

Export Data from SSMS to Excel

Learn various ways to quickly export data from a SQL Server Management Studio query window into an Excel file.

Tutorial

SQL CHARINDEX Function Use and Examples

Learn how to use the SQL Server CHARINDEX function along with several examples of how this might be used.

Tutorial

How To Launch a SQL Server Profiler Session

In this section we look at how to lauch the SQL Server Profiler tool to begin capturing data.

Tutorial

Modifying an existing SQL Server stored procedure

This section covers how to make changes to an existing stored procedure by using the ALTER command.

Whitepaper

Calculating Costs for Microsoft SQL Server

This white paper looks at how costs can be controlled with a sufficient understanding of the Microsoft SQL Server licensing process.

Webcast

A Beginners Guide to Query Store

Come join us to level up on your SQL Server 2022 knowledge by understanding how Query Store can help make your environment better!

Webcast

Microsoft Fabric: What it is and why you would use it

Learn about Microsoft Fabric and whether this platform is the right choice for your data environment.