PASS in Five Years: It's about the Members
Andy Warren (blog | twitter) recently blogged about wanting input on What Should PASS Be? and I think it's a reasonable...
2011-02-24
1,494 reads
Databases – Infrastructure – Security
Configuring Antivirus for SQL Servers
I've been on both sides of the debate with respect to whether or not to install antivirus software on a...
2011-02-24
3,387 reads
PASS Election Review Committee: NomCom Process
Over on the ERC forums, Bill Graziano (blog | twitter) has posted the proposed NomCom selection process. We would really like...
2011-02-23
602 reads
Shameless Self-Promotion - Introduction to SQL Server [Book]
My introductory text to SQL Server, appropriately titled Introduction to SQL Server, is now in print and available for sale. The...
2011-02-22
953 reads
Use Patterns and Prior Code and Don't Reinvent the Wheel
In recent days I've seen folks try to recreate functionality when they had access to code that already did effectively the...
2011-02-21
1,981 reads
SQL Saturday #70 - Columbia, SC 2011 Session Schedule Is Up!
As announced, we have posted our session schedule for SQL Saturday #70 - Columbia, SC. The event will be March 19, 2011...
2011-02-19
1,272 reads
I'm in at SQL Connections!
At the end of March I'll be journeying down with the family to Orlando, Florida. We plan on stopping in...
2011-02-18
947 reads
SQL University: Home-Grown, with Real Options!
There's the light, as this is the last class for Security week at SQL University. From the scenarios we specified...
2011-02-11
1,612 reads
SQL University: SQL Server Security Architecture - Home-grown, No Options!?!
Thanks for hanging in there for Day 4 of Security Week here at SQL University. Today we're going to look at the...
2011-02-10
2,165 reads
Why You Should Attend SQL Saturday #70 - Columbia, SC
Free training. Excellent speakers. Outstanding location. Great networking opportunities. Experienced and efficient event staff. These are the primary things you...
2011-02-10
2,148 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