SQL Server Windowing Functions
SQL Server windowing functions are a powerful and versatile set of tools that allow you to perform complex calculations and operations on a set of… Read More »SQL Server Windowing Functions
SQL Server Log Backups
In SQL Server, log backups are copies of the transaction log that can be used to restore the database to a specific point in time.… Read More »SQL Server Log Backups
Merry Christmas
Merry Christmas from the team at Stedman Solutions, LLC. Our offices will be closed to celebrate Christmas this year. If you need emergency help during… Read More »Merry Christmas
Christmas Queries
Here is a sample Christmas-themed query for SQL Server: This query returns the greeting “Merry Christmas!” and the current date. It only selects user tables… Read More »Christmas Queries
Merry Christmas! 2022-12-25 00:00:00.000
Merry Christmas! 2022-12-25 00:00:00.000 This output shows that the query is only returning user tables with an even object ID and the date is December… Read More »Merry Christmas! 2022-12-25 00:00:00.000
Min and Max Aggregate Functions in TSQL
Here is a sample query using the MIN and MAX functions in T-SQL: This query selects the minimum and maximum values for the Price column… Read More »Min and Max Aggregate Functions in TSQL
Do Not Email Passwords
It’s never a good idea to email passwords, whether it’s your own personal password or a password that you’re sharing with someone else. Here are… Read More »Do Not Email Passwords
New Course – Preparing for Corruption in SQL Server
Corruption in a SQL database is when the database becomes damaged or corrupted, making it unable to be used or accessed. This can happen for… Read More »New Course – Preparing for Corruption in SQL Server
Common Waits Reported by Daily Monitoring This Month
Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there… Read More »Common Waits Reported by Daily Monitoring This Month
SQL Server Backups
SQL Server backups are an essential part of any database administrator’s job. In this blog post, we’ll discuss what SQL Server backups are, why they’re… Read More »SQL Server Backups