SQL University: SQL Agent Jobs That Run at SQL Agent Start
Welcome to Security week at SQL University. I apologize for the late start. However, if you want to do some...
2011-10-27
2,955 reads
Databases – Infrastructure – Security
Understanding Kerberos, Part II
The majority of the time, the problems I see with Kerberos are due to a bad SPN (Service Principal Name)...
2011-10-18
4,057 reads
Understanding Kerberos, Part I
A get a lot of questions where I work about Kerberos and how it works for SQL Server, whether we're...
2011-10-17
4,331 reads
Speaking at the 2011 Carolina Technology Conference
On Tuesday, October 18, 2011, I will be speaking at the Carolina Technology Conference in Columbia, SC. I'm scheduled for...
2011-10-14
1,407 reads
Cloud? Chotto Matte Kudasai.
If you're not familiar with Chotto matte kudasai, it means "A moment, please," in Japanese. The cloud is big news....
2011-10-14
1,209 reads
A Disturbing Trend: Government Sponsored Malware
It is understandable that nations may undertake operations against other nations. This is believed to be the origin of StuxNet...
2011-10-13
941 reads
Piiiiiiiigs, er DBAs, in Space!
If you don't get the reference, it was a set of skits on the old Muppet Show and it starred...
2011-10-13
995 reads
Learn to Help Yourself
I used to work with a guy who was adamant that before you asked him for help, you had done the...
2011-10-11
1,300 reads
PASS Summit Attendees: Remember to Network and Maintain
Previously, when I had attended conferences, I had used them to attend as many seminars or talks as I could...
2011-10-10
1,413 reads
Advanced Persistent Threats and Us
In a blog post from last year, Richard Bejtlich (blog | twitter) talked about a concept called an Advanced Persistent Threat...
2011-10-07
1,321 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