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
666 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,596 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
976 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
695 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,961 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,117 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,712 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,921 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,237 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,997 reads
Blogs
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
Forums
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Putting the Player with the Number
Comments posted to this topic are about the item Putting the Player with the...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers