| A community of more than 1,600,000 database professionals and growing |
| | 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.comJoin 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. 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 | | 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 |
| | 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 |
|
|
|
| | | 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 » |
| Technical sessions will dive into the latest Microsoft SQL Server releases, and cover topical issues such as data compliance, protection & privacy. More » |
| 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 » |
|
|
| | 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 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. 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 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... 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... 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... 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... 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... 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... 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 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... 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... 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] |
|
|