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,172 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,172 reads
How to build an abstraction layer between physical and logical layers in the database code
2018-04-07
155 reads
add generic user defined table data types as extension to built-in ones
2018-04-05
146 reads
2018-04-03
241 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
501 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
301 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers