Have a Question? Use the Forums
I try to keep a pretty tight lid on the comments to the blog because there's a lot of SPAM...
2010-03-25
532 reads
Databases – Infrastructure – Security
Avoiding Plagiarism
Having gone to an academic magnet school, I have quite a few friends who are teaching at the university level...
2010-03-24
1,911 reads
Don't Throw Something New In At Production Deployment
This post comes from a conversation I had with a developer last week as well as my experiences over the...
2010-03-22
1,810 reads
When It "Has" to Use SA...
As an infrastructure and security architect, I cringe any time any one mentions the following:
Domain AdminrootsaThose accounts can do anything...
2010-03-19
646 reads
New Goal: Security Presentation for End Users on Social Media
Cross-posted from the Goal Keeping DBA:
In recent days I’ve seen folks jump on Facebook groups and become fans of pages...
2010-03-18
697 reads
Working for/with High Caliber Folks
Within a couple of days of each other, both Andy Leonard (@AndyLeonard) and Paul Randal (@PaulRandal) tweeted about possible job opportunities which would...
2010-03-12
1,856 reads
Upgraded to Model
That's right, folks, I'm now a model. Or at least, a model DB. Tom LaRock released his most recent rankings and...
2010-03-10
573 reads
PASS Summit to Stay in Seattle
PASS has released the survey results as well as its decision about where to hold future Summit events. The decision...
2010-03-10
1,982 reads
Focus on Your Passion
Tuesday night I was having a conversation with my younger son, whom we call Turtle. It's a nickname that came...
2010-03-04
1,084 reads
Baby Steps to Learning Something New
I had a really bad habit of trying to jump into the middle of something I didn't know very well,...
2010-03-03
4,808 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