PASS Board of Directors Call for Nominations
This is just a reminder that the call for nominations for the PASS Boards of Directors is open. The final...
2009-08-24
916 reads
Databases – Infrastructure – Security
Keeping SQL Server Client Tools Up-to-Date
In a recent forum thread, someone asked to see who created/altered a particular object. Starting in SQL Server 2005, this information is...
2009-08-21
1,414 reads
Half-Way Through My Year as a Microsoft MVP
I meant to write this earlier, like in July, but I suppose it's better late than never. I'm halfway through...
2009-08-18
1,313 reads
SQL Quiz #5
Another SQL Quiz started by His Evilness, Chris Shaw. Okay, Chris isn't evil; I just wanted to say "evilness" and these quizzes...
2009-08-17
2,546 reads
"Just smile and wave, boys. Smile and wave."
If you're not familiar with the reference, it comes from the movie Madagascar and the subsequent sequel and TV series...
2009-08-13
13,813 reads
Getting Security Vulnerability Information
Staying abreast of security vulnerability alerts can be a daunting task because there are so many each day. One source...
2009-08-12
1,162 reads
Security is a Zero-Sum Game...
but I don't mean with respect to privacy. But I do mean with respect to the time it takes securing...
2009-08-11
709 reads
Why Use Named Pipes?
The other day a colleague and I were shadowing a vendor who was installing their 3rd party application on a...
2009-08-10
24,508 reads
PASS News to Be Aware Of
2009 PASS Summit Trip Contest:
If you want an opportunity to win an all expenses paid trip to the PASS Summit,...
2009-08-07
805 reads
Active August posts
I've started a blog to write down and track my personal goals:
The Goal Keeping DBA
Since Active August is part of reaching my goal...
2009-08-01
1,127 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers