Scripting permissions using catalog views in SQL Server 2005
A nice How-To from one of the most respected SQL Server MVPs.
Katie
Most of us have been very lucky in life and SQLServerCentral.com is asking for your support in helping a fellow family in IT with this raffle.
Don't Upgrade to SQL Server 2005
It's been almost three years since SQL Server 2005 was released and Steve Jones current recommendation is that you don't upgrade right now. Read on to see why he's giving this advice.
SQL Server 2008 Launch Date
Yesterday at it's Worldwide Partner Conference, Microsoft announced the launch date for SQL Server 2008 along with Windows 2008 and Visual Studio 2008.
Notification Services in SQL Server 2005
SQL Server Notification Services is used for developing and deploying applications that generate and send notifications. Notifications are personalized messages sent to a device that subscribes to them.
Using CLR Integration in SQL 05 for Writing Stored Procedures
With SQL 2005 you can harness the power of a higher-level language to not only do more with stored procedures, but also save time by already knowing a popular .NET language.
Real-Time Ambition: Reaching the Potential of Event Processing
Complex event processing (CEP) software delivers on the promise of real-time insight, but is the technology too green for mainstream success? CEP was once available only to big financial institutions and government agencies that could afford custom development projects. That's no longer the case, as off-the-shelf products and implementations have proliferated.
SQL Server 2005 Express Edition - Part 1
Marcin Policht offers an overview of choices offered in the SQL Server 2005 product line, as an introduction to a new series on the Express edition.
Stop SQL Injection Attacks Before They Stop You
This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.
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