A Minor Problem of Access
A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't...
2012-10-19
631 reads
Blog Posts
Address Clean-up for Mail Merge using SSIS
Remember the good ol’ days of going through a list of addresses and manually cleaning up hundreds if not thousands...
2012-10-19
741 reads
fn_OBJECT_TYPE
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...
2012-10-19
1,239 reads
Lost in Translation – Deprecated System Tables – sysforeignkeys
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-19 (first published: 2012-10-16)
1,760 reads
MDX #19 – There is more to do to concatenate row values into column
Continuing from MDX #18 – Easy to concatenate row values into column in MDX.
I have not accomplished the goal of concatenating...
2012-10-19
1,444 reads
Reblog: October 12 to October 18
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-19
515 reads
SQL Server 2008 Diagnostic Information Queries (Oct 2012)
Here is the October 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-10-19
1,703 reads
This December–SQL Server Consolidation and Virtualization
This December (5th - 7th) I will be presenting SQL server Consolidation and Virtualization: Hands-On for Learning Tree in New York....
2012-10-19
929 reads
this is what I do when I install SQL. How about you?
Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64...
2012-10-19
875 reads
Awarded – Microsoft Community Contributor Award 2012
Today, I’ve received an email from Microsoft stating that I’ve been awarded Microsoft Community Contributor. This is the first time...
2012-10-18
1,683 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