July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
CLR, Software Development, SQL Scripts, SQL Stored Procedure, SQL Utility
CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task…
Read More

SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, SQL DateTime, SQL Function, SQL Scripts
A year ago I wrote post about SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice where I have discussed two different methods of getting datepart from datetime. Method 1: SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) Method 2: SELECT CONVERT(VARCHAR(10),GETDATE(),111) I have summarized my post…
Read More

SQLAuthority News – Ahmedabad SQL Server User Group Meeting – October 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
MVP, SQL User Group, SQLAuthority Author Visit
Tomorrow is third Saturday of the Month and every third Saturday we have Ahmedabad User Group Meeting. Our user group is growing and getting interesting. Everybody who attended last months User Group (UG) Meeting realized that how important it is to attend UG meetings. UG President Jacob Sebastian (SQL Server…
Read More

SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String
SQL is great with String operations. Many times, I use T-SQL to do my string operation. Let us see User Defined Function, which I wrote few days ago, which will return only Numeric values from AlphaNumeric values. CREATE FUNCTION dbo.udf_GetNumeric (@strAlphaNumeric VARCHAR(256)) RETURNS VARCHAR(256) AS BEGIN DECLARE @intAlpha INT SET @intAlpha =…
Read More

SQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL Backup and Restore, SQL Data Storage, SQL Replication, SQLAuthority Book Review
Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover) by Sujoy Paul (Author) Link to Amazon Quick Review: This is good book for any novice developer to start in the world of database replication implementation and maintenance. Replication is important part of highly availability and one book covers all the concept…
Read More
All Articles exploits_of_a_mom-600x205

SQLAuthority News – SQL Injection – SQL Joke, SQL Humor, SQL Laugh

Pinal Dave
SQLAuthority News
Best Practices, Database, DBA, SQL Humor, SQL Server Security

It has been a long time since I wrote about SQL Humor. Following is the cartoon sent to me by many (more than 10 times) so far by many users. I did not publish it till now as it has been quite popular and I believed many people had already seen it. However, recently by one of the quite big personality asked me why I have not included this in my blog, so I have finally decided to include that in my blog. Let us read humor about SQL Injection.

Read More

SQLAuthority News – Download – Microsoft SQL Server 2008 Feature Pack, August 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download, SQL Utility
Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008. The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of: Redistributable components…
Read More