Security: People Are the Weakest Link
There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...
2013-04-05 (first published: 2013-03-28)
3,329 reads
Databases – Infrastructure – Security
What to Do When You Can't Wipe an Infected System
When it comes to workstations within most organizations, the solution when one gets infected is to wipe it and re-image...
2013-03-27
2,666 reads
Get Data Warehouse Training and Help a Neat School
If you're located relatively near the Atlanta, Georgia area, I wanted to bring your attention to data warehousing training on...
2013-02-18
1,104 reads
Upcoming Online Training for the Week of February 18, 2013
I used to compile a list of online training for the following week and posting it on Fridays. I stopped...
2013-02-14
1,009 reads
Avoid This Time Scheduling Mistake
I was recently asked by a project manager to lay out when DBAs would accomplish certain tasks for a particular...
2013-02-07
1,413 reads
Consider All the Possibilities When Troubleshooting
When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's...
2013-01-28
1,670 reads
Cash Over Credit
What does cash over credit have to deal with security? An awful lot, as it turns out.
Personal Story: Mere days...
2013-01-17
1,216 reads
Rename the SQL Server Management Studio shortcut
Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have...
2013-01-11
7,792 reads
Observe Carefully When Things Are Running Fine
Cross-posted from The Goal Keeping DBA blog:
As a worker in information technology, I’ve always been a big proponent of studying systems...
2013-01-14 (first published: 2013-01-10)
2,156 reads
Speaking at Midlands PASS in February
On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia,...
2013-01-10
962 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