Nice Article on Security Myths in May/June 2006 Issue of TechNet Magazine
The May/Jone 2006 issue of TechNet Magazine has a feature on security. One of the articles is titled Deconstructing Common...
2006-05-12
1,531 reads
Blog Posts
Review of SQL Server 2005 Integration Services, Part 1 of 4
Back in First Impressions of Professional SQL Server 2005 Integration Services,
I indicated I felt the book was worth the buy...
2006-05-10
1,457 reads
Excellent article on cracking SQL Server passwords
The SQLServerAdvisor mailing from SearchSQLServer.com had a link to a
very good article on cracking SQL Server passwords. The article, by
Kevin...
2006-05-09
1,597 reads
Share Your OPML
Dave Winer announced bringing back Share Your OPML
on Friday. I wasn't keeping up with many RSS feeds back when the
original...
2006-05-08
1,552 reads
Security Awareness for Developers - What would you include?
If you were putting together a security awareness training program for
developers, what aspects of SQL Server security would you include?...
2006-05-06
1,841 reads
Going to TechEd 2006 in Boston!
As of right now, it looks like I'm going to TechEd 2006 in Boston. If you're going to be there...
2006-05-05
1,457 reads
Scaling out SQL Server 2005 article
This article appeared just recently on MSDN:
Scaling Out SQL Server 2005
It's a relatively high level document which covers how to...
2006-05-05
1,548 reads
SysInternals EULA Updated
The SysInternals licensing has been updated on the SysInternals website.
The new licensing is something you'll want to take a look...
2006-05-05
1,472 reads
PromptSQL purchased by Red Gate Software
It appears that PromptSQL has been purchased by Red Gate Software. I
haven't seen a news announcement about it, and there's...
2006-05-04
1,528 reads
SQL Server 2005 Books Online (April 2006)
SQL Server 2005 Books Online has been updated for SP1. The newest
version is labeled SQL Server 2005 Books Online (April...
2006-05-04
1,526 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