Friday Followup For October 17, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-10-17
422 reads
Blog Posts
Navel Gazing
I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to...
2014-10-17 (first published: 2014-10-12)
6,595 reads
Reblog: October 10 to October 16
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-10-17
708 reads
Untrusted Foreign Keys
Reading Time: 4 minutes
What is a Foreign Key?
Do you trust your foreign keys?
A foreign key is a link between...
2014-10-17
321 reads
Why Haven’t You Changed Everything?
The first in what I hope will be many regular reports on what I’m doing on the PASS board.
To answer...
2014-10-17
601 reads
Analytics Platform System (APS) AU2 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has recently released an appliance update (AU2),...
2014-10-16
909 reads
Creating a SharePoint Server Farm on Azure from the Gallery
As many of you know creating a SharePoint farm for testing can be a daunting task. I volunteered to help...
2014-10-16
786 reads
Eliminate Overlapping Dates
I was looking for an efficient way to eliminate overlapping days when provided with a historical table that provided events...
2014-10-16
975 reads
Insufficient Space to Create Databases For SCOM 2012 R2
Ran into a minor issue while installing SCOM. The wizard wants to create two databases. The first requires a minimum...
2014-10-16
699 reads
Learning Options in Seattle Next Month
The 2014 PASS Summit takes place next month. Actually a few weeks, on Nov 3-7, 2014 in Seattle. While many...
2014-10-16
797 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers