| A community of more than 1,600,000 database professionals and growing |
| | Learn More than Technology I've been lucky and successful in life in many ways. Certainly I've worked hard, may long days and nights, but plenty of others have as well. In fact, there are plenty of people I know that have worked more hours, but been less successful. Conversely, I know some that have worked much less and been more successful. It's hard to know what the best way is for each of us to examine how to move forward in life, but it's also not really helpful to compare yourself with others as a measurement. What I'd note you should do is decide if you think you're becoming more or less successful and find your own path. This could mean very different things to different people, and that's fine. I don't want to live other people's lives. I want to live my own, learning from positive and negative things that happen to others, but following the path that best suits my wife and me. I include my wife because we're a partnership. We decided to spend our lives together, and that means we work with each other, sharing success and sacrifice, making joint decisions. It's worked out well for us, and I am looking forward to the next few decades of continuing on that path. I got inspired to write this by Troy Hunt's 10 Personal Finance Lessons for Technology Professionals, which is better written than what I'd do if i wrote it. My wife and I haven't been as focused as Troy has, but we've gone through a similar set of thoughts and execution in our careers. We were less money focused, and we don't live on the Gold Coast, but we're pretty happy with where we are. We've made a few real estate investments, along with some traditional ones, and I think we've been fairly successful. What inspired me, however, isn't the advice about how to make money as much as the need to understand what money means to you and the implications of your choices. I do think money is necessary, at least some to live in the US. I also think money can make life better, but you have to learn to enjoy life first. Money should help you with things you enjoy, not make you buy things you think you (or others) will enjoy. However, to ensure you can make the choices you want to, learning a bit about money is useful. Most of us don't get good financial literacy, and more importantly, we don't think about what money really means. It's a representation of time, and your time is the most valuable asset you have. I don't advocate that everyone try to be rich, or retire at 40, or save every penny/pence/shilling/lira/yen and live like a pauper. Enjoy your life as you live it and learn to appreciate the small things that touch your days. Along the way, learn a bit about money so you can make choices. Develop a hobby outside of work, and enjoy the moments with friends and family. Life is short. Try to actively live to enjoy it. 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 | | Benchmark your Database DevOps maturity level Get a better understanding of how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers. Complete the Database DevOps Maturity Assessment |
| | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
|
|
|
| | | Additional Articles from Brent Ozar Unlimited Blog Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version? More » |
| Microsoft MVP Steve Jones provides a simple proof-of-concept workflow that allows organizations to provision full sized databases for developers, using production like data that has been masked automatically as a part of the provisioning process. More » |
| SQLEspresso from SQLServerCentral Blogs A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule... More » |
| WaterOx from SQLServerCentral Blogs In general, SQL Server TDE certificates will expire at some point. In SQL Server, if we have setup TDE using... More » |
|
|
| | Today's Question (by Steve Jones): On SQL Server 2017, I have a brand new database with no objects. I run this code: CREATE PROCEDURE GetOne AS SELECT 1 GO CREATE PROCEDURE GetOne;2 AS SELECT 2 GO I now decide to query sys.objects with this code. How many rows are returned? SELECT * FROM sys.objects AS o WHERE o.type = 'P' |
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: Stored Procedures. 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 | Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and securely. Your organization’s increased ability to respond to rapidly changing business scenarios will build competitive advantage in an increasingly crowded and competitive global marketplace. With a focus on new applications and modern database architecture, this edition illustrates that dynamic SQL continues to evolve and be a valuable tool for administration, performance optimization, and analytics. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I run this code on SQL Server 2017: CREATE TABLE dbo.SalesOrderHeader ( OrderKey TINYINT IDENTITY(1, 1) , CustomerName VARCHAR(30) ) GO INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Andy') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Brian') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Steve') GO This adds three rows. Now I run this: SELECT IDENT_INCR('dbo.SalesOrderHeader') What is returned? Answer: 1 Explanation: The IDENT_INCR() function returns the identity increment for a table with an identity property. This is set in the table definition as 1. The identity value isn't returned here. Ref: IDENT_INCR() - 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. Best way to track "errors" in Stored Procedure - Hi Guys, I need advice. I have almost 30 Update statements with different logic in one stored procedure. If I... What it means to atomize values in 1st normal form - Suppose we have the following table. We have everything for the address packed into one cell. Also, we have two... Any video courses that teach Execution Plans? - Hi, I am aware that Redgate has a free ebook that explains execution plans. I was wondering if there were video ... When does SQL decide to load all of an index in to memory? - We're having a bit of a performance issue with one of our tables, which seems to be behaving in a... Reporting Services Migration Problems - I am trying to get SSRS running on Server #2, copied from Server #1 What I've done so far. - Backup Reports... HA VS DR - What is the difference between high availability and disaster recovery ? Also proxy and credentials upgrade to 2016 causing performance problems - Hi all Experts, We have strange problem (at least for our case), we have database in 2012 which was restored... Backup and log - Hello, since 2 years, I manage a database with a lot of transactions Recovery mode is Full Full backup once a week ... Sort already comma separated list - Hi I have values like this in a column which basically is the exact same thing if sorted . ORM; Easy (I think) mdf file size question - So is there any advantage to splitting up a data file that is getting close to 2TB if all the... Tuning Query In Stored Procedure - Below table contains five millions of records. My Table Structure CREATE TABLE .( (50) NOT NULL, (2) NOT NULL, ... Remove duplicate substrings from string - Hello experts, I have a problem I'd appreciate advice on please. I'm asked to determine distinct combinations of sequences of values... msdb.dbo.backupset table on standby server - I am new to SQL server.. we are generating backup report on primary server using msdb.dbo.backupset table. But in backupset table,... Convert string MMDDYYYY to a date - First I will say I've found a couple different SQL solutions for this, I'm asking if there is a better... Convert string nvarchar(6) with format MMM-YY to date - Hello, I have a column that is an nvarchar(6) and the data in the column is formatted like this: Dec-15 Jan-16 Feb-16 I'd like to... How to insert multiple records from fields in select record - I am trying to take results from multiple fields from single rows that are not null and put them in... Output of stored procedure to a txt file?? - Hello, I am trying to write the output of a stored procedure to a txt file. I am unable to... Automaticaly Build and Deploy SSIS packages. - Hi we're trying to automatically build and deploy an SSIS package up to the Integration Services Catalogue when we check changes... sql express 2005 database has dissapeared after restore. - This is live, old I know, but I really need advice. So I had a corrupt db. Backups all screwed. So... How can I export all table names plus column names from sql? - Hi, I have to list all the tables in my database, plus the column names in each, and how they... |
|
| 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 |
|
|