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
167 reads
Extending built-in data types
add generic user defined table data types as extension to built-in ones
2018-04-05
152 reads
2018-04-03
254 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
522 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
309 reads
Blogs
Azure Networking: Designing for Change
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
Using Customer Docker Compose File Names
By Steve Jones
As I use containers more and more to run various things, I decided I...
SQL Server Failover Cluster Instances
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
Forums
SQL Server authentication vs. Trusted connection
I maintain an application written years ago, where the database is on a Windows...
Handling Engagement Rings & Wedding Band
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers