Women in technology
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s...
2015-11-25
630 reads
SQLStudies
Using multiple log files
The transaction log is made up of one or more files that are used sequentially. So in other words if...
2015-11-27 (first published: 2015-11-23)
1,548 reads
Naught to Speaker pt 3
Becoming a speaker is one heck of a journey. Early this year I submitted a session to speak at Pass...
2015-11-18
622 reads
SSMS Setup
Every time I install a new version of SSMS I make a handful of changes to the default setup. For...
2015-11-16
1,126 reads
Hiding one or more columns
This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain...
2015-11-12
676 reads
Why are you still using datetime?
It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a...
2015-11-12 (first published: 2015-11-10)
4,848 reads
Questions from “SQL Server Security for Everyone”
I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by...
2015-11-04
519 reads
Administrative Logins and Users
If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this:
Please give...
2015-11-02
506 reads
Who’s on call
Of all the posts I’ve written I think this one is my favorite, even though it’s not a technical post....
2015-10-28
504 reads
Finding and keeping your #SQLPassion
I consider myself lucky. I fell into a job that I truly enjoy, something that I do for fun even...
2015-10-26
488 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