Cain does LSA Secrets dump on Vista and higher now
Since going back to being a senior DBA, I've not stayed on top of the latest tools like I did...
2011-04-19
2,077 reads
Databases – Infrastructure – Security
"What's the point?"
This is a crucial question with regards to what needs to be done. It really hit home after listening to...
2011-04-18
808 reads
It's not about whether you're a consultant or full-time staff...
There's an article that's making its way through the SQL Ranks: Consultants are pros, while corporate IT staff are minor...
2011-04-12
1,334 reads
An Appeal to Those Writing Training Documentation and Labs
I'm coming to the end of a week of training in a Microsoft Official Curriculum (MOC) Course. I should expect...
2011-04-08
919 reads
On Leadership - Lead by Example
This is the second part of a leadership series I started with On Leadership - Lead from the Front. To recap...
2011-04-07
1,603 reads
SQL PASS ERC: How to Score the Interview?
One of the topics the Election Review Committee has discussed is how best to score the interview portion. Because of...
2011-04-06
1,353 reads
SQL Injection: It's not just about your data
On the topic of my SQL Connections SQL Server presentation, one of the things I pointed out about recent SQL...
2011-04-06
1,105 reads
Epsilon Data Breach and Staying Safe
By now, you may have received an email from one of the larger businesses you've given your email address to...
2011-04-05
757 reads
A SQL Story in Eleven Words or Less
Tom LaRock (blog | twitter) proposed a Meme Monday and his first choice of topics was to write a SQL Server...
2011-04-04
698 reads
Isolating SQL Server from other systems
In a recent explanation about the RSA breach, Rick Wanner wrote on the Internet Storm Center (ISC) Diary:
The traditional paradigm...
2011-04-04
2,147 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers