| A community of more than 1,600,000 database professionals and growing |
| | Quitting Over Training I saw a tweet awhile back from Alex Yates that said this: "If your employer won't provide training because they are afraid you'll become more employable and get a job somewhere else... it's time to quit. Immediately." That's a strong statement, but one that I tend to lean towards rather than away from. I'll disagree slightly because I don't think that I should recommend anyone leave their job right now. You are all adults, and you should be able to decide when it's time to leave, or what your particular circumstances dictate. Many of us have bills to pay, and we may not have a partner that works. Sometimes we have to just deal with a poor situation for some period of time. I will agree with Alex that if your employer doesn't believe in you, then that's a problem. I'll argue that if you don't believe in yourself and make strides to improve your skills as well, that's a problem as well. I've usually tried to invest in myself, through both time and money, and I expect my employer to do the same. Often showing some of my own initiative helps convince them that they should match, or exceed, my own investment. After all, they should get lots of the immediate benefits from any learning. I've worked for companies that didn't like to fund any training. In those cases, I usually make plans to move on to another employer. I've had companies that limited training to something that I might get every 2-3 years. That's not the worst situation, but you will have to decide how important this is for you. I try to work with companies, understanding that spending $5k in training for every employee + time out of the office may not be feasible. At the same time, spending $0 doesn't seem reasonable. At least, it's not reasonable if there isn't a lot of internal training and opportunity to experiment and learn new skills. I say this often when I speak, but I'll repeat it here. Your career is in your hands. An employer ought to assist you, and many do, but it's up to you to request training, apply yourself to learn more, invest in yourself, and ultimately take advantage of opportunity. Build a plan, define measurables, and be ready to prove that you can apply some of the training in the months after you complete it. A week at a class or conference isn't a vacation, and if you treat it as such, I can understand why a company might be reluctant to make an effort to train you again. Time is a valuable commodity for all of us, and we shouldn't be wasting it when we're trying to grow our career. Focus, learn something, and share with others. You might be surprised as the benefits that come from this, including additional investment in you by your current employer. 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 ( 3.4MB) 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 | | What’s the top challenge faced by SQL Server professionals in 2018? Learn how 626 SQL Server professionals monitor their estates in our new report on the State of SQL Server Monitoring. Discover the challenges currently facing the industry, and what is coming next. Download your free copy of the report |
| | Redgate University Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers. Start Learning |
|
|
|
| | | Additional Articles from MSSQLTips.com In this tip we look at how to schedule SQL Server tasks on Linux servers using Cron. More » |
| With the recent regulatory pressures such as GDPR, being able to know what type of data we are holding onto within our business became a bigger challenge. At Redgate, we have been exploring ways to make this easier for our heavy SQL Server users and eliminate the problems around this area by making it easy to efficiently highlight where you are holding Personally Identifiable Information (PII) among your SQL Server estate. More » |
| Anthony Nocentino from SQLServerCentral Blogs In this blog post we’re going to revisit how SQL Server on Linux responds to external memory pressure. This is... More » |
| Rayis Imayev from SQLServerCentral Blogs (2018-Oct-15) Working with Azure Data Factory you always tend to compare its functionality with well established ETL packages in SSIS. Data... More » |
|
|
| | Today's Question (by Steve Jones): I have this table: CREATE TABLE UserConfig ( UserConfigKey INT IDENTITY(1,1) NOT NULL CONSTRAINT UserConfigPK PRIMARY KEY , UserID INT , IsActive BIT SPARSE , IsSubscriber BIT SPARSE , DefaultQuantity INT SPARSE , Options XML COLUMN_SET FOR ALL_SPARSE_COLUMNS ) GO I want to insert a new row and use this statement: INSERT dbo.UserConfig ( UserID , Options ) VALUES (9, '<IsActive>3</IsActive><IsSubscriber>0</IsSubscriber>') GO What happens? |
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: Column Sets. 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 | Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I need to create a schema for my developers to do some work under. I want to ensure the schema is owned by the dbo, in case I move to new projects. What command do I add to this script to replace the XXXX? CREATE SCHEMA Developers XXXX dbo Answer: AUTHORIZATION Explanation: To set the ownership of a schema, use the AUTHORIZATION command. Ref: CREATE SCHEMA - click here » Discuss this question and answer on the forums |
|
|
| | Ronald Hensbergen from SQLServerCentral.com As a DBA, you might get in the situation where someone has disabled a foreign key constraint to insert or delete data, but with enabling the constraint again, the WITH CHECK option wasn't used. Brent Ozar described this situation already a few years ago: https://www.brentozar.com/blitz/foreign-key-trusted/. As he mentioned, the problem is that for these untrusted constraints aren't used in query plans. This usually leads to a major performance impact. I too had this situation, but then the problem is: how to detect easily of the referential integrity is still in place or not? And if so, how to enable the constraint? Especially if you're working with many tables, it's not easy to resolve this issue. Happily, all the information is stored in system tables, so I wrote a query to create the code to see if the referential integrity is still good, and also code to enable the constraint again with the WITH CHECK. This can then be encapsulated in a loop like a cursor or something. I created this code for SQL Server 2016. The concatenation I took from the chosen answer in https://stackoverflow.com/questions/194852/how-to-concatenate-text-from-multiple-rows-into-a-single-text-string-in-sql-serv. Beware: for large tables, enabling the constraint can take quite a while, so execute this part during a time window where locks with a long duration won't mess up other activities (too much). I hope you like it! 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. If I remove all server level permissions from public how do I set up new Logins - Hi, There has been a proposal to remove all server level permissions to the public role as part of a compliance... check date range for previous year within same table - hi, I have following sample data set: SaleID SaleMarkdown StartDate(yyyymmdd) EndDate(yyyymmdd) SaleInPreviousYear previousyearsaleID 1 20% &nb EBCDIC file is getting loaded with all special characters in my table - Hi, I have an EBCDIC file and I am trying to load it using SSIS. I created a flat file connection manager,... CheckDB not completing because of resource errors - I am testing a new SQL 2016 Std build in AWS. Part of the testing includes running checkdb on all... BACKUPTHREAD wait type - Hi, I'm trying to restore on a SQL Server instance a backup that exists on a different network share (i.e., \\server\share\mybackup.bak).... Login packet issue - Hi, Aware this has been posted before by others in one form or another but I've tried the recommended solutions... increment months for two dates combination as a new label column - I have to calculate a new Label column for each combination of Start Date and End Date. If start Date... Deleting data from a table ... quickly - I'm working on a system which stores what you might call "temporary working data" in a number of database tables.... SQL Procedure runs fast in Management Studio but slow called from VB. - First time running up against this. I have a vb app calling a stored procedure with 2 parameters. I changed... index scan where seek expected - On a SQL 2016 instance I have a large table with dozens of columns including: COLA INT COLB BIT and nonclustered index: (COLA... Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an... Loop Thru XML Tags with Cursor and Insert Parent/Child data into a table. - So, here's the XML.. I am relying on order of presence in file. <?xml version="1.0"?> <ROOT> <Policy> <PolicyNumber>HO00000001</PolicyNumber> <TransactionType>NB</TransactionType>   Display 'blank' cell when it is null. - The data type of the column is decimal(9,2). I wanted an empty cell to be displayed when the output is... looping through all databases to find dependencies (cursor) - I want to have a go-to query that finds all dependencies of an object, across all databases (without requiring any permanent object like a... Find tables with records in multible DB's - Hi all! On my production SQL server, I have + 300 databases, whereof app. 50 has the same structure, and has a... badly perfoming query when IS NOT NULL used in the WHERE clause - I have a query that returns results in under a second (115 rows) if I use IS NULL in the WHERE clause,... Anyone see a problem with this? - I asked a developer to write a simple query against this table of mine. He looked at me and said... relational calculus - I'm solving a problem using tuple relational calculus ( TRC) in DBMS. Problem Find the name of all the employees who work for... Find and replace third occurrence of the string - I want to find the third occurrence of the 'o' and replace with 'A' create table store ( productid int, productdescription... Excel source output - E-2 values - Hi, I am using an Excel source to upload data to Netezza. However, due to some weird reason the excel source... |
|
| 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|