Globally Unique Identifier (GUID)
What is a GUID? GUIDs are large, enormous numbers that are usually 128 bits long and look like […]
Database
SQL Server Sequence
What is sequence? SQL Server sequences allow you to store a sequence of numbers. You are in control […]
SQL Server Sequential Numbers Part 4
Our query will create sequence numbers. This is part 4. We other posts called SQL Server Sequential Numbers […]
SQL Server Exception Handling Part 14
This post is a continuation of our SQL Server project that uses exception handling, except that here we […]
SQL Server Finding String Length
Suppose you have a table with a column that needs some data validation performed on it. The data […]
Blockchain Implementation
How do you get started using blockchain? First of all you want to be sure that your specific […]
SQL Server Summarizing Data Part 4
This post is part of the series on summarizing data but it gives us a more simple example […]
SQL Joins Introduction
For this post we assume you have some basic knowledge of SQL. A JOIN clause is used to […]
SQL Server Options
There are some options (settings/preferences) that you can configure in SQL Server. To do that in SSMS (SQL […]
SQL Server Wrong Server Name
In your SQL Server code are you using @@SERVERNAME? This can return the wrong information. For me it […]
SQL Server Security Introduction
SQL Server security is a big topic. If you don’t know much about it then it will take […]
SQL Server Merge
Sometimes in SQL Server you need to create a summary table from a transaction table. Transactions are coming […]