The Limited Usefulness of Encrypting File System (EFS) and Transparent Data Encryption (TDE)
This is something that hit me as I was presenting to the Charlotte SQL Server User Group last night.
Back...
2009-02-18
4,092 reads
Blog Posts
All In & Being Competitive
Many of us in IT are competitive, maybe slightly more so than in other professions. Competition adds a little spice...
2009-02-17
1,493 reads
Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
This question was sent...
2009-02-17
2,121 reads
Your Local User Group
When I talk to other SQL Server professionals, I’m often surprised at how many do not have any involvement in...
2009-02-17
1,223 reads
Be Careful with String Concatenations in SQL Server with Big Strings.
Now, we are going to get slightly esoteric here. I'd noticed that the performance of string concatenation tasks didn't increase...
2009-02-16
14,597 reads
Book Review - The Human Edge
I've always enjoyed the science fiction writings of Gordon Dickson, and recently re-read an old copy of The Human Edge,...
2009-02-16
846 reads
Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?
Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror...
2009-02-16
4,546 reads
Recharged
It’s rare that I’ve taken vacation in the last few years. In fact, when I took an unwired week in...
2009-02-16
714 reads
Networking - Part 5
You can read the previous posts here. To finish up my thoughts on networking I want to brain storm some...
2009-02-15
627 reads
The Importance of the Segregation of Duties with Respect to Internal Controls
I diverge a little from the typical coding-based/oriented best practice to one that is focused on governance within public or government organisations...
2009-02-15
7,897 reads
Blogs
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers