Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Broaden your perspective: read a different source of media

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

Investing in Another's Career

Years ago my son asked me to buy him a copy of The Unincorporated Man. It's a science fiction book about the future, economics, and sentient AI systems. It's the first part of a series of four, and I've enjoyed reading them all. I highly recommend them if you like science fiction.

In any case, I was reminded of the series when I saw this article from the New Yorker about selling shares in yourself. It's part of the premise behind the Unincorporated Man, where every person is their own corporation and sells shares of themselves to finance their careers. You could sell shares in your future earnings to finance education or some other investment in your future. In return, you have to pay back that value through dividends.

I don't know if this is a good idea, and it goes a bit sideways in the books as your "shareholders" can hold sway over which jobs you take and when. They do this to maximize their return on investment, putting their interests over your desires.

While selling yourself in your early education or career is one thing, what about doing after you have had some success? The article linked above talks about this, where some entrepreneurs who have had some success decided to put all their assets and debts into a kind of fund and sell that on the stock market. They are doing this as individuals, not as a company. Essentially, you invest in their careers and their potential.

They, and others, want to bring this to others, essentially bringing venture capital to people who are early in their careers. This allows others to speculate and invest in artists, athletes, and other professionals. This might allow people who aren't rich to absorb the risk of pursuing their career goals.

It's an interesting idea, but I do worry about the influence investors might have over their investments. It's one thing to invest in a hands-off manner and hope things improve. It's quite another to attempt to manage the investment because of the number of shares you hold. Plenty of companies have learned that investors are not always willing to trust in existing management. What happens when that management is you?

I loved the book, but I don't think I'd want to follow this model. Instead, I like the Kickstarter and Indiegogo models where someone can produce a product or work of art, and others can choose to invest or not for that one project. To me, that's a better way of allowing investors to support those that want to change their lives through by pursuing their craft.  Pursue some endeavor, selling shares to fund your efforts with future dividends or perhaps access to the end result.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
  Featured Contents
SQLServerCentral Article

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

Tonie Huizer from SQLServerCentral

A look back at the PASS Data Community Summit in 8 slides from Tony Huizer.

SQLServerCentral Article

Being Agile - A Success Story

Hemandu Malhotra from SQLServerCentral

Learn how one company adopted, adapted, and learned from the Agile methodology.

External Article

New Flyway Course on Redgate University

Additional Articles from Redgate

 

Blog Post

From the SQL Server Central Blogs - How to Install SQL Server 2022

Koen Verbeeck from Koen Verbeeck

SQL Server 2022 has been released! In this blog post, I’ll walk you through how you can install the latest version of SQL Server on your machine. I’ll be...

From the SQL Server Central Blogs - Database Mirroring login attempt failed with error: ‘Connection handshake failed. An OS call failed: (80090302) 0x80090302(The function requested is not supported).

david.fowler 42596 from SQL Undercover

Here’s a quick one for today and is an issue that had me stumped for a while. It’s not one that I’d come across before and there isn’t really...

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

DML Trigger Limits

I am writing a trigger in SQL Server 2019 on a partitioned table. When certain data is inserted, I want the trigger to switch partitions on the table. Can I do this?

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

The Black Friday Sale

I noticed that Brent Ozar is having a Black Friday sale on courses. The Level 1 Bundle is quite a deal at US$395 instead of $1785.

If I wanted to determine what is the percentage savings of this bundle from the original price, which of these code lines would I run?

Answer: SELECT (1-(395/1785.0))*100

Explanation: The question asks for the percentage savings. Since this cost is way below half, we expect the savings to be above 50%. To get the decimal savings, we divide the current price by the total price. This gives us the percentage of the original cost ( as a decimal). Since this is decimal, we need to subtract this from 1, then multiply by 100 to get the percentage as a number. In this case, it's a 77% savings.

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 - Administration
Help on Ola hallengren script to take a stripped backup only secondary node - Hi All, Need some help on OLA Hallengren's backup stored procedure. We have an 2-node ALWAYS ON setup (node1- primary , node2 - secondary) The credential is setup with name "ProdBackupCredential" which has access key for storage account We have 2 databases which are around 3.5TB in size and want to take a stripped backups […]
SQL Server 2017 - Development
query help - Hi All, I have 2 tables. both tables hold db file sizes. I want the difference of sizes using tsql. As of now, I am using excel for this. During prod refresh activity to non-prod environments , we are falling short of drive spaces. So, Checking for script to find size differences using tsql. Providing […]
SQL Server 2016 - Administration
Same query returns different number of rows when run by a different login - Hello experts, Does anyone know how the same view query could return a different number of rows depending on which user is running it? I'm facing that issue now. I tried making sure the user in question has SELECT access to the tables in the view. Still different totals. What is strange is a lack […]
Update Statistics - In AG, mirroring, Log Shipping and Transactional replication if I Update statistics on primary will it run on secondary also?
SQL Server 2016 - Development and T-SQL
Help with joining tables - I would like to know whether it is possible to join 2 tables with different sorting. Ex: Table 1 has, id, date, description Table 2 has, id_det, id_mast, amt, price, dt_mev These tables are joined with table1.id = table2.id_mast I need to join the second table sorted by dt_mev descending order, so that the first […]
No PK on any tables - Need that to enable Change Tracking on SQL Server - We have a vendor application that is now out of our support. We need to extract the data from this source and move it to Snowflake via Fivetran (ETL Tool). Fivetran needs Change Tracking enabled on the source so that it can pick up only the changes since the last cycle. The issue we are […]
hex conversion -   I am trying to convert some numbers pulled from a char field. I would like to pull the 1 and 46 from the 000.001.070.000.0 to return as 1.46 . I tried a couple of things but not quite hitting the mark. create table Models ( Modelid integer, Modelnameid char(17) ); insert into Models values […]
SQL Server 2019 - Administration
Using SQL Audit to monitor index create / drop / alter events ? - I'm wanting to use SQL Audit to monitor index create / drop / alter events. I can successfully do this for tables, stored procedures, users, and other objects using DATABASE_OBJECT_CHANGE_GROUP. However, it's not including DDL operations on indexes. Anyone know if this is possible? NOTE: It is possible to use DDL triggers, but I'd rather […]
SQL server service account to choose - Hi All, We are  running on small online web based application and server is workgroup cannot create domain account. Which is best account to the SQL server -- Default it is running under "NT Service\MSSQLSERVER", can I change this is to local service account. Since our server is getting log on failure and hack as […]
Apply restore to a database with full and differential at different time. - I am trying to test to restore database from prod server to test server. It is a small database. On production server we have full backup at weekend, and then differential at weekday nights, I am using UNC drive to connect to the backup location on production. I can add files of a full backup […]
SQL Server 2019 - Development
Issues with creating a foreign key - Hello, my name is Di, and its the second time I wrote a topic for this forum, I am having some issues for writing a query where I need to create a foreign key, I already search on some places at internet, but none of then helped me, can you guys help me?
Uploading CSV into PosgreSQL - CREATE TABLE movie_data ( id SERIAL Movie_Title VARCHAR (100), Release_date VARCHAR (100), Wikipedia_URL VARCHAR (100), Genre VARCHAR (50), Director_1 VARCHAR (50), Director_2 VARCHAR (50), Cast_1 VARCHAR (100), Cast_2 VARCHAR (100), Cast_3 VARCHAR (100), Cast_4 VARCHAR (100), Cat_5 VARCHAR (100), Budget MONEY (50), Revenue MONEY (50), Primary Key (id) )
Amazon AWS and other cloud vendors
Lambda authorizer and Parameter Store dilemma - I've been using an authorizer in front of all my lambdas. The authorizer simply tries to decode the bearer token received, and if it's decoded correctly, authorizes the integration lambda to execute (and passes the user id to the event). My issue is that I realized I'm spending a lot of money in Parameter Store […]
General
SQL 2022 RTM Install - Hi there, I have previously installed SQL 2022 RC1 on a dev server and now i'm looking to upgrade this to the recently released  RTM version. I've not yet run through the install yet, however  from what i can see this may require a new SQL install or is there an in place upgrade option […]
Disaster Recovery
log shipping what if I need transaction logs backup on my primary database. - I am trying to understand  log shipping. Try to see if it can be used for our disaster recovery purpose on another location. we will only use the second location when main location has a disaster. I understand we have to stop our regular maintenance plan for transaction log backups otherwise it will be conflict. […]
 

 

RSS FeedTwitter

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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -