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
SQL Design Patterns
Hide and Abstract the physical layer
How to build an abstraction layer between physical and logical layers in the database code
2018-04-07
171 reads
Extending built-in data types
add generic user defined table data types as extension to built-in ones
2018-04-05
155 reads
2018-04-03
256 reads
Configuration service database design pattern
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
The Journey Begins
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
Blogs
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...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
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