Category: Fundamentals

• The Hidden SQL Server Gem: UPDATE from SELECT

  

  2015-08-19 - Fundamentals, General, Queries, T-SQL Statements

  Sometimes we need to update data in one table based on the contents of one or more other tables. Discover how the UPDATE from SELECT variation of SQL Server’s UPDATE statement provides an easy way to achieve this.

  [more…]

• Partition Boundaries – Left or Right: That is the Question

  

  2014-07-16 - Fundamentals, General, Series, SQL Server Internals, Storage Wednesday

  Do you know the difference between a RANGE LEFT and a RANGE RIGHT partition function? Read on and discover a unique query to determine the actual partition a row is stored in. With this query you can quickly confirm your RANGE-assumption or find out where you got it wrong.

  [more…]

• How to Change a SQL Login’s Password

  

  2014-04-04 - Fundamentals, General, Security

  ALTER LOGIN can be used to change the password of a SQL Login. Read on to see the required permissions and what you need to do to change your own password.

  [more…]

• Cryptographic Terminology – A Glossary

  

  2014-03-21 - Cryptographic Terminology, Cryptography, Fundamentals, General, Security, Series

  Cryptographic terminology can be sometimes somewhat “cryptic”. This post starts out a series to provide a glossary of cryptographic terms. Each post in this series will cover one cryptographic expression in detail.

  [more…]

• The Mystery of the SUSER_NAME() and SUSER_SNAME() functions

  

  2014-01-11 - Fundamentals, General, Security

  The SQL Server functions SUSER_NAME() and SUSER_SNAME() both return the current login name. So why are there two? Read on to find out what the difference is.

  [more…]