Sysmail_help_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 10
Hi friends, in this blog of SQL Server database mail stored procedure we will continue with another database mail stored...
2015-06-15
407 reads
Kapil Singh
Sysmail_add_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 9
Hi friends, in this blog of SQL Server Database mail stored procedure we will continue with another database mail procedure sysmail_add_principalprofile_sp....
2015-06-13
482 reads
Sysmail_help_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 8
Hi folks, in our previous blog of SQL Server Database Mail stored procedure we added database mail account to database...
2015-06-08
414 reads
Sysmail_add_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 7
Hi friends, in last previous blogs we created database mail profile and database mail account. In this blog we will...
2015-06-04
489 reads
What is User Defined function in SQL Server?
User-defined functions encapsulate T-SQL statement and return a table or a scalar value to the caller. UDFs can not be...
2015-06-01
363 reads
Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6
Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp....
2015-05-30
868 reads
Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5
Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account...
2015-05-28
964 reads
Sysmail_help_profile_sp – SQL Server Database Mail Stored Procedure – Part 4
Hi friends, today we will learn how to get information about database mail profile using stored procedure sysmail_help_profile_sp. Sysmail_help_profile_sp stored...
2015-05-26
332 reads
Find blocking using sp_who in SQL Server
Hi friends, in this blog I will tell you how can we find blocking using sp_who system stored procedure. Also,...
2015-04-22
287 reads
How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server
Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating...
2015-04-18
226 reads
Blogs
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
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...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
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