Today's editorial was originally released on Jan 22, 2009. It is being re-published as Steve is on vacation.
I was reading Buck Woody's blog the other day and he had a post on Risk where he quoted Warren Buffet: "Risk comes from not knowing what you're doing." I think that's true and that's part of the reason we'd had issues in our financial markets over the last couple of years. It's also the reason that we have issues in many of the systems that we build.
Often the people building IT systems go through an extensive evaluation to determine the needs and wants of their users. It's an attempt to identify exactly what to build so that the user is pleased, a good estimation can be made, and everyone finishes the project happy.
And that almost never happens.
There are people that are better at this than others, but the overall state of the software development process is pretty poor. That means that any project you undertake, or that your customers or clients ask you to undertake is fraught with risk. I can see why there are plenty of people that don't want to hire contractors to get software built, or that our management doesn't want to start new projects with their IT departments.
I don't have a solution, and I'm not completely sure where the problems lie, but I do know that as the economy slows, people have less tolerance for risk. That means less IT projects, and potentially the need for less IT staff and contractors. Which then contributes to the slowdown of the economy as there are less people at work.
If I were working in IT or consulting right now, I would be working to lower risk as much as possible. Adopting techniques that you are confident in, learning new skills and then applying them, even in side projects, can help grow your skills, increase the chances of projects being completed that the client is happy with, and keeping you employed. Now is the time to reassess the way you work, and find ways to show that you can work with your clients to meet their needs in an efficient manner.
Efficient in their eyes, not yours.
The Voice of the DBA Podcasts
The podcast feeds are now available at sqlservercentral.mevio.com to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.
Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.
I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.
“With SQL Monitor, we can be proactive in our optimization process, instead of waiting until a customer reports a problem,” John Trumbul, Sr. Software Engineer. Optimize your servers with a free trial.
Generate realistic test data, fast
“In less than the time it took me to get my coffee, I had a database with 2 million rows of data for each of 10 tables.” Stephanie Beach, QA Manager. Try SQL Data Generator now.
"A real time saver" Andy Doyle, Head of IT Services
Andy and his team saved time by automating backup and restores with SQL Backup Pro. Find out how much time you could save. Download a free trial now.
SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact. More »
Buck Woody (blog | twitter) is often seen as one of the wise men of the SQL Server community and with... More »
Question of the Day
Today's Question (by Sergiu Ungureanu):
In SSMS open a new query and run the followings (assume the default server language is us_english):
set language 'us_english' --just to make sure
set datefirst 2
set datefirst 3
Open a new query in the same DB and run this again:
What value will it retrieve?
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
1 point in this category: @@DATEFIRST.
We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the
SQL Backup and Restore
A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.
What can change with the ALTER CERTIFICATE command? (choose 3)
change the protection of the private key to the database master key
remove the private key
change the password for the certificate encryption
Explanation: You cannot change the meta data for a certificate: the subject, or dates. However, you can remove the private key, load the private key, change the password protecting the certificate or change the protection from a password to the DMK.
multi-valued report parameter weirdness
- SSRS 2012, SQL 2012
I watched Brian Knight's video on filtering a report using a multi-valued parameter (here:[url]http://www.sqlservercentral.com/articles/Video/64369/[/url]), and after seemingly...
Help On Query
- Hi Everybody,
Create Table #sample
( Name Varchar(100),
insert into #sample values ('Vignesh',100,59,95)
insert into #sample values ('ram',23,45,33)
insert into #sample values...
String as a date format
- Hi All,
From other source I am getting a data as string format like 'Sep 6 2013'. I want to see...
- Hi All,
I have replication configured using a third party tool (power exchange). I get issues whenever i execute schema level...
- I have set Max Memory to 6 GB. But SQL Server is using only 2.9 GB
SELECT object_name, counter_name, cntr_value...
Why is my logon trigger blocking logons?
- I've created the following trigger to track logons:
Create database AuditDB
CREATE TABLE [dbo].[ServerLogonHistory](
[SystemUser] [varchar](512) NULL,
Trapping error from sp in another db
- SQL Server 2008 R2
Two computers: MachineOne and MachineTwo
Two instances of SQL server,: MachineOne.ServerOne and MachineTwo.ServerTwo
Two databases:MachineOne.ServerOne.DBOne, and Machine2.Server2.DBTwo.
On [MachineTwo].[ServerTwo].[DBTwo] I...
SELECT TOP ????
- Hello Everyone
I am a bit curious after doing some accidental testing. I was going thru someone elses code, and noticed...
variable product costing
- Not sure how to explain this but here goes...
I have a forecast of volume for a product for the year....
Quotes Identifire Default value
- Dear all
We are using SQL 2012 Express edition & Enterprise edition. As per the http://technet.microsoft.com/en-us/library/ms174393.aspx default value for Quotesidentifier is...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.