This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, Using .NET features to prevent attacks, and Importance of handling exceptions
2007-09-19
4,869 reads
The CLR integration in SQL Server 2005 greatly expands on the capabilities of the SQL Server platform. One new area is the ability to build user-defined types and user-defined aggregates. Solomon Rutzky brings us a way to get around some of the limitations in this area with his SQL# toolkit.
2007-09-18
5,660 reads
In the latest in their popular series on 'Unit Testing' database development work , Alex K and Alex S give some examples of unit testing Database Modifications
2007-09-18
3,422 reads
We've compiled a list of our dozen most popular tips in the area of upgrading to SQL Server 2005 and they run the gamut.
2007-09-18
4,268 reads
Everyone wants to know what a DBA does and it is becoming a hard question to answer as the responsibilities and capabilities of database platforms increase. Longtime author Vincent Rainardi brings us the proposition of a new type fo DBA, one that focuses more on data warehousing.
2007-09-17
8,500 reads
There's a free event in Indianapolis for SQL and .NET developers. It's on October 13th and it's jointly sponsored by the .NET and SQL users groups. If you're in the area reigster and support this group.
2007-09-17
595 reads
An article explaining where to find packages when saved to SQL Server.
2007-09-17
3,092 reads
2007-09-14
3,449 reads
Business Intelligence Architect Bill Pearson introduces the basic .Properties function, within the first of a two-part article surrounding this important member of our MDX toolsets.
2007-09-14
2,842 reads
Take a look at a sample chapter and see who won copies of this book from our Question of the Day Contest.
2007-09-13
2,762 reads
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I'm running a group MSA for the database engine and SQL Agent in a...
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Comments posted to this topic are about the item Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers