Upgrading Your Career
Certification is on Steve Jones' mind this week after quite a few training opportunities have popped up lately.
2012-02-13
282 reads
Editorials
Encryption in Production
This Friday Steve Jones wants to know if you are using encryption in your production system and if so, how is it working? Can you handle DR situations?
2012-02-10
270 reads
API Changes
Steve Jones comments on predictions that we will see new types of APIs coming in the future, especially data APIs.
2012-02-09
134 reads
Going Solo
This editorial was originally published on Mar 20, 2007. It is being republished as Steve Jones is on vacation. Today Steve Jones talks about going into business for yourself, and reminding you it's not as simple as it might seem.
2012-02-08
153 reads
Feedback and Big Data
Continuous improvement comes from measurement, analysis, and changes. Steve Jones talks about how we should be doing that with our data collection, analysis, and storage.
2012-02-07
120 reads
Insider Security Threats
The biggest security threat always seems to come from insiders and today Steve Jones talks about the need to monitor your environment.
2012-02-06
106 reads
SQL Server 2012: Creative Thinking for a Creative New Licensing Model
It seems inevitable that many customers will end up paying more to get the same features they have today, under the new SQL Server licencing model, unless they respond to Microsoft's creativity with some of their own.
2012-02-06
252 reads
2012-02-03
237 reads
Old Dog, New Tricks
Steve Jones learns a new trick working with T-SQL, and is surprised how easy it is. He recommends you work on updating your skills over time as well.
2012-02-02
567 reads
Disk Drives in the Sky
Steve Jones talks today about storage innovations from the large cloud vendors and how that can relate to your job as a database professional.
2012-02-01
118 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
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...
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