Join us for this free webcast and learn things about SQL Server database design, T-SQL development, optimizing for performance, BI development and more.
Sometimes we need to compare tables and/or data to know what was changed. This tip shows you different ways to compare SQL Server data, datatypes and tables.
In this tip we look at how to use Common Table Expressions CTE in SQL Server including the syntax, use cases, using more than 1 CTE at the same time and recursive CTEs with a parameter.
Our company’s entire IT infrastructure is growing rapidly, but our SQL Server environment is growing exponentially faster. My team needs to make sure we have consistency across our SQL Server instances.
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another opti
We've found that writing a resume continues to be the biggest pain point for job seekers, followed closely by interviewing and effectively applying for positions so your resume gets seen and you get an interview request! In this cookbook, we're excited to
Learn about options to copy a table from one SQL Server database to another including Linked Servers, PowerShell, Integration Services, backup and restore along with the associated performance metrics and completion time.
In this tip we take a look at some of the SQL Server system tables in the msdb database and this can be useful to learn about backups and restores that occurred.
Azure Resource Manager (ARM) is the deployment and management service for Azure. It provides a consistent management layer that enables you to create, update, and delete resources in your Azure subscription to help you keep things consistent.
In this series of tips we will look at different ways using temporary data in SQL Server along with examples. In this first part we will cover some reasons for doing this and different types of temporary data stores.
In this tip I want to point out a few of the concepts that I wish I had spent more time researching earlier on in my SQL Server career and provide my reasoning and some links to further reading.
Check out this PowerShell script that will help identify size of the MSDB database as well as the largest table in the database across all of your instances to make decisions on the needed SQL Server maintenance.
In this tip we look at different ways to search SQL Server system objects to find specific strings within stored procedures, triggers, functions and more.
I need way to roll-up multiple rows into one row and one column in SQL Server. I know I can roll-up multiple rows into one row using Pivot, but I need all of the data concatenated into a single column in a single row.
In this tip we look at how we can create a burn down chart using Microsoft Excel. This could be further developed to pull in data from SQL Server to automate the chart creation.
In this tip we look at ways to control the flow of SQL Server stored procedures to make sure things are processed in sequence using T-SQL and PowerShell.
In this tip we'll discuss how we can create an Azure Logic App which is going to be started from an Azure Data Factory pipeline that will refresh a Power BI dataset.
