SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either restarted or when the last time was that the...
2011-03-23
8 reads
Jason Brimhall
SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either...
2011-03-23
1,525 reads
SQL Resource
By now, I am sure that you are well aware of the Resource Database. Starting with SQL Server 2005, a new system database was made available – the Resource...
2011-03-22
10 reads
SQL Resource
By now, I am sure that you are well aware of the Resource Database. Starting with SQL Server 2005, a...
2011-03-22
846 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue is the duplication of data. Duplicate data can happen...
2011-03-21
11 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue...
2011-03-21
1,381 reads
Database Tools Follow-up
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple of things that i hadn’t even considered. In thinking...
2011-03-18
4 reads
Database Tools Follow-up
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple...
2011-03-18
602 reads
Database Tools
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking. Those posts work well in conjunction with a post...
2011-03-17
9 reads
Database Tools
Recently I have posted a couple of articles about various database or SQL tools either for maintenance or for benchmarking....
2011-03-17
4,456 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers