Tutorials
DBA
Dev
BI
Career
Categories
Webcasts
Whitepapers
Today's Tip
Join
Tutorials
DBA
Dev
BI
Categories
Webcasts
DBA
Dev
BI
Categories
SQL Server Transparent Data Encryption Alternative - Free Webinar
SQL Server Functions - User Defined UDF Tips
Browse Categories
Aggregates
Application Development
Change Data Capture
Constraints
Data Science
Data Types
Database Design
Dates
Debugging
Dynamic Management Views
Dynamic SQL
Encryption
Entity Framework
Error Handling
Excel Integration
Full Text Search
Functions - System
Functions - User Defined
Identities
Import and Export
In-Memory OLTP
JOIN Tables
LINQ
Microsoft Access
Microsoft Flow
Paging
Power BI
Python
Query Optimization
Query Plans
Scripts
Service Broker
Spatial Data Storage
SQL Injection
SQL Mgmt Objects (SMO)
Stored Procedures
Synonyms
T-SQL
Table Valued Parameters
Temporal Tables
Testing
Transactions
Triggers
User Defined Type UDT
Views
XML
Concatentation
SQL Server CLR function to concatenate values in a column
Data
Simulating TRY_CONVERT() in SQL Server 2008
Simulating TRY_CONVERT() in SQL Server 2008 – Part 2
Data Validation
SQL Server function to validate Social Security Numbers SSN
SQL Server Regular Expressions for Data Validation and Cleanup
Validate Integer and Decimal Values in SQL Server
Email
SQL Server function to validate email addresses
File System
Extending File System Operations in SQL Server Using CLR
How to execute a DOS command when xp_cmdshell is disabled in SQL Server
Read and Write Binary Files with the SQL Server CLR
Use the SQL Server CLR to Read and Write Text Files
Writing to an operating system file using the SQL Server SQLCLR
Financial
Implement financial functions in SQL Server using C#
Numbers
Implementing Luhn's Algorithm in T-SQL to validate credit card numbers
SQL Server random numerics data generation using CLR
SQL Server T-SQL Code to Calculate a Moving Average
SQL Server user defined function to convert MSDB integer value to time value
Overview
Introduction to SQL Server CLR table valued functions
Understand the Performance Behavior of SQL Server Scalar User Defined Functions
Performance
Computed Columns with Scalar Functions SQL Server Performance Issue
How to find UDFs causing SQL Server performance issues
Refactor SQL Server scalar UDF to inline TVF to improve performance
Random Data
Create Your Own RANDBETWEEN Function in T-SQL
Video on how to create your own RANDBETWEEN function for SQL Server
Search
Standardize Text with Multi Search and Replace Function in SQL Server
Sorting
CLR String Sort Function in SQL Server
How To Calculate Behavioral Streaks in SQL Server Data
Storage
SQLCLR function to return free space for all drives on a server
Strings
Create a SQL Server InitCap Function
Finding a string value in a SQL Server table
Parsing a URL with SQL Server Functions
Remove HTML tags from strings using the SQL Server CLR
SQL Server CLR and SQL split functions to parse a delimited string
SQL Server function to determine if all characters are capitalized
SQL Server UDF to pad a string
System
Generate a parameter list for all SQL Server stored procedures and functions
Tables
Auto Generate Create Table Script Based on SQL Server Query
Tools
SQL Server function to check dynamic SQL syntax
More SQL Server Solutions
