Replace existing Database? JFDI!
Tony Davis argues that the WITH REPLACE option of the RESTORE DATABASE command is a case where the naming of the option masks its true "JFDI" nature…
2012-04-02
153 reads
Editorials
Skipping April Fools
No April Fool's jokes from SQLServerCentral this year and Steve explains why today.
2012-04-02
283 reads
Backup and Restore
Today's editorial was originally published on May 13, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve Jones talks about the need to train yourself, just like people in other professions.
2012-03-30
214 reads
The Mechanical Turk
Today's editorial was originally published on Apr 17, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve talks about the Mechanical Turk process at Amazon.
2012-03-29
223 reads
Is Computer Science Dead?
Today's editorial was originally published on Apr 27, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve talks programming.
2012-03-28
374 reads
Vendor Selection
Today's editorial was originally published on Apr 29, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve Jones talks about purchasing software.
2012-03-27
73 reads
Make Meetings Fun
Today we have a guest editorial from Andy Warren as Steve Jones is at SQL Server Connections. Today Andy talks about how we can make those dreaded daily events, meetings, better.
2012-03-26
161 reads
The Clonesome Database
You need a quiet couple of hours poking about with DMVs, and checking execution plans to get to the bottom of the a query issue, but you can't make a copy the production database either. It's too big, and the data is private....
2012-03-26
226 reads
The Maintenance Poll
This Friday Steve Jones asks about maintenance. Do you have regular windows? Flex time? Or is maintenance just added on whenever it is needed and added onto your work week.
2012-03-23
134 reads
A Personality Test
Today we have a guest editorial from Andy Warren as Steve Jones is on vacation. Today Andy talks about personality tests and what they might tell you about yourself.
2012-03-22
383 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