ADO.NET in PowerShell
I've had to rework some logic for gathering database information in my serverstatus.ps1 script, because SMO doesn't exactly do things...
2009-09-22
740 reads
Blog Posts
Cape Cod .NET Users Group
Tomorrow night, Wednesday, September 23, I’m going to present on “Best Practices for Working with SQL Server Execution Plans” for the...
2009-09-22
840 reads
Estimated rows, actual rows and execution count
It’s often said that a major discrepancy between estimated and actual row counts in a query’s execution plan is a...
2009-09-22
2,250 reads
Free eBook: “Protecting SQL Server Data”
SQL Server security expert, John Magnabosco, has just authored the new book, Protecting SQL Server Data, the first book of...
2009-09-22
718 reads
Gila Monster on Estimated vs. Actual Row Counts
I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s just not something I’m that into....
2009-09-22
1,287 reads
New Cumulative Updates For SQL Server 2008
Yesterday, Microsoft released SQL Server 2008 SP1 CU4, which is Build 2734, and SQL Server 2008 RTM CU7, which is...
2009-09-22
643 reads
PASS Book List
Since the beginning of the year I’ve been trying to include a SQL related book in the bi-weekly Connector. Basically...
2009-09-22
543 reads
PASS Connector Editorial for September 23, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-22
561 reads
Searching for Data in Images
I tried out Bing’s new visual search after seeing a few people note it on Twitter. I was a little...
2009-09-22
1,065 reads
September OPASS Meeting Recap
OPASS met last Tuesday, September 14th, with a mini (15 minute) presentation by Todd Holmes on Backup Basics and Jorge...
2009-09-22
435 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