Working in technology usually implies that have a need to constantly challenge ourselves to learn new skills and improve our existing abilities to get work done. When I started as a DBA, I could work within SQL Server, writing T-SQL, making backups, and managing security. As the product has evolved, I've needed to learn more about Active Directory to troubleshoot security, I've been called upon to cluster machines and implement replication; I've had to teach myself about ETL processes. There are all sorts of areas in which I've found it important to develop some expertise.
However time is short. With family, with work, with commitments in the rest of my life, how do I find time to work on improving my career skills while balancing my other commitments? Most of my learning time has been spent at work, slipping in learning time during a project or spending lunches educating myself, but I've also had to spend some time at night, practicing skills or reading about the intricacies of some feature.
Andy Warren has estimated that it really takes around 100 hours to develop some level of competence with a new skill. That's 100 hours in a year, which doesn't sound like a lot, but dedicating two hours a week to your career can be challenging. It's much less than the 10,000 estimate for expertise, which is good since most of us can't spare that much time to become an expert.
However is 100 hours too many? There was a TED talk I watched recently that noted you could learn a new skill, at an acceptable level, in 20 hours. I'm skeptical that this is true, and I'd point out that there is prep time to analyze a skill, learn something about it, and then build the plan to learn. Those items alone could take much more than 20 hours.
I'm not sure what a good level is, but I'm thinking to try this in my life in some area and see what 20 hours gets me. I'm also on a Powershell Challenge, which will probably end up being close to 30 hours, but I'll see how comfortable I am with the skill after that time.
Do you think you could learn something like Powershell in 20 hours?
"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.
16 essential SQL Server tools
In one installer, the award-winning SQL Toolbelt contains everything you need to work with SQL Server. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download a free trial.
Try new SQL Monitor Hosted
Get real-time server performance updates and instant access to the data you need to fix the problem, whilst we take care of the monitoring software. Get started now.
SQL's windowing functions are surprisingly versatile, and allow us to cut out all those self-joins and explicit cursors. Joe Celko explains how they are used, and shows a few tricks such as calculating deltas in a time series, and filling in gaps. More »
Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.
bulk export of xml column
- with reference to http://technet.microsoft.com/en-us/library/ms191184.aspx
res\db_features\bulk_import\examples_of_bulk>bcp practise..xTable out a-wn_x.out
-x -T -S user-PC\sqlexpress
Enter the file storage type of field xCol [nvarchar(max)]: varybin
Update values like Vlookup
I have a table as per below.
CREATE TABLE #TEMP
ID NVARCHAR(200) NOT NULL,
SIMNO NVARCHAR(200) NULL,
IMEI NVARCHAR(200) NULL
iNSERT INTO #TEMP VALUES ('0412345678','0412345678','013275009174916')...
Concat columns in Where clause
- Hello everyone,
I'm searching to see how performance works on columns concat in the where clause.
What are the search...
- Hi all,
I've had a trawl through the forum but can't find anything that will help although I'm sure this isn't...
Getting Current Stock Report
- Hi All,
I have a table for maintaining stocks as follows,
InventoryId - bigint
TransactionDate - datetime
InwardId - int
ProductId - int
InventoryStatus - int (0 - Available, 1 - Sold)
ReferenceNo - nvarchar(50)
Select between dates in another table.
I have these two queries:
select count(*) from dbo.dutyrostershift where shifttype = 1
Select CONVERT(datetime,A.start-36163,105) AS startdate,Convert(datetime,A.fld_end-36163,105) as enddate from dbo.vacation A...
Error with packages in 64-bit environment
- Version information on my computer :
Visual Studio 2005 Professional, Version 8.0.50727.42 (RTM.050727-4200)
.NET Framework 2.0.50727 SP2
Integration Services Version 9.00.2047.00
SQL Server version...
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.