Key Sets, or Inverted Keys - defining a key as a set of tuples
TL;DR:
I have been doing a lot of thinking about data models for the last couple of weeks. I have, just...
2017-12-19
423 reads
TL;DR:
I have been doing a lot of thinking about data models for the last couple of weeks. I have, just...
2017-12-19
423 reads
Just a quick one today. TL;DR: Remove yourself from some unnecessary AD groups.
If you've ever received the message "login failed...
2017-11-24 (first published: 2017-11-12)
3,329 reads
If you're seeing this for the second time, my apologies. I wanted to update the title but had to delete...
2017-11-13
1,668 reads
Tricky triggers
In my last entry I noted that the performance of "instead-of" triggers can be tricky.
One of the reasons for...
2017-11-07
535 reads
I'm working on problems of enterprise data integration in the role of enterprise architect, but I am and have been...
2017-11-06 (first published: 2014-11-19)
6,343 reads
Defining the Problem
Imagine I have two different systems - say, a CRM and an ERP - on different SQL Servers. Both systems...
2017-11-05
445 reads
Update:
After all of this SMO stuff failed (changing the permission set to unsafe got around the security exception, but instead...
2011-06-15
1,452 reads
Relation Types
create type type_T(i int primary key clustered, j int check (j > 0)) -- relation type. Includes constraints!
create table T(type_T)
Relvar Assignment
This...
2011-06-15
943 reads
SSMSDeploy version 1.5 is ready. This one has a LOT of GUI tweaks. No database changes in this one, so...
2011-01-22
941 reads
Fixed a couple of issues and made some GUI tweaks. Please see the download page for the latest version, and...
2011-01-20
698 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Comments posted to this topic are about the item Finding Marks
Comments posted to this topic are about the item Multiple Display Productivity
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers