Three Life-Changing Events
Paul Randal started a meme about three life changing events that brought him to where he is today. Brent Ozar...
2010-01-18
3,124 reads
Databases – Infrastructure – Security
Admitting When You're Wrong
As a father of two head-strong boys (inherited trait), I struggle with getting them to admit they are wrong when they...
2010-01-15
1,017 reads
Be Security Smart on Haiti Earthquake
Not surprisingly, there are already vultures looking to take advantage of the tragic earthquake in Haiti for their own financial...
2010-01-13
898 reads
Bad Default Database Leads to a Failed Login Attempt
Yesterday we had a user receiving the infamous failed login attempt error (no, that's not a valid IP):
Login failed for...
2010-01-07
1,714 reads
The Right Attitude to be a Mentor
When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....
2010-01-06
2,201 reads
What Matters Is What They Want
In September 1986 my family returned to Beaufort, SC, from a three year tour stationed at MCAS Iwakuni, Japan. My father was...
2010-01-05
660 reads
Re-Awarded MVP Status for 2010
I have been re-awarded MVP status for SQL Server for 2010. It's a humbling honor, and I will strive again...
2010-01-01
934 reads
Running a Small User Group - Remember, It's Not Exclusively Yours
I'm going to conclude this series on running a small user group with a topic that came up for discussion earlier...
2009-12-31
1,409 reads
Running a Small User Group - The Tools
Because running a small user group is a labor of love, we look for time savings wherever we can to...
2009-12-30
1,830 reads
Running a Small User Group - Getting Help
When we first started Midlands PASS, we tried to do it the way PASS suggested. We tried to get folks...
2009-12-29
1,417 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