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

Daily Coping Tip

Do something playful today, just for fun

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.

Your Permanent Record

Today we have a guest editorial from Tim Mitchell as Steve is on holiday. This editorial was originally published on 19 Apr 2012.

We've all heard it, and probably all said it ourselves.  "You should [or shouldn't] do something, because it will be a part of your permanent record."

Don't skip out on class, because a bad grade will permanently taint your transcript.

Don't break the law, because a criminal conviction will haunt you forever.

Pay all of your bills on time, otherwise your credit will suffer for many years to come.

Reasonable people are cautious about all of these, taking minimal risk of staining these structured permanent records.  However, those same people often play it fast and loose when it comes to the 21st century permanent record: social media.

The First Stop

This new permanent record is quickly becoming the first metric used to evaluate others.  Consider the logistics of learning about someone you don't currently know:  You can employ a background check vendor  to verify a person's residence, criminal history, and other traditional data.  Hopefully all of these steps are still done in cases where offers of employment, child safety, and business dealings are involved.    However, all of this takes time and money to do, and nobody wants to waste time on these invasive and costly queries unless reasonably sure that the candidate/vendor/potential partner may be a good fit.  So what's the first stop to evaluate whether to pursue the relationship?  Social media, of course.  It's cheap, quick, and easy, and is often more revealing of character than whether a person has a felony conviction or got an F in a college class a decade ago.

Hiding in plain sight

So you've got your corner of cyberspace locked down - your Twitter account is protected and your Facebook content is filtered by group.  Or perhaps you're relying on security by obscurity, keeping your musings on the down low so as not to attract attention.  This means you're free to rant all you want, right?

Nope.

Social media content protection is a good thing, and allows the selective sharing of details with only certain people.  However, these protections should not be considered a license to post rants without regard to who might read them.  Let's say that an unhappy employee creates a Facebook group that includes everyone except the people he works with, and he posts his rants about his employer to that group.  Although those settings offer protection against the content being viewed directly by the excluded parties, but they could still learn of it indirectly.  Perhaps they're friends of a friend, and that friend shares details of the rant.  Further, it's not unheard of for people to fraudulently "friend" or "follow" people under a fake account just for the purposes of monitoring that person's activities.

Security by obscurity only goes so far.  Even if one privately rants on a blog, perhaps even using a pseudonym, eventually enough details could leak out to reveal the identity of the poster.  Got a password on that flaming blog post?  It could still be shared by others, or read by the fraudulent "friend" mentioned above.

 

It's true that, as a content owner, one can delete most any message posted in a blog, Tweet, or Facebook post.  But just because it's been deleted doesn't mean it's really gone.  Write an inappropriate blog post about a client, and it could still be present in blog readers (especially offline readers) even if it's later deleted or changed.  One could post and then delete an inflammatory tweet about a peer, but various services have come and gone that give others the ability to read a person's deleted tweets.  Further, social media tools make it easy to share the content of others, and a deleted tweet doesn't remove any retweets of that content by others.  And even if the deletion manages to bypass all of these content retention methods, there's still the old-fashioned screen capture, in which someone could store a digital image of wayward statements.

The bottom line is that social media does have an Undo button, but it's not a guarantee that the digital trail is gone.  And like all digital data on the Internet, social media data has the potential for sticking around for a really, really long time.

A growing number of employers report that they check an applicant's social media feeds as part of the evaluation process.

The Internet is written in ink, not pencil

Don't steal. Pay your bills. Do well in school.  And just as importantly, consider the permanence of anything you post on the Internet.

Tim Mitchell

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

 
 Featured Contents

PostgreSQL HAVING,LIMIT and FETCH Clauses

Shivayan Mukherjee from SQLServerCentral

Overview In this article, we will cover these PostgreSQL clauses with examples: HAVING, LIMIT and FETCH. In a previous article we discussed the WHERE, ORDER BY and GROUP BY  clauses. Click the link if you wish to learn about those clauses. HAVING Clause The HAVING clause works on grouped data returned by a GROUP BY. […]

Running SQL Clone on an Azure VM with Azure File Storage

Additional Articles from Redgate

How to use SQL Clone in the Azure Cloud, installing it on an Azure Virtual Machine, storing a copy of your SQL Server database as an 'image' on an Azure File Share, and then deploying multiple clones to another Azure VM or to a remote machine.

Opening JSON Data with T-SQL

Additional Articles from MSSQLTips.com

The T-SQL code samples in this tip illustrate ways of displaying JSON formatted data in SQL Server as well as how to transfer JSON formatted data to SQL Server tables.

From the SQL Server Central Blogs - Let’s Celebrate Pride by Supporting Nonprofits

todd 32417 from Todd Kleinhans

For Pride this year, we’re highlighting queer nonprofits and charities. It’s more important than ever to support the queer community and raise awareness for those who do so all...

From the SQL Server Central Blogs - Using SQL Compare for One Procedure

Steve Jones - SSC Editor from The Voice of the DBA

A customer recently was concerned about the time to run SQL Compare for a large database. They were synching with the command line, but at times they want to...

 

 Question of the Day

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

 

The Debug Parameter

I have a function in a module that I've loaded into my session. If I add the -Debug parameter to my function call, what is the value of $DebugPreference for the duration of the function call?

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)

Finding the Group

A login in SQL Server 2019 is a member of an Active Directory group. I want to know which group, this user is a member of. How do I determine this?

Answer: Run xp_logininfo with the login name

Explanation: If you run xp_loginingo with the login name, the permission path column contains the group that his login gets their rights from. If you run this with the group name, this would show a parent group only. If you run this without a parameter, all accounts are shown, but not their parent group membership. A caveat here is that the first group granted access to SQL Server is returned unless the ALL value is used for the @privilege parameter. Ref: xp_logininfo - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/xp-logininfo-transact-sql?view=sql-server-ver15

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
deadlock prevention - Hi All, I' m looking for some help in interpreting and fixing the deadlock. Recently we started seeing some deadlocks and this is one among them. Attaching the xml deadlock graph and table info. SQL Server version ================ Microsoft SQL Server 2017 (RTM-CU23) Enterprise Edition: Core-based Licensing (64-bit) Regards, Bob
SQL Server 2016 - Administration
dm_exec_connections EE - Is there a mapping column in extended event for encrypt_option in sys.dm_exec_connections . my scenario is to capture sessions that are not encrypted.
Performance Counters Missing in SQL 2016 SP2 - Hi, I'm looking for a fix to an issue where performance counters are missing from SQL 2016 (SP2). All SQL related counters are available in the OS i.e. Perfmon but only and small amount related to XTP are available in SQL itself e.g. if I run the following SELECT * FROM sys.dm_os_performance_counters It returns 57 […]
SQL Server 2016 - Development and T-SQL
suggestions on making more efficient and faster - I have a piece of code that I would like some suggestions on how to make it faster\ more efficient. The Quality and  Quality_Detail are properly Indexed, but are Large tables.   Thanks. BEGIN TRY -- Revision 1 - Added SELECT @Total_Readings = SUM(CAST(QD.Value AS float)) FROM Quality Q INNER JOIN Quality_Detail QD ON (Q.Quality_ID […]
Rounding question - If i execute query 1, i get 0.00036369128107, but if i execute query 2, I get 0.00000000000000. What i want it is I want the results (i.e non zero) but with 6 decimal places. How can i accomplish this? So, I'm looking for something like 0.000363  or 0.000364. Any idea how to accomplish this? select […]
SQL Server 2012 - T-SQL
Pivot table syntax (?) issue - Please delete post, I was looking at the goal of the query totally wrong.  
SQL Server 2019 - Administration
What's the difference with installs for Core vs Server/Cal? - Does anyone know why under MS vol licensing there are SQL 2019 Std installs for Core and different ones for Server/CAL. The filename and size is the same, what's different about these? We are converting Server/CAL to Core. Does it matter what install was used when the server was built?
SQL Server 2019 - Development
Looking for a way to change all objects at once? - Hi, I have a field in a table called prin_ball, upon doing a search for this, I would have to change it in about 158 different objects (that is jobs tables, procedures, views, and triggers). Is there anyway of doing a find and replace to change all at once. Or at least the views, tables […]
Mirror Database without Domain - Hello, I tried to make a mirror for my Demo database My Principal server is in the Domain by the name ‘server1’ (192.168.0.0/24) My Witness server is in the same domain and same network (192.168.0.0/24) with the server1 and the name is ‘server2’ My Mirror server is in another network (192.168.10.0/24), which is connected with […]
Reporting Services
Add On-Demand Subreport - This is so very easy to do in Crystal Reports.  You add subreport hidden anywhere on a report, link it to the parameters on main report and you can just double-click on it to run. In Report Builder, I've added the subreport, linked the parameters but then it runs for every group. I then set […]
SSRS 2012
Total of the row - Hi all, I have 4 columns in the report: Customer, Price, Cost, Revenue. I would like to put in the end of the report total value of each column (Price, Cost, Revenue). I clicked the right button to the appropriate column and chose to "add a total". When I select all customer values ??in the […]
Powershell
PowerShell script help - Hi Guys, I am executing a PowerShell script from SSIS (Execute Process Task). Simple script, Calling PS script and returning a variable value. The process runs successfully when I am running on my local machine. However, when I run on the server, the "SSIS Package" hangs on "Execute Process Task". When I run on my […]
Design Ideas and Questions
Vendors Database - Dear all, We are looking for web based system through which we can administer a large number of vendors from all over the world. For each vendor, we want to add information such as - country of origin - rates - team members - previous projects -etc - some information in a memo field From […]
Anything that is NOT about SQL!
Forum bug with the "like" button - I was looking at a post, specifically this one: Performance Counters Missing in SQL 2016 SP2 I thought that the answer (the first reply) was a good one, so I clicked to "like".  What I expected to happen was what I'd seen on other ones that I'd liked and that after a minute or so, […]
Events
EightKB... I'm presenting! Bring your water-cooled helmet! :D - EightKB... I'm presenting! If you've not seen this one before, it will totally blow your mind. To summarize, in one of the most heterodixic SQL presentations you're likely to ever see, I destroy the myth of Random GUID fragmentation, show how they can be used to actually prevent fragmentation, and lay waste to what people […]
 

 

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

 

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