A Billion Transactions
A billion transactions is a lot of activity on your database, however Steve Jones thinks more and more of us might see this on a regular basis. Microsoft's facilities group shows this to be the case.
2013-04-22
233 reads
Editorials
Excuses Execrating Excel
A bad workman always blames his tools. So does the entire western media, it seems, as poor old Excel gets it in the neck for some appalling calculation errors in economic papers.
2013-04-22
220 reads
Upgrading to 2012
Are many people upgrading to SQL Server 2012? Is it worth the cost for your company for any existing instances? Steve Jones asks the question this week.
2013-04-19
430 reads
Asking for Interview Questions
When someone asks for interview questions on the web, it seems many people are upset. But should they be? Steve Jones points out there are different sides to this.
2013-04-18
403 reads
The Patch Wild, Wild West
Microsoft might be changing their patching process for applications. This has Steve Jones worried they may move towards an Apple/iOS like model, which would not be good for server systems.
2013-04-17
171 reads
Don't Be a Ghost
If you want to further your career, you can't be a ghost. Steve Jones talks about the ways in which so many people might end up hurting their careers by trying to keep their lives too private.
2013-04-16
303 reads
Bad Data Costs Lives
Either data is right or it is wrong. There is no in-between. Phil Factor examines a recent scandal that hit the health care system in the UK to highlight why it's so important that we, as data professionals, ensure responsible use of data and respect for data quality.
2013-04-15
206 reads
Modeling the Earth
Microsoft Research has a variety of interesting projects underway, including one to try and model the Earth. Many of these involve lots of data in some way, and would be interesting projects to work on, according to Steve Jones.
2013-04-15
116 reads
The DBA Office
The environment in which we work can have an affect on the way in which we work. Steve Jones asks today if you have a preference for your environment.
2013-04-12
227 reads
Don't Accept Defaults
All software has default values, some of which might not suit your environment. This is especially true with regards to security settings.
2013-04-11
97 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers