Skip to content

Glenn Pepper

SQL Server Database Administration

Primary Menu
  • Home
  • About
  • Resources
    • GitHub
    • Links
    • Downloads
  • Music
  • Contact

Random

Generate Random String in SQL

Posted on 6th March 201611th September 2018 by GPepper

There a better ways of generating random strings in your application using PHP, C#, Python or whatever OOP language you are using but if you need to do this at the database level then here’s a clever little trick using a view and an SQL function. Basically you create a Continue Reading

Posted In T-SQLTagged In Random, T-SQL

Recent

  • Troubleshooting Performance Problems
  • Cluster Quorum PowerShell Commands
  • Creating Fake Data for Testing
  • SSRS Database Migration – Cannot View Subscriptions
  • Automating SQL Installs

Tag Cloud

AlwaysOn Automation Availability Groups Backups BATCH UPDATES Best Practice Best Practices BULK IMPORT Clusters Communication Corruption Disaster Recovery DR Email Execution Plans Foreign Keys HTML Indexes Interviews Migration Monitoring Music Off Topic OPENROWSET PHP Post-Rock PowerShell Processing Quorum Random Rant Reference Restores sp_whoisactive SQL Agent SQLCMD SQL Installations sqlps SQL Security SQL Server SQL Server 2012 T-SQL Troubleshooting UPDATE VARIABLES

Categories

  • Always On Availability Groups
  • Automation
  • Azure
  • Best Practices
  • Disaster Recovery
  • Maintenance
  • Monitoring
  • Music
  • Off-Topic
  • PowerShell
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • T-SQL
  • Troubleshooting
  • Uncategorised
Copyright All rights reserved | Theme: Flash Blog by Unitedtheme.