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

Maybe Being Famous is a Bad Idea

I recently read this article by Tim Ferriss, wherein he talks about the very real dangers of becoming famous. I strongly recommend you read through it. Yeah, there’s a bit of a feel of click bait in the title, but this guy, by simply being a popular nerd and entrepreneur, brought real danger into his life, and more importantly to me, the life of his family. I strongly suggest you read through.

This resonated with me a little. No, I’m not in any way what the most generous definition would define as famous. However, within our little community, I’m somewhat well known. With that, has come a few run-ins with people that were, let’s just say, less than enjoyable. My favorites, for being the easiest to deal with, are the people who want to play “Stump the Chump” to prove they’re smarter than I am. Honestly, this one is easy, I’m not that smart and I quickly just acknowledge their obvious superiority and they wonder away lost. Much less enjoyable are the people who have decided that because I’m an expert, whatever that means, that I have to have all the answers, all the time. Further, when you tell these people “I don’t know,” they get quite visibly upset, angry, accusative, as if, I’m not merely ignorant, but actively sabotaging them. Finally, my least favorite, the people who have decided that, because they “know” me from online, I should become their personal mentor. Nope. It doesn’t work like that. These people also become extremely upset when I refuse to just surrender my time to them.

This isn’t a whine session. I know other people, especially women, transgendered, and others, have it much, much tougher than I ever will. I just wanted you to get an idea of what this stuff is like. Choosing to be a public figure means that you’re now gambling with math. What do I mean? The most interesting aspect of that article for me was how Mr. Ferriss explains why this stuff happens. When your sample size is tiny, the chances of having a bonafide crazy person who could cause you or your family harm is exceedingly small. As that sample size increases, and it does as you become more and more known, the chances go up because of simple data distribution.

That concept fascinated me as much as Mr. Ferriss’ story, and man, I am sorry for what he and his family have gone through. That has to be tough. However, the key is, we do need to think about this concept of data distribution all the time. Yeah, you’ve never had a corrupt database, but now you’re managing 1,000 instead of 10. You’ve never had a flooded data center, but you have four instead of one. On and on, we need to think about how simple data distribution can impact us, not just in our databases, but in our lives.

Oh yeah, and treat each other with kindness, respect and professionalism. Yes, it’s a little bit of work, but well worth it.

 

Grant Fritchey

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

 
 Featured Contents

DBA Team Mashup

gm.jones from SQLServerCentral

This article explains an idea for DBA team roles and responsibilities.

Using SQL Prompt Code Snippets for Repetitive Tasks

Additional Articles from Redgate

Louis Davidson discovers the joy of using SQL Prompt code snippets to remove repetition from a variety of tasks, from inserting comment headers, to creating tables, to executing useful metadata queries.

Configure SQL Server Transparent Data Encryption with PowerShell

Additional Articles from MSSQLTips.com

Transparent Data Encryption is way to protect the data in your SQL Server database. This can be setup using T-SQL, SSMS and using PowerShell.

From the SQL Server Central Blogs - SQL Server Backup and Restore Strategy Step by Step

nelsonaloor from PracticalSQLDba

Introduction:
Who is not aware of a SQL Database? It was the first business language introduced for E.F Codd’s Relational Database management system. In addition, MySQL, Oracle, Informix, Sybase, MS...

From the SQL Server Central Blogs - Why is the XLOCK table hint broken?

Daniel Janik from Confessions of a Microsoft Addict

Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources...

 

 Question of the Day

Today's question (by Kendra Little):

 

SELECT Queries and Type of Locking

SELECT queries running under the default “pessimistic” implementation of the read committed isolation level like to use…

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)

More Data

I'm compiling some data from various sources, and I have this so far.

> Avengers
  ID Age        Name
1  1  34 Black Widow
2  2  48    Iron Man

If I want to add a row that has these values:

(3,100, "Captain America")

Which of these should I choose?

Answer: Avengers <- rbind(Avengers, list(3,100, "Captain America"))

Explanation: The rbind function will add a row to a dataframe. Ref: rbind - https://statisticsglobe.com/rbind-in-r-example-vector-data-frame-fill-columns/

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 - Development
Recursive CTE vs UNION ALL in a VIEW - Hi, I'm trying to improve a VIEW which is made of several UNION ALLs, something like this: SELECT 0 as OPNR, nivdop1.nr as DOPNR, 0 as ANTL, (nivdop1.ANT) / sumniv1.SUMANT as ANT, 0 as ANTS, nivdop1.SVIND, nivrv1.nr as RVNR, nivrv1.NAVN as RVNAVN, nivrv1.TYPE, 1 as NIVEAU, 0 as PARENT, nivdop1.LINE, 0 as PLINE from DBDOPSK […]
How to preserve leading zeros with insert into -           Below is the create table script and the insert into statement. Both work fine in SSMS. However, the insert into drops my leading zeros. These are important because I have a query that I want to test out that clearly specifics certain character counts and values. I am hoping to […]
FUN only, solving a Puzzle. - /* For FUN. I like puzzles, I like T-SQL coding, I like to show off :-), so why not combine these. This project was for FUN only, but I did learn new things. Goal: Build a Sudoku solver with the minimum amount of script. (Minimum number of lines or characters). It does have to solve […]
SQL Server 2016 - Administration
Update Statistics is causing DB file to grow in always on envrionment - Hello! When I check what is causing DB files (.mdf) to grow, it is showing as Update Statistics. DB files are auto-growing by 1 GB. In about a month, it has grown by more than 10 GB. Could you please let me know the reason and how to prevent it from this?   Thanks in […]
Looking for recommendation on "cost threshold value" - H All, What is the recommended value for setting sp_configure setting "Cost Threshold For Parallelism" for an OLTP workload instead of default value 5? Regards, Sam
SQL Server 2016 - Development and T-SQL
Workaround for executing dynamic sql in function - I'm trying to create a view which dynamically generates text from input parameters. But executing dynamic sql or stored procedure is not allowed in functions. Is there a work around for this? Below is sample script for: 1. Create tables, 2.Create function, 3.Create view, 4. Expected output ----------------TABLES------------------------- IF OBJECT_ID('dbo.emp_info', 'U') IS NOT NULL DROP […]
SQL server change table query not working as expected - Hi, It looks like that a CHANGETABLE query for a particular table is not working correctly. I created a record in the bill_details table and then updated it. The record was created with sys_change_version=5000. The records was updated with sys_change_version=5001. But the following CHANGETABLE queries are confusing me and apparently returning incorrect sys_change_creation_version: select * […]
SQL 2012 - General
tempdb shrinking - Hi, Need some quick help here. I am unable to shrink tempdb files. There is lot of available free space. DBCC loginfo output We have an alert and incident opened for this and we have to close it. Other thing is that systems/storage team is not going to give us more space.   There are […]
Convert column values into single row comma separator - Team My requirement is to convert column values into single row comma separator along with single quotes. Pls help ServerName > Column Name Values in a row like below Server1 server2 server3 server44 I need a result like 'Server1,server2,server3,server44'
SQL Server 2019 - Administration
New user wants to create test DB, which menu option? - I'm new to SQL Server and using V18.4. I want to create a new database on my local machine so that I can do feasibility testing and development before moving it later. When I go to Connect / Database engine there's no option for creating a new one. What should I do? Thank you for […]
SQL Server 2019 - Development
Query to fetch quarter & year from date - Hi, I am having the following query to fetch day & year of a particular date. Need to fetch Quarter & Year also. I tried in a similar fashion. But its not working. Please help on this. DECLARE @minDate_Str NVARCHAR(30) = '01/01/2020' , @maxDate_Str NVARCHAR(30) = '31/12/2020' DECLARE @minDate DATETIME, @maxDate DATETIME SET @minDate = […]
Running VBS Script through SQL Agent Job - Hello All, Glad to have found this board. I have a VB Script that is exporting a query to an excel file.  It works perfectly when I run it from the command line.  When I create a SQL Server Agent Job to execute the same script, it fails. The type is 'Operating System (CmdExec)' and […]
T-SQL (SS2K8)
How to extract the right country info from the field? - This is very painful to me, I have a list of location and need to determine as much/close as possible(no need to be 100% accurate) for its country info, sample as below and two files attached here: one has 100 records, the other is the full list. San Diego, CA, United States Chicago, IL, United […]
Reporting Services
SSRS report rows not summing correctly - Hi, I have produced a report in report builder. During the month the report runs ok, however when the report crosses into a new month e.g. January to February, it seems to split on the number of referrals whereas it should be a total number. Within my SQL code it shows the split with the […]
General
SELECT different rows on multiple threads - I have an application which will be reading from a single table, in order to speed up the processing of each row it will run multiple threads, as soon as each thread finishes it will read again from the same table. My first approach is to select the rows assigned to an index of each […]
 

 

RSS FeedTwitter

This email has been sent to {email}. 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

 

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