HP Mini Netbook – Day 2
I arrived in Richmond, VA this morning earlier than expected. I was meeting a few people and things were pushed...
2009-07-02
1,463 reads
Blog Posts
How to Become an Exceptional DBA, 2nd Edition, Now Available Free
About a year ago, the first edition of my book, How to Become an Exceptional DBA, was published. It was...
2009-07-01
1,815 reads
HP Netbook 1030NR Setup
Unpacking the netbook was pretty simple. Open it, grab the large one page poster, and then the netbook. There were...
2009-07-01
703 reads
HP Netbook Mini 1030NR
It was not what I expected. When I was leaving for a run this morning, I decided to apply an...
2009-07-01
1,320 reads
Powershell SQL Server Backup/Restore
I posted a script on Poshcode for doing backups and restores of SQL Server databases using SMO. The script is...
2009-07-01
2,145 reads
Stack Overflow, Server Fault, and SSC
Steve Jones sent me a link to a presentation Joel Spolsky did at Google about Stack Overflow (SO) and it’s...
2009-07-01
766 reads
The Best Thing I Learned At PASS
Note: I'm writing this as part of the "Best Thing I Learned At PASS" contest. Why? Because if I win...
2009-07-01
753 reads
Transaction Rollbacks with Identity Values
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your...
2009-07-01
10,018 reads
Connector Editorial for July 1, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-30
1,515 reads
Querying the Procedural Cache on Canada Day (July 1st)
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources...
2009-06-30
2,444 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers