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,213 reads
Blog Posts
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,584 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
845 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,545 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
711 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
624 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,870 reads
Another Reason to Avoid Cross-Database Ownership Chaining
This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We...
2009-02-13
2,151 reads
Color E-Ink
I love my Kindle, but it uses an older e-ink technology that's a little slow and doesn't support color. Not...
2009-02-13
967 reads
SQL Injection - It's Not Just Me!!
I have a personal web site I set up years ago, mainly so I could post stuff for my extended...
2009-02-13
821 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
sqlbackups through veeam not updating msdb tables
We have veeam backups happening everyday on a server where all sql databases are...
Testing whether TRY_CONVERT is losing precision
Hello All, I am using TRY_CONVERT to parse character data into a decimal column....
need help with assigning a value to a variable
Hi I am trying to assign the value of the variable using the output...
Question of the Day
The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers