5-Weeks to PASS Summit 2010 Countdown
With 5-weeks until the PASS Summit it’s time to start getting ready for the event. As I’ve discussed a couple...
2010-10-06
751 reads
Blog Posts
A Surprising Result from Ident_Current
If you haven’t used it (and I rarely do myself), Ident_Current (‘tablename’) returns the last identity value generated across all...
2010-10-06
994 reads
An Organizer's Recap of SQL Saturday #48 - Columbia, SC
This past Saturday, October 2nd, we hosted Columbia, SC's first ever SQL Saturday. By the feedback we've received, both during...
2010-10-06
825 reads
Closing Fast – SQLSaturday #49 – Orlando
Well, the event is closing in fast, less than 2 weeks away! We have over 300 registered, a great schedule,...
2010-10-06
548 reads
Connection Strings: Database Mirroring Failover Partner Setup & Sample Backup/Restore Preparation Script
After having setup my first SQL 2008 R2 Enterprise (build level 10.50.1702) database mirror as High Safety with automatic failover,...
2010-10-06
6,260 reads
Determine if Directory Exists using xp_cmdshell
Recently, I came across a forum post from a user trying to determine if a directory existed in the file...
2010-10-06
14,403 reads
One Meel-ee-yon Posts
We crossed the 1,000,000 post mark on SQLServerCentral today and that’s very cool to me. A few others as well...
2010-10-06
432 reads
PASSMN Board of Directors Nominations
It’s that time of the year again. Time to get in some nominations for the 2011 PASSMN Board of Directors. ...
2010-10-06
1,107 reads
Return of Index Analysis Part 2
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-06
1,049 reads
So I Got Promoted, Now What? Get To Know Your Peers
[This is part four in a series of posts about how to effectively transition to your new role after being...
2010-10-06
807 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers