Re-Awarded as a Microsoft MVP
Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....
2013-01-02
1,193 reads
Databases – Infrastructure – Security
Looking Forward to the New Year - Professional Goals
Most folks make New Year's resolutions of things they want to do over the course of the next 364/365 days....
2013-01-01
1,307 reads
Are You a Chessplayer?
I was having a twitter coversation with @dataartisan about chess. He remarked that playing on-line with random folks didn't strike him...
2012-12-17
1,034 reads
Are Your Protecting Your DB Backups?
Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government...
2012-11-27
3,161 reads
Server Level Security
We'll discuss surface area later in the week. Today let's talk about if you're able to connect to SQL Server....
2012-11-09 (first published: 2012-11-06)
3,426 reads
SQL Server Security: The Sum of Its Parts
When it comes to attacking SQL Server, whether we're talking about the security of an installation or as a piece...
2012-11-05
1,464 reads
Preparing for Certification
One of my goals back when I was a young MCSE (that's Microsoft Certified System Engineer for NT4, not the...
2012-10-22
1,352 reads
MS12-070 - Should I patch more than Reporting Services?
If you're dealing with a version of SQL Server greater than SQL Server 2000, at this point I'm going to...
2012-10-11
1,980 reads
Slides and Scripts from Idera Auditing SQL Server presentation
I had a few folks ask me for the slides and SQL scripts from the Auditing SQL Server webinar I...
2012-10-10
1,565 reads
Microsoft Security Bulletin MS12-070 for SSRS
Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...
2012-10-15 (first published: 2012-10-09)
4,293 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