Building your database code is an essential practice to ensure that it compiles from source and that dependencies are met. But things can get tricky when you have objects...
2019-06-25
7 reads
Watch this week's video on YouTube
This week I want to share something that surprised me about using SQL Server's SET IDENTITY_INSERT statement.
I started with two tables with identity columns...
2019-06-25
14 reads
Watch this week's video on YouTube
This week I want to share something that surprised me about using SQL Server's SET IDENTITY_INSERT statement.
I started with two tables with identity columns...
2019-06-25
8 reads
In this webinar I discussed designing a Power BI model to plan for either a simple or complex row level security scenario.
2019-06-25
44 reads
I am proud to announce that I am presenting at this year’s PASS Summit conference, to be held in Seattle WA from November 5th to 8th at the Washington...
2019-06-25
7 reads
Good afternoon folks! It is Monday Tuesday already after a long weekend in Poland. I do not know what temperature you have but here we are like in a...
2019-06-25
17 reads
(2019-June-06) I remember I had a professor at my university who very often would encourage his students to learn and get more experienced with simple things first. Learn the basics...
2019-06-25 (first published: 2019-06-07)
49,479 reads
Using Graph DB is a good way to show relationships between entities (more specifically a vertex and edges). This is why you would use this approach over classic SQL...
2019-06-24
19 reads
I had a good question from JP via a comment on my blog about whether you can use the MAXDOP query hint in Azure SQL Database. The answer? Yes....
2019-06-24
25 reads
After my presentation at the Techno Security and Digital Forensics conference, I had a information security professional stop by to ask a few questions. He’s in the position where...
2019-06-24 (first published: 2019-06-10)
1,193 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
We want to setup a gateway db to host stored procedures which use tables...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers