2014-05-28
599 reads
Editorial
Patching Problems
After some issues with a recent Windows patch, Steve Jones is concerned about the future of software updates.
2014-05-27
365 reads
2014-05-26
165 reads
No reason to abandon SQL
The early signs are that we can now run a SQL-based relational database with distributed execution plans over commodity hardware, leaving just the task of splicing together of the result to the engine itself, then why can’t Microsoft or Oracle do it?
2014-05-26
192 reads
Should We Move to Azure?
This week Steve Jones asks about moving to the cloud and how interesting that might be to the community?
2017-11-08 (first published: 2014-05-23)
238 reads
One Final Patch
Vote for final service packs for SQL Server 2008 and R2. Let Microsoft know that we want regular support across the entire lifecycle.
2014-05-22
135 reads
Balancing Learning
How do you determine when you use a new technique or stick with a tried and true method? Steve Jones notes that we try to teach you new things at SQLServerCentral, but do you use them?
2014-05-21
152 reads
The Development Backup
Backing up your development environment can be important. After all, aren't your developers producing products that you use?
2014-05-20
150 reads
Patching Problems
Problems with SQL Server after applying the Windows 8.1 update have Steve Jones concerned about software updates.
2014-05-19
102 reads
What are you worth?
When negotiating your salary, it helps to know what the ranges are for your experience and area. Steve Jones gives a little advice today.
2017-11-07 (first published: 2014-05-19)
423 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
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