Building a Better Profile
Steve thinks building a brand is important in today's competitive world of job seekers.
Steve thinks building a brand is important in today's competitive world of job seekers.
Learn how you can shrink your transaction log files serially, one by one.
When working with Snowflake, it is important to understand the different types of tables available and when to use each one. In this tutorial, we will compare Snowflake temporary and transient tables, highlight their similarities and differences, and provide examples of when to use each type of table.
There is an interesting court case on who is responsible for the data being posted on the Internet. Steve has a few thoughts today.
Learn how to get a Failover Cluster Instance set up and configured with Windows and SQL Server. This is part of a series showing how to combine a Failover Cluster Instance of SQL Server with an AlwaysOn availability group.
Flyway's output is often overwhelmed with verbose messages, most of which we can ignore but some of which provide vital warnings about failed compilations, or useful details about what a migration or callback did. I'll show how to use some pipeline-aware PowerShell functions to filter out and save the bits we want and pass the results along in a form that is useful to the next process in the pipeline.
There might be a time when you might want to return just a few rows of a result set, instead of the complete set. This might be useful if you want to just validate a selection criteria or a few rows of data. For whatever the reason the TOP clause can be used to return a specific number or a percentage of rows from a result set. This article will cover using the TOP clause in a SELECT statement and how it can be used to return a partial set of records.
This article looks at an interesting way to help your users get filtered data from a TVF instead of using a stored procedure or specialized view.
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
It is common to see high worker count issue on the production server and...
I want to align a Date column (datetime2(7)) with the same full resolution date...
Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...
Looking for suggestions\examples of how to update a SP that the table used changes...