Performance Tuning In LA!
Hello Dear Reader! This year Pragmatic Works has brought our Performance Tuning Workshop to Chicago, Boston, and Atlanta. Due to...
2013-09-26
531 reads
Blog Posts
SQL Server 2014: Partition Improvements
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase...
2013-09-26
1,222 reads
Understanding Microsoft Self-Service BI Recording and Q&A
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If...
2013-09-26
1,354 reads
Webcast Follow-Up: Recognizing the Parallel Data Warehouse (PDW) Workload
Last Monday, I presented a session for Pragmatic WorksTraining on the T’s on the Microsoft’s Parallel Data Warehouse. In the session,...
2013-09-26
1,583 reads
Which personal traits should a #SQLPASS Director have?
A lot has been said about what each candidate would like to do and their track record of delivering in...
2013-09-26
1,089 reads
AdventureWorks2012 Bug on Azure
While I have production databases in Azure, I can’t exactly experiment with them at will. Further, while they mostly have...
2013-09-25
1,315 reads
Houston Tech Fest 2013
I am traveling (driving) with the family to Houston to present on SSIS 2012 at Houston Tech Fest 2013 at...
2013-09-25
605 reads
I’m Voting for Allen Kinsel
As you can see from the title of this post, I’ve decided on one of the three votes I’ll be...
2013-09-25
757 reads
It’s Election Season
It’s that time of the year again – time to make your voice heard as a PASS member. The PASS board...
2013-09-25
881 reads
Data Warehouse vs Master Data Managment
Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM). Below is a...
2013-09-24
1,445 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