SQL Server isn’t used much for web-based applications, simply because the cheapest ISPs use Linux and Apache for their platform. There are ISPs that provide a .NET platform and SQL Server but it is at a cost. SSDS seems to be Microsoft’s latest attempt to break into the market for database-driven websites.
2008-03-17
155 reads
2008-03-16
44 reads
2008-03-14
121 reads
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
2008-03-13
282 reads
When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice. (This editorial was originally published on Mar 12, 2008. It is being re-run as Steve is on holiday.)
2016-09-05 (first published: 2008-03-12)
295 reads
How much of a contract for servicing SQL Server should we expect? Has Microsoft broken an implied contract with us?
2008-03-11
96 reads
Steve Jones compares his daily routine now to that of being a DBA. This editorial was originally published on Mar 10, 2008. It is being re-run as Steve is on holiday.
2012-12-27 (first published: 2008-03-10)
591 reads
A joint editorial this week from the Red Gate team looking back at the news of the week.
2008-03-10
59 reads
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
2015-10-28 (first published: 2008-03-07)
1,316 reads
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
2008-03-06
94 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers