002 – SQL Server 2016 - WaterOx Consulting
Reading Time: 1 minutesIt is official! The next version of SQL Server will be SQL...
The post 002 – SQL Server 2016...
2015-05-08
662 reads
Chris
How Many SQL Log Files Do You Keep? - WaterOx Consulting
Reading Time: 2 minutesEver have this happen? You (on vacation): I’ll have another piña colada...
The post How Many SQL Log...
2015-05-05 (first published: 2015-04-22)
5,593 reads
They Can Do What? – SHUTDOWN - WaterOx Consulting
Reading Time: 1 minutesMany times the DBA is faced with the dilemma of granting excessive...
The post They Can Do What?...
2015-04-29
973 reads
Quickly Check If SSL For SQL Is Enabled - WaterOx Consulting
Reading Time: 2 minutesTo quickly check SSL is configured on your SQL Server you can...
The post Quickly Check If SSL...
2015-04-15
693 reads
Can an EKM Save The World of Data? - WaterOx Consulting
Reading Time: 4 minutesQuis custodiet ipsos custodes? Who will guard the guards themselves? – Latin...
The post Can an EKM Save The...
2015-03-18 (first published: 2015-03-10)
6,959 reads
Data Size – LEN() vs DATALENGTH() - WaterOx Consulting
Reading Time: 3 minutes No. It isn’t just the way you use your data that...
The post Data Size – LEN() vs...
2015-03-13 (first published: 2015-03-04)
7,115 reads
Gimme A Break! Taking Mental Health Days - WaterOx Consulting
Reading Time: 3 minutes Burnout! You have been stressing over the big project you have...
The post Gimme A Break! Taking...
2015-02-26
1,711 reads
Enough Is Enough! Why Do We Have To Be At Risk?
Reading Time: 2 minutes
When Do We Say Enough Is Enough?
Recently Anthem Blue Cross Blue Shield announced that the ‘private’ information...
2015-02-17 (first published: 2015-02-07)
7,920 reads
When Do You Ask for Help?
Reading Time: 3 minutesBeing on the edge of a cliff is a common feeling when running a small business
Stepping Back
I...
2015-01-30
1,236 reads
DoD STIGs – Database Security Requirements Guide
Reading Time: 24 minutes
What are the Database SRG DoD Stigs?
The Database Security Requirements Guide, or SRG, is published as a...
2015-01-27
2,995 reads
Blogs
The Evolution of Data: From Databases to Spark to Lakebases
By Daniel Janik
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...
Why Microsoft Fabric Signals the Next Wave of Data Strategy
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
PostgreSQL Timeline: History and Evolution
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
How to fix transactional replication latency
Good Morning All, We are facing replication latency issue. I checked for blocking, long...
Life's Little Frustrations
Comments posted to this topic are about the item Life's Little Frustrations
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers