SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

Learn to Earn

Could you double or triple your salary by learning more technology skills? Sure, and here's a great story about someone learning PowerShell and dramatically increasing their earnings. This is a good read, looking at the journey of someone through their career and how they credit learning PowerShell for the changes in salary.

When I read this, I don't view this as PowerShell being the reason that Mr. Duffney increased his salary. Instead, I think the takeaway is that professional learning and regular skill development, focus across time, and producing results for an employer as being the primary reasons for raises. I think that the right part of the salary curve in the post, which has a steeper slope, is also likely due as much to speaking and giving back as it is to solving problems. The other lesson in this piece is that Mr. Duffney is constantly gaining skills, and looking to move forward in his career.

The world of technology is ever changing, with new platforms, additional features and changing paradigms constantly appearing. I'm sure many of you have experience with management that becomes excited by the latest buzzword or hot topic in the media, expecting that each of us can quickly build a proof of concept. Perhaps you've dealt with a boss that assumes we could buy a product or build a tool that easily solves some problem because they read about some other company in a publication having success.

Tackling a new project or technology is a challenge, but we can learn to ease the way for ourselves. We should be constantly learning something, anything that exercises our minds. One of the best talks on the topic I've seen is from Andy Warren, and I'd encourage you to check it out. Andy talks about directing your learning in an area that can help you. That may sound daunting, but I think that building the habit of regularly learning something is important in this business. We never know where our career may take us, and being accustomed to the idea of picking up some new technology and using it for a task is a skill you should practice and develop. The more often you try to improve your skills, the more comfortable you will be with the idea of tackling some new technology. In the first piece linked, we see that Mr. Duffney had a plan to become a CCNA, but over time that plan morphed into something else, as did the focus of his learning.

I certainly have been able to raise my salary by learning more about databases. This usually comes about not just from learning, but from applying that learning to my job, showing my employer (and potential future employers) that I provide lots of value for my salary. Using new skills in a valuable way is the method by which I've most often been able to translate learning into a raise.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.2MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

ADVERTISEMENT
DLM

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with Redgate DLM.

SQL Monitor

SQL Monitor - always have the answers to SQL performance issues

SQL Monitor keeps an eye on your SQL Servers 24/7, so you don't have to. It helps you proactively monitor the performance of your SQL Servers, saving you time, and makes sure you always have the answers to tough performance problems. Find out more....

SQL Search

Free SSMS add-in: SQL Search

Redgate SQL Search is a free SSMS add-in that lets you find fragments of SQL across multiple objects and multiple databases. Once installed, SQL Search appears on the SSMS toolbar, allowing you to quickly navigate to objects wherever they are on a server. Download SQL Search now.

Featured Contents

 

How to download a file from internet using SSIS

Daniel Calbimonte from SQLServerCentral.com

In this example, we will show how to download a file from internet using SSIS. More »


 

A brief history of version control

The fledgling computer industry did not invent version control. It merely adopted practices that were already well established in other industries. In part one of three, Wibke Carstensen takes a look at where it all started. More »


 

Script to find oldest open SQL Server transaction

Additional Articles from MSSQLTips.com

In this post, Eli Leiba shares a script that can be used to find the oldest open transaction and the statement that was issued. More »


 

From the SQLServerCentral Blogs - A DBA’s Developer Experience and After-Thoughts

Jeffrey Yao from SQLServerCentral Blogs

After 10+ years of a dedicated DBA, for the past 17 months, I have purposely chosen to work as a... More »


 

From the SQLServerCentral Blogs - Retrieving Query Store query performance data through sp_WhatsupQueryStore

Enrico van de Laar from SQLServerCentral Blogs

This afternoon I tweeted that a new Query Store related stored procedure I created is available: sp_WhatsupQueryStore.This blog post goes... More »

Question of the Day

Today's Question (by Steve Jones):

When I create a new message type for Service Broker conversations, what options can I specify? (choose 2)

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: Service Broker (SSSB).

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

ADVERTISEMENT

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Dashboards provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design, and filtering. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Partha Mandayam):

Which of the following stored procedures can be used to perform the same activity on every database on the instance?

Answer: sp_msforeachdb

Explanation:

The correct stored procedure is sp_msforeachdb, which is an undocumented stored procedure built into SQL Server. Here is an article which shows how to use sp_msforeachdb to find the space used by each database on a server.

Ref: The undocumented sp_MSforachdb procedure - http://weblogs.sqlteam.com/joew/archive/2008/08/27/60700.aspx


» Discuss this question and answer on the forums

Featured Script

Truncate tables with foreign keys

Roshan Joe Joseph from SQLServerCentral.com

There are two places you need to edit.

1) There is a  table variable in the begining that needs to be replaced with the tables that need to be truncated. You can replace the row constructor with a select query if required.

2) Change the ValidateOnly variable to 0 if executing directly. It is not recomended unless its tested already and no one care about those tables.

Idealy this script should be used to quickly prepare the truncate statements.

Please post a comment if there are any issues/ suggestions

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

possible combinations for all rows in table - I have a table having three column Name  Value1  Value2    Value3 A           1             2           3 B           4             5           1 C           2             3           1 I want...


SQL Server 2014 : Administration - SQL Server 2014

Only perform cleanup with Ola Hallengren's maintenance scripts - Hi, Has anyone been able to successfully use Ola Hallengren's maintenance scripts to only clean up old backups and not take...

Cant create database (.bak) file.. - we have a system for banking with sql 2014 database.. i really dont know what really happened,, but suddenly we...


SQL Server 2012 : SQL 2012 - General

Advice on how to repair significant database corruption without a recent good backup - I've identified one of our databases has significant corruption, including several extent allocation issues and SGAM allocation issues. After doing some...

TempDb File Sizing - I have inherited an infrastructure in which the tempdb is set up with multiple files, 8 all told (mdf and...

Accessing lookup tables - Hi I'm creating sql views that access lookup tables to return the full description from a table that holds a...

Authentication problem when using SSMS 2012 - We had to rebuild a user's computer. We installed SMSS 2012. We have a number of databases in SQL2008 that she...


SQL Server 2012 : SQL Server 2012 - T-SQL

can i remove loop with this and is there any other better - hi, 1) should i remove loop with follwiong query. 2) and is there any other way to do it, with out using...

TSQL query - Hello, I have a table A like below Acctnum StartDate AAA 07312016 BBB 06302016 And I am looking to create below output table...

Generate Running MAT from Quarter - Hi Gurus, I have list of quarters in my db table as below: PERIOD_QTR 2014 QUARTER 1 2014 QUARTER 2 2014 QUARTER 3 2014 QUARTER 4 2015...

A scenario where SQL Server doesn't seem to help - Hi We have a scenario, where busniess users are presented with a screen with 20+ fields. They can choose any number...


SQL Server 2008 : SQL Server 2008 - General

SSIS Excel import error - The situation is: Server A: runs alle the ssis jobs. Excel is located on a fileserver. Connection string Excel: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\Fileserver\somewehre\Excelfile.xlsx;Extended Properties="EXCEL 12.0 XML;HDR=YES"; The...


SQL Server 2008 : T-SQL (SS2K8)

Last 2 years and YTD - I am losing my mind..:) Can someone please help me with how to implement: YTD Plus the prior 2 Full Years (In...

Update Table Left Join Linkserver - Guys, Kindly help my problem, [LINKSERVER].m_product = Source Server master.dbo.m_product = Destination Server select m_id,m_name from openquery ([Linkserver],'select m_id,m_name from master.dbo.M_PRODUCT') a left join master.dbo.M_PRODUCT b on a.m_id...


SQL Server 2008 : SQL Server 2008 Administration

Can I do restore from database set to 2008 R2 compatibilty on version 2012 instance to 2008 R2 instance? - I am putting together a "recovery" plan if hardware fails, and since the business allows 120 minute recovery window, I...


Programming : Powershell

Powershell to send email with attachment only if file is full - Hi All, Hope All is Well. I am new to powershell. I am trying to attach a txt file using the following...


Data Warehousing : Integration Services

Foreach ADO.NET Schema Rowset Enumerator won't loop through Excel Workbook - Hello all, I've searched the forums and internet for this problem all to no avail. Hopefully one of you can shed...


SQL Server 2005 : SQL Server 2005 Integration Services

Automatically create column names for flat file connector - Is there a simple way to get the SSIS flat file connector to automatically use column names when the incoming...

Overwriting Excel File with SSIS package - Hi All, I have an SSIS package which exports the data to an Excel file using Excel Destination component. Could any...


SQL Server 2005 : T-SQL (SS2K5)

Records per hour within a time span - Hello, I'm trying to come up with a way to count how many records exist on a hourly basis within a...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
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.
This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com