How to Find the SQL Server Instance Startup Time
Learn a number of methods to view or programmatically get the SQL Server instance startup time.
2023-05-12
9,177 reads
Database Administration
Cheat Sheet for SQL Server DBA Daily Operations
This SQL cheat sheet contains a series of scripts to help address common situations that might be brought to a Microsoft SQL Server DBA. Each has a proper explanation as to what it does and how it works.
2023-05-05
2023-05-05
164 reads
2023-05-03
497 reads
2023-04-12
460 reads
2023-04-05
561 reads
Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
22,234 reads
The Top SQL Server Engine Errors
The SQL Server Support team published the top errors they see in calls. Steve has a few comments on what they're doing to help customers.
2023-03-04
544 reads
The Struggles to Keep Up with Growing Systems
The growing complexity of environments can cause struggles for many IT professionals. However, we need to ensure we are not making things worse.
2023-03-03
136 reads
2023-02-20
457 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers