Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Utility
Today, we will examine something very simple and very generic that can apply to hordes of programming languages. Let’s take a common question that is frequently discussed – What is difference between Line Feed (\n) and Carriage Return (\r)? Prior to continuing with this article let us first look into…
Read More

SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Policy Management, SQL Scripts, SQL Server Security
This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various policies for reliable configuration of the…
Read More
All Articles errortrigger-555x400

SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Trigger, sqlcmd
I had previously written two articles about an intriguing observation of triggers online. SQL SERVER – Interesting Observation of Logon Trigger On All Servers SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution If you are wondering what made me write yet another article on logon…
Read More

SQLAuthority News – TechEd on Road Ahmedabad June 20, 2009 – An Astounding Success

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
MVP, SQL User Group, SQLAuthority Author Visit, TechEd, TechEdIn
TechEd on Road Ahmedabad In India, TechEd was held in Hyderabad in the month of May. You can read myTechEd summary article here. A similar event will be organized in 10 major cities in India. Ahmedabad saw its first TechEd on Road and it was wholeheartedly welcomed by technology enthusiasts.…
Read More