Get a Better Understanding of How Queries Execute
I was catching up on my blog reading (unfortunately, in some cases I'm
a month behind) and came across a link...
2006-07-14
1,455 reads
Blog Posts
New KB Article on SQL Server 2005 File Growth Bug
There is are two new KB articles on how the file growth value can become abnormally large. You can find...
2006-07-13
1,617 reads
A Chronology of Data Breaches Reported Since the ChoicePoint Incident
Found this link on one of the security mailing lists I peruse. You can find an archive of the original...
2006-07-11
1,397 reads
New KB Article on Remote Mirroring Support Requirements
Microsoft has published a new Knowledge Base article on the
requirements to receive support for what is known as remote mirroring.
Requirements...
2006-07-07
1,714 reads
Passed Again
I took the 70-441 exam last week and passed, which is good since I'm
working on part of the exam prep...
2006-07-07
1,475 reads
New Article on SQL Server 2005 Logins
I wrote a new article for SQL Server Central on SQL Server 2005 Logins. It covers the basics. This is...
2006-07-05
1,398 reads
Microsoft Office 2007 Delayed
It looks like Microsoft Office 2007 will be delayed due to performance
issues. It was supposed to release in conjunction with...
2006-06-29
1,358 reads
Idera SQL Check updated for SQL Server 2005
Idera's SQL Check
has been updated to support SQL Server 2005. SQL Check is a free
performance monitoring tool, not anywhere near...
2006-06-28
1,545 reads
WinFS rolled into next version of SQL Server
A blog posting from the WinFS team
caught me a bit by surprise today. Apparently I wasn't the only one,
judging by...
2006-06-27
1,544 reads
Passed
I'm doing a little work on the 70-441 exam book since an author flaked and so I took the exam...
2006-06-26
1,597 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