My PASS Summit Submissions
Following Andy Leonard's (blog | twitter) footsteps, here are my PASS Summit submissions. I decided to go a little different this...
2011-05-05
793 reads
Databases – Infrastructure – Security
Outlook Productivity Tricks
I have a love/hate relationship with Outlook. It's the required email client at work and because it interfaces with so...
2011-05-05
2,103 reads
Writing Better Emails
In January 2009, I made the transition back to being a senior DBA. One of the first things my manager...
2011-05-04
2,932 reads
How often do you check email?
If you read the experts, most folks check their emails too many times during the day. Today, while giving a...
2011-05-03
794 reads
Love What You Do
I've been dealing with illness the last few weeks, probably due to the rather heavy pollen season here in South...
2011-04-29
1,543 reads
SQL University: Who has access to my SQL Server?
Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...
2011-04-26
2,789 reads
If a web page asks you to update Adobe Flash Player
You don't want to do so from that web page. Instead you want to go to the Adobe web site...
2011-04-22
1,126 reads
Why having two accounts is a good thing
Today on Twitter a friend of mine posted that the AV on his SQL Server flagged two trojans that were...
2011-04-22
700 reads
Evaluating my SQL Connection Scores
This evening I received my SQL Connection scores for the following presentations:
Windows Internals for DB ProsFrom the Ramparts: Knowing What...
2011-04-20
1,479 reads
Cain does LSA Secrets dump on Vista and higher now
Since going back to being a senior DBA, I've not stayed on top of the latest tools like I did...
2011-04-19
2,079 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