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

Bad IT People

Today's editorial was on the 250th page of editorials on the site, in remembrance of this past weekend's 250th United States Independence Day holiday. Steve is on vacation today.

It's going to happen. Someone, somewhere, is going to deliberately compromise security and abuse their position as an administrator. Hopefully it doesn't happen at your company, but the longer you are in IT, the better chance you have of being around when a "security DR event" occurs.

This article talks about IT people going bad, and it happens more often than we hear about. Many companies don't want to disclose these types of events, and it's possible one happened in your organization already.

This is nothing new. In every industry in which I've worked there have been people that take advantage of loopholes in systems and processes to engage in criminal activity. I have had liquor stolen from bars and lumber from a warehouse. We can't prevent all of these activities, and companies know this. Usually there is a line in your accounting system that marks these losses as some cost of doing business.

As with many external hacking issues, companies are likely to try and prevent anyone from finding out about these activities outside of the company. That's not a great solution for anyone, since often these employees are let go and hired by the next company who has no idea what the person they just hired has done.

You shouldn't participate in these activities, and you ought to turn in those that do. However I know many people find that harder to do when confronted by this situation. At the very least, if you turn a blind eye, don't help prolong a bad IT person's career in this business. Don't give them any sort of recommendation, and don't include them in your personal network in any way.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Calculating Geometric Mean in Power BI

Dinesh Asanka from SQLServerCentral

Learn how to add the geometric mean in Power BI to your calculations.

External Article

SQL Server Contained Availability Groups Configuration

Additional Articles from MSSQLTips.com

In a previous tip on Orphaned User Detection for SQL Server High Availability Databases, we have seen how to identify when there are orphaned database users in an Availability Group database. Is there a way where we no longer need to worry about missing database users or different SID values between primary and secondary databases in an Availability Group?

Blog Post

From the SQL Server Central Blogs - Crawl, Walk, Run with Agentic Development of Power BI Assets

Meagan Longoria from Data Savvy

If you’ve been watching AI roll through the data community and thinking, “this seems useful, but I have no idea where to start,” this post is for you.
The post...

Blog Post

From the SQL Server Central Blogs - Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead

Tim Radney from Tim Radney - Database Professional

As a SQL Server DBA with years of experience tuning production environments, I’ve seen the same patterns repeat: nightly index maintenance jobs running for hours, consuming massive CPU and...

Storytelling with Data: Let's Practice!

Site Owners from SQLServerCentral

Influence action through data! This is not a book. It is a one-of-a-kind immersive learning experience through which you can become—or teach others to be—a powerful data storyteller.

 

 Question of the Day

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

 

TempDB Facts I

Can I set Accelerated Database Recovery on tempdb?

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)

Independence Day 2026

In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.

Answer: Apple Powerbook

Explanation: In the 1996 movie, Independence Day, Jeff Goldblum used an Apple Powerbook 5300. Ref: https://starringthecomputer.com/appearance.php?f=47&c=54

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
ALAMAT BCA KCP Ampera Tlp:08218154393 - WA:08218154393 Gedung Aurum, Jl. Ampera Raya No.37, RT.8/RW.2, Cilandak Tim., Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12560
SQL Server 2019 - Administration
ALAMAT BCA KCP Mayestik Tlp:08218154393 - WA:08218154393 Jl. Kyai Maja No.77, RT.12/RW.3, Gunung, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12120
Editorials
Is Fabric a Reliable Service or a Ripped Resource? - Comments posted to this topic are about the item Is Fabric a Reliable Service or a Ripped Resource?
I Want to Use My Brain - Comments posted to this topic are about the item I Want to Use My Brain
Spending Time in the Office - Comments posted to this topic are about the item Spending Time in the Office
What is the Cloud? - Comments posted to this topic are about the item What is the Cloud?
Article Discussions by Author
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About - Comments posted to this topic are about the item SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About, which is is not currently available on the site.
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values - Comments posted to this topic are about the item SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
BIT_COUNT I - Comments posted to this topic are about the item BIT_COUNT I
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments - Comments posted to this topic are about the item Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Multiple Values Inserted - Comments posted to this topic are about the item Multiple Values Inserted
Extreme DAX: Take your Power BI and Fabric analytics skills to the next level - Comments posted to this topic are about the item Extreme DAX: Take your Power BI and Fabric analytics skills to the next level
SQL Server 2022 - Administration
ALAMAT KONTAK BCA KCU SCBD Tlp:08218154393 - WA:08218154393 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman Floor 9, RT.5/RW.3, Senayan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12190
SQL Server 2022 - Development
locking down agent for new user on our dev machine - hi , a new user wants to be able to add sql agent jobs on our dev machine.  i stood up a db there for him and will make sure his rights are on that db only.   how can i give him rights to set up and run agent jobs but with the constraint that […]
Finding 'bad' characters - Hi All I am trying to find 'bad' characters that users might type in. My query is finding them as expected, but the results include records that I think my query should not return. Here is my query select NOTES  , ascii(left(NOTES ,1)) from trip with(nolock) where (patindex('%[^ !-~]%' collate Latin1_General_BIN, NOTES ) > 0 […]
 

 

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

 

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