There are many ways to generate random values in SQL Server. In this sixty second video I show a neat trick to get a random value between two numbers.
SQL Server Instance or Database: What Is the Difference?
A SQL Server instance is the engine and a database is one set of data inside it. What each level owns, why a login and a user are different objects, and which line to draw when you separate customers or teams.
SQL SERVER – TRIM Function to Remove Leading and Trailing Spaces of String – SQL in Sixty Seconds #040 – Video
SQL Server has no TRIM function, and calling it gives error Msg 195. This SQL in Sixty Seconds video shows how to remove leading and trailing spaces without it.
SQL SERVER – A List of Various SQL Server RTM and Service Pack Number
Which SQL Server version are you running, and is it the latest? My list of RTM and Service Pack Number values to check your production server against.
SQL SERVER – Send Email From SQL Server – Configure Database Mail – SQL in Sixty Seconds #039 – Video
SQL Server is not mass mailing software, but it does need to send job alerts. This video shows how to configure Database Mail and send email quickly.
SQL SERVER – How to Hide Yourself from SQL Server? – Guest Post by Balmukund Lakhani
Balmukund Lakhani of Microsoft India GTSC writes a guest post with a fun title and a useful trick: how to hide yourself from SQL Server, in his own words.
Sharding by Customer: Routing Queries to the Right Database
Plan sharding by customer with a shard map, parameterized routing and synonyms, and account for reports, keys and customer moves.