Contextual View
In this post I describe technique of presenting data that is context specific - for example, data that will be changing...
2018-04-11
1,180 reads
In this post I describe technique of presenting data that is context specific - for example, data that will be changing...
2018-04-11
1,180 reads
How to build an abstraction layer between physical and logical layers in the database code
2018-04-07
171 reads
add generic user defined table data types as extension to built-in ones
2018-04-05
155 reads
2018-04-03
256 reads
In many cases, we are required to store configuration values for an application, application functionalities or user-specific parameters. Normally application-level...
2018-03-30
525 reads
Thanks for joining me! Target Audience. Database developers, designers and architects. Background. I am lazy efficient, at least am trying to...
2018-03-30
313 reads
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
Hi everyone, We are selling cars and have a range of options at our...
hi for the 2 years i've been here I believe we've had "encryption" turned...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers