Fixing SQL Server - iPod
If we will get a new version of SQL Server every 3 years, how can we make the process smoother.
2008-01-29
47 reads
Editorial - iPod
The Mistake - iPod
SQL Server 2008 has been delayed and Steve Jones thinks the entire process of building this version has been poorly handled.editor
2008-01-28
39 reads
Tell Me What You Need - iPod
Ever worked on a software project where you didn't get all the requirements? One where the functions and features change in midstream? Steve Jones comments on some possibilities on why this happens.
2008-01-27
39 reads
2008-01-24
50 reads
The End of Estimation - iPod
How interesting would it be to not have to guesstimate what size server to buy for your next application? Steve Jones may have found a way to help you.
2008-01-23
51 reads
The In-House Expert - iPod
Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get consultants as needed? Steve Jones comments on the choices you might face as your career grows.
2008-01-22
51 reads
2008-01-21
49 reads
A Pay Raise - iPod
There's a shortage of IT workers, which should lead to a pay raise for some people. Steve Jones takes a look at some recent news about IT salaries.
2008-01-20
39 reads
Testing - iPod
We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.
2008-01-17
39 reads
Free and Cool - WMV
Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.
2008-01-17
49 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