Measurements
"If you cannot measure something, you cannot improve it." - Lord Kelvin. That quote and a blog about it inspired today's editorial.
2011-07-07
156 reads
Editorials
We Need a DBA Boot Camp
Today we have a guest editorial from Andy Warren. We often find that many DBAs fall into the job as accidental DBAs, and need more training. Is a boot camp the way to get them up to speed quickly?
2011-07-06
234 reads
How Much Is It Worth?
This editorial was originally published on Nov 21, 2005. It is being re-run today as Steve is on holiday. How much money is it worth to compromise your ethics? Steve Jones asks today as many companies around the world seem to be doing that.
2011-07-05
114 reads
Cloud Barriers
I'd like to hear the thoughts of DBAs out there on Windows and SQL Azure, and the prospects of moving applications and databases into the clouds. How many DBAs work for companies that have done it or are seriously considering it? What are the deepest concerns?
2011-07-04
81 reads
Independence Day 2011
A holiday in the US has most people away from work. Steve Jones leaves you a few thoughts and humor from his vacation.
2011-07-04
78 reads
Sabbaticals
This editorial was originally published on Oct 25, 2005. Steve Jones talks about the idea of a sabbatical from work and the problems that might ensue if you haven't properly planned it.
2011-07-01
90 reads
A Little Interviewing Advice
This editorial was originally published on October 20, 2005. It is being reprinted as Steve is on vacation. I know there was a great uproar over the interview piece at the beginning of this week and I received lots of opinions on various parts of the article, good and bad to go over. But one […]
2011-06-30
323 reads
Changing the Oil In Your Server
Today we have a guest editorial from Andy Warren. We have regular maintenance that needs to be performed on our cars, and also regular maintenance that needs to be done on our servers. Andy points out that companies need to understand this and make sure these regular activities are performed.
2011-06-29
227 reads
Cost of the Cloud
The cloud should bring with it lower costs, and better efficiency, but that's not necessarily the way things are. Microsoft has a great internal project that costs out the cloud for their departments, and this would be a great addition to the public or private clouds.
2011-06-27
156 reads
Where Do You Go for Authoritative SQL Server Best Practices?
There is now a vast amount of SQL Server information and 'best practice' advice available on the Internet, in the form of innumerable blogs, community sites and forums. Finding an answer to your question is relatively easy, but finding the right, or best, answer is harder than ever.
2011-06-27
455 reads
Blogs
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Flying Halfway Around the World to Australia
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
Dealing with Change – Two Resources
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Forums
Pivot query
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Table with FK(s) to other columns within the table
Hello All, I have recently joined a project, where main, core tables with millions...
Question of the Day
Using Table Hints in a Query
How many table hints can I include in a query?
See possible answers