SQLSaturday #158 Event Update & Hotels - Where are you staying?
Well, we're just a few weeks away from the return of SQLSaturday to NYC as SQLSaturday#158, and it is sure...
2012-07-12
1,687 reads
Blog Posts
SQLTreeo is suspended
Last few month I was really busy and had completely no time for SQLTreeo. This add-in was started being used by...
2012-07-12
825 reads
Stress Testing Stored Procedures with Free Tools
I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help...
2012-07-12
1,420 reads
Understanding the CDC State Value
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
2,195 reads
Columbia Enterprise Developers Guild meeting tonight
If you're in or around the Midlands of South Carolina area, the Columbia Enterprise Developers Guild meets the 2nd Wednesday...
2012-07-11
953 reads
Decryption and CASTing
In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...
2012-07-11 (first published: 2012-07-03)
3,406 reads
Different ways to move Sql Server file location
Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons,...
2012-07-11
1,022 reads
Many speaking engagements!
I have several speaking events coming up, and I would love to see you there!
First of all, I'll be...
2012-07-11
1,046 reads
Microsoft PivotViewer
Microsoft PivotViewer is a really cool Silverlight web-based control that provides a visual way to interact with massive amounts of data (download)....
2012-07-11
1,317 reads
Quick tip: configure SQL Server authentication mode using T-SQL
SQL Server stores its authentication mode in the registry. The registry can be read and updated using the T-SQL commands...
2012-07-11
1,287 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