SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Certifying Schools

We've debated the value of schools in technology careers plenty of times on this site. I have been torn on the value of schools, and I tend to go back and forth as to whether I'd recommend them for many people. Right now I tend to shy away from schools, mostly because I think the ROI is hard for a college. Working in technology can be a great job, one that pays well, but the cost of a degree seems high. Especially when there are plenty of ways that you can learn the same skills.

I'm not saying that university makes you a better or worse developer or IT professional. I think that really depends on the individual. Plenty of smart people go through a university curriculum and go on to build great systems and applications. The same is true for self-taught individuals that learn on the job. Ultimately, you need to take responsibility for your own career, your knowledge, and your education, both in getting started and continuing as long as you work in this field.

However, I do think that your responsibility also extends to researching and learning about the way in which you choose to learn. If that's a school, be wary of their claims. I ran across this piece about a school that was fined for their marketing. They didn't quite lie about the results from the curriculum, but they were deceiving. I think everyone should understand that finding a job can be hard in your area, especially when you are getting started. Whether you come out of a school of some sort, or you've been building your own projects. Ultimately, you need to convince someone you can do the work they need done in a competent manner at some reasonable price. 

Education has become a business, one where the profit and loss seem to be more important than the results experienced by their graduates. Some of the lack of success by schools is because students don't make enough of an effort to become good at their craft. I see plenty of evidence of that, even in professional places, where workers aren't learning to become better at their craft over time. That's something we can all do, and it's something I ask you to do on a regular basis throughout your career. However, some of the issues are inherent in modern curriculums.

As we look for more secure coding practices, ask for more testing, and still see frameworks and platforms continue to advance, I don't know if schools can keep up? I'd like to think that there are enough professional teachers that could update and alter curriculums on a regular basis, perhaps even every semester, to adapt to the changing workplace. I'd like to see more practical projects, still taught using basic, well known principles in computer science, but using modern platforms. That might change the nature of the professor in colleges, but perhaps groups of colleges should jointly develop curriculums and keep them current over time. There's still a place for teachers to learn and bring their skills to teaching, but using information that is evolving too rapidly for one person to manage.

I don't know if we'll get there, but regardless, each of you needs to look to improve your skills over time. Don't expect that what you knew last year will be good enough for next year. Continue to learn, grow, evolve, and question the ways in which you build software and systems.

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.5MB) 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
ReadyRoll

Database migrations inside Visual Studio

Feeling the pain of managing and deploying database changes manually? Redgate ReadyRoll creates SQL migration scripts you can use to version control, build and release, and automate deployments. Try it free

Redgate Hub

Register now for SQL in the City Streamed

Redgate’s popular SQL in the City Streamed virtual event takes place again this December. Wherever you are, tune in on Wednesday December 13 to watch some of the best-known speakers from the database world present the latest technologies and tools from Redgate. Register free now

Featured Contents

 

The Difference Between Rollup and Cube

Ben Richardson from SQLServerCentral.com

Learn about the fundamental differences between the ROLLUP and CUBE operators. More »


 

Free Database Unit-Testing Framework for SQL Server

Additional Articles from MSSQLTips.com

Learn how to implement an advanced and cost-effective database unit-testing framework with tSQLt in SQL Server Management Studio. More »


 

Free virtual event: SQL in the City Streamed

Technical sessions will dive into the latest Microsoft SQL Server releases, and cover topical issues such as data compliance, protection & privacy. More »


 

From the SQLServerCentral Blogs - Sessions, Temporary Objects, and the Afterlife

Solomon Rutzky from SQLServerCentral Blogs

For thousands of years theologians have offered various thoughts on the question of what happens when we die. Does some... More »


 

From the SQLServerCentral Blogs - Eliminating Hassles

CYates from SQLServerCentral Blogs

It is easy for me to fall into the trap of the “who” versus the “what”. If we are not... More »

Question of the Day

Today's Question (by Steve Jones):

I am looking to add some documentation to my database by using extended properties. I want to add a property with these parameters:

  • Property Name: IsExternalAPI
  • Property Value: 1

to the dbo.SalesOrderHeader table. I decide to run sp_addextendedproperty with this code:

 EXEC sys.sp_addextendedproperty @name = 'IsExternalAPI' , @value = '1' , @level0type = 'Table' , @level0name = 'SalesOrderHeader'; 

This doesn't work. Why not?

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: Extended Property.

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

SQL Server T-SQL Recipes

SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I want to merge two data frames. Here I have created them and gotten their values:

 > countrygdp countries gdp 1 USA 18,569,100,000,000 2 China 11,232,108,000,000 3 India 2,263,792,000,000 4 UK 2,629,188,000,000 > CountryPopulation countries Pop 1 USA 324,459,463 2 China 1,409,517,397 3 India 1,339,180,127 4 UK 66,181,585 

Now I want to combine these together into a dataframe that has 3 columns, one with Country, one with population and one with GDP.  How can I do this?

Answer: mash <- merge(CountryPopulation, countrygdp)

Explanation:

The merge() function will join two data frames together. R will try to do this with a common column, in this case countries matches, so they are combined with just a 3 column data frame.

The data.frame() function will combine the data frames, but there will be two countries columns. The c() will create a new vector. The JOIN returns an error.

Ref: merge() - click here


» Discuss this question and answer on the forums

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 2017 : SQL Server 2017 - Administration

Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb? - Hi Is there any reason why the below DBid order is maintained? Master - 1 TempDB - 2 Model - 3 MSDB - 4


SQL Server 2017 : SQL Server 2017 - Development

Convert Date to Julian Date - I need to convert a date type (2017-11-27 for example) to a Julian date. I have seen several examples where the...


SQL Server 2016 : SQL Server 2016 - Administration

CheckDB error after DB restore - Hi, I got a strange problem, I am moving DBs from old test server(SQL Server 2008 R2 SP2) to new test...

SSIS Database with lots of space - Dear all, I have a SSIS DB in my SQL Server. This database currently uses more than 10 GB of data...

Slow query - client or server issue - If seeing a client make a regular query that uses the same plan but completes in radically different times on...


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

Check for existense of database master key in "all" databases - Hi there, I'm struggling with a little query here. I'm much more a DB admin than programmer, so I really got...


SQL Server 2014 : Administration - SQL Server 2014

Logon Trigger suddenly caused spike in query time - We have a logon trigger that has been on our server for a couple months now with no issue. It...

MSSQL Always On High Availability - We are testing a third party package and they want us to configure Always On. My question is in a...

On-premises SQL server - adding secondary node to azure VM - Hi all,  Am trying to figure out how to add a secondary replica always on to my on-premises SQL server, the...

SQLServerAgent Error: The process cannot access the file because it is being used by another process - I have created the following as an automated job to run at midnight on every database server I manage:

Read TXT File - problem with importing from flat file source ssis - hi Guys, I have txt file where i have 14 million rows from Qlikview and SAP exported. Now i want to...


SQL Server 2014 : Development - SQL Server 2014

Query Optimization Advice - Hi All, So I'm faced with the need to optimize a pretty hefty query, as it's beentaking extremely long to run....

Resolving many to many linkage - USE GO /****** Object: Table .  Script Date: 11/29/2017 9:52:07 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE .(  &nbs

Choosing the Birthday of a Customer by month? - CREATE TABLE birthdays(  cust_id  INTEGER NOT NULL PRIMARY KEY ,cust_fname NVARCHAR(50) NOT NULL ,cust_lname NVARCHAR(50) NOT NULL ,cust_dob DATETIME NOT NULL ); INSERT...


SQL Server 2012 : SQL 2012 - General

SSIS Data Flow Items tab missing in the SSDT 2010 for SSIS 2012 - Hi, I need to see inside a SSIS 2012 project a new SSIS installed component, but in the SSDT 2010 I...


SQL Server 2012 : SQL Server 2012 - T-SQL

Executing Stored Procedure against a linked server - Is it possible to run a stored procedure against Server B if the stored procedure only exists on Server  A? I...

Strange Month number value in table of Dates - I've been tasked with writing a script to populate a Dates table.  This contains a row for every date in...


SQL Server 2008 : SQL Server 2008 - General

SQL can't start . Please kindly help - Hi All I have a problem with my server , SQL can't start up. when I check into error log : 2017-11-29 18:56:15.03 Server  SQL...


Data Warehousing : Integration Services

Unzip in ForEach loop - Hi I'm having problems parsing the correct expression for a Process Task I'm attempting to use a ForEach loop to process...


SQL Server 7,2000 : Administration

connection memory usage - Hi all How to I determine the total memory usage for all of my database user connections? I realise that sql*server...

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