Puzzling TVFunctions
I had the opportunity to tune a highly-used function the other day, and was most puzzled by the difference between...
2012-07-17
916 reads
Blog Posts
SQL In The City: London 2012, Recap
Wow!
How’s that for a recap?
The concept for the SQL in the City events is pretty simple. Put on a free...
2012-07-17 (first published: 2012-07-16)
2,088 reads
SQL Server: Instant Deadlock Alert Using WMI in Your Mailbox
In my last post I have explained,how to setup alert for blocking using WMI. In this post let us see how...
2012-07-17 (first published: 2012-07-16)
5,606 reads
T-SQL Tuesday #32 – A Life in the Day
It’s T-SQL Tuesday time again, delayed a week this month, so I had a whole extra week to get ready....
2012-07-17
1,373 reads
T-SQL Tuesday: A Day in the Life of a BI Developer
My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles. I’ve been a BI developer for...
2012-07-17
643 reads
BI Systems Architecture Diagrams
Today I have decided to prepare myself for a meeting with a potential client (tomorrow) and write an article about...
2012-07-16
635 reads
Building Your First Power View Report
This has been reposted from a guest blog post I wrote on the Microsoft Business Intelligence team blog.
Fulfilling User Needs
Developing a...
2012-07-16
1,204 reads
Crystal Reports DataDate in SSRS
Crystal Reports has a special field name “DataDate”. This date shows the last time the data on the report has...
2012-07-16
1,369 reads
Encrypting Connections to SQL Server
I manage databases for financial organisation. These databases have confidential data of our customers such as credit card numbers, security...
2012-07-16
5,665 reads
Finding Your Dream Job - sharing some thoughts of the day...
Everyone at some time or another thinks about finding or landing their dream job. It could be in the form...
2012-07-16
2,074 reads
Blogs
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...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
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