CLR Triggers in SQL Servers
Do CLR triggers really represent the most popular usage of CLR in enterprise SQL Servers? Phil Factor wants to know if this is the case, and if so, what on earth are they doing?
2009-06-08
503 reads
Editorials
Software Giants
Microsoft is the largest software company in the world. What does this mean for SQL Server? Steve Jones thinks it's good.
2009-06-08
194 reads
Shaking the Money Tree
Are developers or administrators worth more? Is it easier to get funding for one group or the other? Steve Jones asks the question in today's poll.
2009-06-05
141 reads
Syncing Releases
Is the future for product releases and upgrades, to be synchronized with point releases? Steve Jones relishes the possibility.
2009-06-04
129 reads
The Problem Is You
Why doesn't SQL Server just run smoothly after it's installed? Steve Jones thinks the problem is you.
2009-06-03
141 reads
Intruding into Dummy Websites
Phil Factor muses on security, bayonets, and databases, and somehow manages to pull it all together in this editorial.
2009-06-02
202 reads
Making Mistakes - Database Weekly (June 1, 2009)
We all make mistakes, even when we are trying to help others. What should you do about it? Steve Jones has a few thoughts on advice online.
2009-06-01
142 reads
No More SOX
A legal challenge to the Sarbannes-Oxley act is being heard this fall. Steve Jones doesn't necessarily think this is a bad law.
2009-06-01
174 reads
The Sports Salary
Are you happy with your salary? Are you happy with the way you negotiated it? Steve Jones asks if you might like a different salary structure.
2009-05-29
271 reads
Dead Data
What happens to the data of a company if it goes out of business? Steve Jones has a little experience and says it might not be as simple as you think.
2009-05-28
112 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