Securing All Your Connections
Microsoft is recommending more security for SQL Servers, including dev and test instances. Do you agree this is a good idea? Would you implement this?
2023-06-28
189 reads
Security
Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security
In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.
2024-01-09 (first published: 2023-06-19)
2023-05-29
302 reads
Validating Password Expiration
Steve notes that password expiration is important for SQL Logins, but he knows this isn't always configured when logins are created, or checked later to see if it is still enabled.
2023-05-27
426 reads
Demystifying Best Practices and Enhancing RDS security with Amazon GuardDuty
This article looks at four security best practices for protecting databases in AWS along with how GuardDuty can be used to provide additional security.
2023-05-17
1,250 reads
The Public Perception of Security Issues
The way the public thinks about security issues isn't always accurate, but we have to accept that and learn to respond in a professional manner.
2023-05-03
116 reads
Data Oriented Cloud Security Mechanisms
This article looks at security mechanisms in the cloud that can help protect your data, with specific examples in AWS.
2023-04-14
1,316 reads
Has Everyone Had a Data Breach?
Not only is the security of our organization important, but that of our partners matters as well.
2023-03-08
131 reads
Stale Data Causes Security Issues
Stale data from Microsoft has led to many systems being more vulnerable than they should have been. There's no excuse for this, from Microsoft or our own organizations.
2023-03-01
113 reads
2023-02-06 (first published: 2023-02-01)
873 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
sql query to check status change of an item
I have a table dbo.tblPresentationStatus (sql script attached - table script.txt) I have to...
Tracing a performance issue
Hello, We have a SQL agent job that runs daily. It runs a procedure,...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002; See possible answers