Full Text Catalog Configuration in SQL Server 2005 Express Edition
Having concluded our discussion of Reporting Services in SQL Server 2005 Express Edition, we now begin an examination of Full Text Indexing and Search.
Super Seven Cleanup Steps Before Deploying Your Cube
Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the...
Testing at Scale
It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.
Testing at Scale
It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.
Testing at Scale
It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.
TSQL Challenge 17 - Creating cross rows references with inline hyperlinks
Here is a real world scenario I came across on the MSDN forums. The forum poster wanted a method to dynamically create HTML hyperlinks, for keywords/phrases , within the description of the current column text. Enter this challenge and see how your T-SQL skills match up.
Is C# Better?
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
Grant Execute Permissions to Stored Procedures using DDL Triggers
In your development environment if you have locked down permissions for developers, but still need them to execute stored procedures you will need to grant execute rights each time a new stored procedure is generated. In this tip I will show you a way of doing this automatically each time a new stored procedure is created without granting your developers additional permissions.
Is C# Better?
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
Is C# Better?
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers