Database Queries and Scalability
Does the database limit the scale of your application? Without a doubt, but that doesn't mean you shouldn't use an RDBMS.
2013-10-21
288 reads
Does the database limit the scale of your application? Without a doubt, but that doesn't mean you shouldn't use an RDBMS.
2013-10-21
288 reads
This Friday Steve Jones asks you to network at your next event and meet more people in the amazing SQL Server community.
2013-10-18
113 reads
Steve Jones looks back at a networking event this week in Charlotte. Networking is valuable to your career and it can be a tremendous amount of fun as well.
2013-10-17
118 reads
Are we thinking cloud first for database servers? Steve Jones reflects on predictions made four years ago and thinks about how the world has changed for the cloud.
2013-10-16
151 reads
Protecting our physical systems usually involves some type of security at the office. For many of this, we have some type of key card system. Andy Warren asks today how you handle things and does it work well.
2013-10-14
147 reads
Steve Jones starts the 2013 SQL in the City tour today. At least for him. He's on an airplane in order to be ready for the first US event tomorrow.
2013-10-08
161 reads
A recent survey says IT security is a major concern for many businesses. Steve Jones wonders why they don't make more of an effort to implement better security in their applications and processes.
2013-10-07
154 reads
How many developers does it take to overwhelm a DBA? It's an interesting question, and this week Steve Jones asks how many you actually support.
2013-10-04
176 reads
We are getting more and more types of data that we have to manage and store in our databases. Steve Jones notes that SQL Server can handle almost all your needs.
2013-09-30
215 reads
Phil Factor reflects on how the people who made the industry great, in the past, were often eccentric, rebellious, odd, truculent, but all blessed with the gift of creating wonderful software. Today, such people would struggle to get pass the first interview.
2013-09-30
216 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,...
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
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