SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
100 reads
- Interests: SQL Server!
SQL Server – Kill all sessions using database
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
1,453 reads
SQL Server – Kill all sessions using database
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
255 reads
SQL Server – Kill all sessions using database
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
95 reads
SQL Server – Custom sorting in ORDER BY clause
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
4,345 reads
SQL Server – Custom sorting in ORDER BY clause
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
428 reads
SQL Server – Custom sorting in ORDER BY clause
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
157 reads
SQL Server – Script to get Service Account for all local instances
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
1,273 reads
SQL Server – Script to get Service Account for all local instances
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
229 reads
SQL Server – Script to get Service Account for all local instances
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
125 reads
Blogs
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers