See You at SQL Saturday #46 - Raleigh
EDIT: Updated to include a picture of me.
I'm headed up this weekend to speak at SQL Saturday #46 - Raleigh. This...
2010-09-16
827 reads
Databases – Infrastructure – Security
Slides and Files: A PowerShell Primer
Here are the slides and scripts from last night's presentation at Midlands PASS Chapter. The presentation was intended to introduce...
2010-09-15
1,026 reads
Task Manager - Don't Believe the System Idle Process Percentage
This morning my laptop went to a crawl. I looked, and sure enough, there was an AntiVirus scan running. Argh!...
2010-09-14
3,562 reads
SQL Saturday #48 - Columbia, SC - Recommended Hotels
If you're thinking about attending SQL Saturday #48 - Columbia, SC and need a hotel room, our crew has done the...
2010-09-06
928 reads
SQL Saturday #48 - Columbia, SC Schedule Posted
The sessions have been selected and we have posted the schedule for SQL Saturday #48 - Columbia, SC. A huge thank...
2010-09-06
625 reads
Thoughts about the PASS BoD Nomination Process
I know I was one of the more vocal ones these past two years when the set of nominees were...
2010-09-06
881 reads
Re-learning how to think
Cross-posted from The Goal Keeping DBA:
Re-learning how to think is always a difficult process. My oldest son is starting the...
2010-09-03
1,495 reads
Free SQL Server Training for the Week of September 6, 2010
Tuesday
PASS Performance Virtual Chapter - Introduction to SQL Server Statistics - Andy Warren
Wednesday
Idera - Building a Data Mart with Integration Services - Stacia Misner
SQL...
2010-09-03
898 reads
For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin
Note: Republishing because the article covering the issue and a workaround has been published here on SSC.
In a recent thread...
2010-09-01
4,309 reads
SQL Saturday #48 - Columbia - Call for Speakers Ending
This is a reminder for those who might be considering submitting a session but haven't yet. The call for speakers...
2010-08-31
1,403 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