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
SQL Server Wait Type: SOS_PHYS_PAGE_CACHE
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database.… Read More »SQL Server Wait Type: SOS_PHYS_PAGE_CACHE
SQL Server Wait Type: LCK_M_S
The LCK_M_S wait type is one of those that you may frequently see when analyzing sql server wait types. Wait statistics, in the context of… Read More »SQL Server Wait Type: LCK_M_S