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
76 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,434 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
238 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
78 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,308 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
402 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
132 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,249 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
217 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
103 reads
Blogs
Code signing for mere mortals
Well, turns out code signing is pretty complex, so I’m writing this blog post...
Blogging for the Tech Professional at Denver Dev Days
By Steve Jones
For those that attended my talk at Denver Dev Days, here are the slides:...
Getting AI Written Unit Tests
By Steve Jones
As a part of my AI experiments, I decided to ask CoPilot to write...
Forums
Software Flexibility (Avoiding the next hack)
Comments posted to this topic are about the item Software Flexibility (Avoiding the next...
Delayed tcp acknowledgement registry setting
Our IT department contacted me recently and asked if they should change the default...
Ask SSC