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

It's Never Just One Thing

I was reading about a recent security failure when I saw the phrase "...a series of missed opportunities...". Made me giggle and say to myself "No Kidding Kojak" except I used Sherlock Holmes and a different word.

Fact is, security failures, and hey, let's face it, process failures, almost never come down to a single cause. "If only we had done one thing right, we wouldn't have had a meltdown." That's not reality. Reality is that these kinds of failures, breaches, hacks, collapses, consist of a combination of factors, every time. Which makes it easy to simply throw up your hands, shout "Yeet!", and start deploying code. Yet, down that path lies the next breach. For example, McDonalds had a breach where a login had a password of '123456' (come on, everyone knows to add '78' to that to make it truly secure ) combined with that login having elevated privileges in the system (and there were actually several other problems exposed as well). The login was old. The password hadn't been changed for years. Would just updating the password have fixed the problem? No. Additional issues lead to the full breach.

As technologists, we can't look at a single factor, good password policy for example, and say, "We're done." How about the firewall? Any holes there? Do we even have a firewall? Are we following least privilege principals, or is it just easier to make everyone the superuser? Sure does speed up deployments. And hacks. Further, do we have a way to review, test, and validate what we're doing when it comes to security? If not, shouldn't we?

I'm not saying if you do these things you'll never, ever, get hacked (metric tons of hacks come from social engineering, so you have to train your people too). The goal is to do as much as you realistically can, to harden your target. Just as a single bad choice is not what leads to the hack, a single good choice won't prevent it. We have to do a whole lot of work.

Now, I'm off to update my passwords. I'm going to add '9' to make them even more secure.

Grant Fritchey

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

 
 
 Featured Contents
SQLServerCentral Article

Calculating Min-Max Normalization in PowerBI

Dinesh Asanka from SQLServerCentral

Learn how to normalize values in Power BI to allow you to compare disparate different data.

External Article

Simple way to export SQL Server data to Text Files

Additional Articles from MSSQLTips.com

Since the transition from DTS to SSIS, I have found myself looking for alternative ways to do simple tasks such as exporting data from SQL Server into text files. SSIS is a far more powerful tool than DTS, but I generally try to stay away from it for simple operations. With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.

Technical Article

Take the 2027 State of the Database Landscape Survey

Press Release from SQLServerCentral

Share your view on the database landscape and you could win USD$500.

Blog Post

From the SQL Server Central Blogs - Evidence-bound: what AgentDBA will and won’t link

BLOB EATER from All About SQL

When the evidence names the database, it says so. When it doesn’t, it stops. Three databases have no recorded full backup. One backup job failed. Many tools would link...

Blog Post

From the SQL Server Central Blogs - Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

James Serra from James Serra's Blog

Making Data AI-Ready, Part 3 (This is the final article in a three-part series on making data AI-ready. Part 1 covered what AI-ready data means, Part 2 looked at...

Microsoft Power BI Performance Best Practices: Learn practical techniques for building high-speed Power BI solutions Microsoft Power BI Performance Best Practices

Steve Jones - SSC Editor from SQLServerCentral

In a world dominated by data, organizations heavily rely on business intelligence tools like Power BI for deriving insights and informed decision-making. Yet, as data volumes grow and user demands increase, achieving optimal performance becomes challenging.

 

 Question of the Day

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

 

Checking the Error Log III

If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?

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 Empty Aggregate

I have this table in a SQL Server 2025 database:

CREATE TABLE [dbo].[CustomerOrder]
(
[OrderID] [int] NULL,
[CustomerID] [int] NULL,
[total] [money] NULL
) ON [PRIMARY]
GO

What is returned from this code? (answers are for the sum and then the count)

SELECT SUM(total) AS sum,
       COUNT(total) AS count
FROM dbo.CustomerOrder;



Answer: null and 0

Explanation: If there are no rows, a sum() returns null. Count() returns 0. Ref:

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 Azure - Administration
Azure SQL Database Event Log Limitations - Hi, Do you know if there is a way to get more detailed logging from an Azure SQL Database? In sys.event_log, I can only see successful and failed connection events. I'm looking for additional details about what is happening within the database. is possible to obtain more detailed information about database activities and events. Thanks
Editorials
Today's AI - Comments posted to this topic are about the item Today's AI
Four Rules for Adding AI Without Breaking What Already Works - Comments posted to this topic are about the item Four Rules for Adding AI Without Breaking What Already Works
Development Is Fun - Comments posted to this topic are about the item Development Is Fun
Article Discussions by Author
Split Large Queries in Athena with a Simple Modulo Trick - Comments posted to this topic are about the item Split Large Queries in Athena with a Simple Modulo Trick
Finding Trailing Spaces - Comments posted to this topic are about the item Finding Trailing Spaces
Hyperscale Replicas III - Comments posted to this topic are about the item Hyperscale Replicas III
Optimized Locking in SQL Server 2025 - Comments posted to this topic are about the item Optimized Locking in SQL Server 2025
Adding new column with DEFAULT II - Comments posted to this topic are about the item Adding new column with DEFAULT II
SQL Server 2022 - Administration
Alamat BCA KCP ITC Roxi Mas Telp:08218520153 - WhatsApp CS 628218520153 ITC ROXY MAS, Jl. Kh Hasyim Ashari No.125 Basement 13, RW.8, Cideng, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10150
Alamat BCA KCP Sawah Besar Telp:08218520153 - WhatsApp CS 628218520153 Jl. Sukarjo Wiryopranoto No.28 C, RT.1/RW.1, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10120
Alamat BCA KCP Pasar Tanah Abang Tlp:08218520153 - WhatsApp CS 628218520153 Jl. KH Fachrudin 36 Blok D/23, Kp. Bali, Kecamatan Tanah Abang, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10250
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File - Hello, I would like to get some feedback regarding the best storage optimization strategy for a large SQL Server database. Option 1: Add multiple data files within the same filegroup and distribute them across different storage LUNs/disks, allowing SQL Server to spread allocations using the Proportional Fill algorithm. Option 2: Create a separate filegroup on […]
SQL Server 2025 section missing? - Hello, the title says it all. Is the SQL Server 2025 section missing?
SQL Server 2022 - Development
A design question in a parent child relationship - I am not sure which is the best way to proceed. I have parent child relationship where I have to determine if every vendor completed a task (this is a fictitious example). I have a task record and typically 13 or fewer vendors who each have to complete that task. My application needs to know […]
 

 

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

 

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