| A community of more than 1,600,000 database professionals and growing |
| | Back Yourself Up... Today we have a guest editorial as Steve is out of the office. Systems fail. Hardware, software, networks - they all fail. Hence the importance of backups. Backups may not be perfect, and they may not be up to the very last millisecond. But for anything important enough that is susceptible to loss, there is an appropriate backup given the resources at hand: money, technical ability, tolerance for failure etc. The intention is to minimize the impact of the failing piece on the rest of the system. As software professionals, we diligently create backups for the systems in our charge. But do we also apply this approach to ourselves? Aren't we as individuals parts of larger systems (family, friends, workplace)? And aren't we also susceptible to failure (loss of health, accidents, death)? And if we care about these systems, shouldn't we work towards minimizing the impact of the loss of ourselves on these systems? Of course you can't back yourself up to restore into another body, science fiction notwithstanding. But given the resources at hand, what is the best you can do to minimize the loss? Let's consider a few aspects of this potential loss. Your Presence: Unfortunately, there isn't much I know of that will help mitigate this. As little as it is, perhaps make the effort to create great memories with the ones you love. When they look back, maybe the first things that come to mind are those happy memories, which may offer some comfort. This is a difficult one to think about and write about, because there aren't very many good answers. Logistical: Think of the things you do, and the knowledge you possess about those things, that nobody else does. To minimize loss impact, a good place to start is to document everything important you do. For instance, if you take care of all the banking and financial operations in your home, it might be a good idea to write down the details of these for your spouse: websites, userids, account numbers, passwords, locations of important documents, summaries of important transactions, etc. Also tell them where to find this document in your absence, and go over it with them so you can answer any questions or clarify things that might have seemed obvious to you. Ideally, you would have them do these functions themselves periodically so they don't even need the document. But as my own experience shows, this is easier said than done. Hence the document. Financial: if you are a primary or considerable income earner for your family, what happens when that income stream disappears? Can your dependents carry on without much financial setback? Will they be able to maintain their current lifestyles, assets, education, housing, food, transportation etc? Short term, a life insurance policy might help minimize these setbacks. Ideally, it would provide enough coverage that your income stream could be replaced with little impact. Long term, perhaps converting active income to passive income or portfolio income might be an option to look into. These types of income streams do not require you to actively work to generate them. To summarize, the closest semblance of a backup of "you", given the resources at hand, will not be perfect and will not replace you. It will, however, help mitigate the loss. If you care about the systems that depend on you, it is a worthwhile investment. Hakim Ali from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | | Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial |
|
|
|
| | | Hugo Kornelis from SQLServerCentral.com Hugo Kornelis continues his exploration of the types of queries that can end up running in row mode when accessing columnstore indexes. He demonstrates how careful rewriting can often yield a logically equivalent query that runs in batch mode instead, and therefore gains the best possible performance benefit. More » |
| SQL Server Central editor Steve Jones is joined by acclaimed author and researcher Gene Kim to discuss the latest in all things DevOps. More » |
| Additional Articles from MSSQLTips.com In a typical data warehousing application, quite often during the ETL cycle you need to perform INSERT, UPDATE and DELETE operations on a TARGET table by matching the records from the SOURCE table. More » |
| Roland Alexander STL from SQLServerCentral Blogs “Moneyball” has been a thing for a while now. It’s shorthand for the application of quantitative data analysis to the... More » |
| SQLEspresso from SQLServerCentral Blogs Microsoft gives you two purchasing models for your Azure SQL Databases (SQL DB), a DTU and a vCore based model... More » |
|
|
| | Today's Question (by Steve Jones): I have this code that creates a list in the Python REPL: >>> Teams = ["Broncos", "Chiefs", "Raiders", "Chargers"] What is the result from this code? >>> Teams[0: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: Python. 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 | T-SQL Querying (Developer Reference) Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): When I add a column set to this table, what data type should I choose? 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 ____ COLUMN_SET FOR ALL_SPARSE_COLUMNS ) Answer: xml Explanation: The column set column is an XML column, so that is the data type needed. Ref: User Column Sets - 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. SSIS Package run from Visual Studio but fails from SQL Server Agent with the Error: Exception has been thrown by the target of an Invocation. - HI, I have an SSIS Package which goes to a website using http connection and gets a zip file and loads... Can't Get BULK INSERT TO ERROR!!! - Hello guy, I was testing my script for bulk insert. But i can't get the rows to error out and... Need to write query with conditioms - update tab1.ut_prc with tab2.prcup of seqnum in which amtperact fall under. for example if you take act1003, amtperact 76 fall under... Managing a large SQL estate ? - Hi, not 2016 specific but cant see where else to ask it and we have a lot of 2016, and... ERD documentation tool, any recommendations - I'm looking for some software to create an ERD by reverse engineering tables (by schema) using both primary/foreign keys as... Fiscal Year Partition with Fact tables - Hi, I want to implement fact table to hold current and last 2 fiscal year data and thought to implement partition function... How to Generate a common unique column for multiple views - I created 3 different views and I need a common column to join these 3 views. There is an AMOUNT... How to get a multiple select to populate into a temp table? - I've exhausted everything I have.. I've been trying things for an entire week maybe a week and a half.... I... Searching for a SHA 256 example. - Hello All, For educational purposes I am seeking for a HASH algoritmn to be shown and used in SSMS. During an introduction... 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... When is too many columns too many columns? - I know you can have some insane number of columns in SQL server... but just because you could, doesn't mean... T-SQL formatting tool - Does anyone know of a t-sql formatting tool that is compatible with SSMS 2016 and will format BACKUP/RESTORE statements? I've got... Mirroring - Working on setting up SQL Server mirroring. Following are the steps I am thinking to do.. Take Full Backup and Transaction... On-Priemise to SQL Azure migration - How to migrate domain users - We are planning to migrate an on-premise test db to sql azure environment(not azure VM). How can I migrate domain... Dynamically pivot a table - Hello, Seeking help to dynamically pivot a table using a date field in a table. Current structure acctid_prodId dates 123asd 1/1/2018 123asd 2/1/2018 123asd 3/1/2018 123asd 4/1/2018 123asd 5/1/2018 123asd  how can I have a failed job notification be emailed to more than one person - Hi, in SQL Server, how can I have a failed job notification be emailed to more than one person? Thank you Separating SSIS Datetime - Hi Experts, I have a text file to load to a database.The file has a column Datetime 2013-07-16 15:05:43 and in... Get databasename for a particular user - Hi all, I have a username I need to script and replicate to UAT, but no indication of which DB... Need help Insert and Update in Single Statement - I've tables as follow CREATE TABLE .( IDENTITY(-2147483648,1) NOT NULL, NULL, (5) NULL, [group_2Dig SQL Server 2016 SP1 (Azure IaaS) slower than SQL 2008 SP2 on premise - I have an issue with a stored proc that uses a cursor (yes, I KNOW THIS ISN'T GOOD) however it... |
|
| 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 |
|
|