↓ Skip to Main Content
Vedran Kesegic Blog

Vedran Kesegic Blog

Main Navigation

  • Home
  • Download XDetails Add-in
Home › Archive for Security and encryption

Category: Security and encryption

Confusion between Login and User in SQL Server

By Vedran Posted on 2018-04-28 Posted in Security and encryption No Comments

There is often confusion between Login and User in SQL Server. What is the difference and what is the link? I hope to clear that out in this short video:

Procedure with Execute as login?

By Vedran Posted on 2013-03-24 Posted in Security and encryption 7 Comments

Sometimes we need a low-privileged user to do a specific administration task or task that require some server-level permissions (such as VIEW SERVER STATE, ALTER TRACE etc). Of course, we do not want to give that account server-level privilege, because …

Procedure with Execute as login? Read more »

Our Mission

Our Mission

Databases should be fast and simple to use. We make them so. Do not let your customers wait for a slow database response - hire a top professional! We are passionate about creating highly-tuned SQL Server systems. Do you want yours to become one? Simply call us or send email, and we will take care of the rest.

Vedran Kesegić, M.Sc.
SQL Server Database Consultant
Email: vedran.kesegic@gmail.com

A Random Thought

Backup of corrupted database is worthless. If you do not run regular DBCC CHECKDB, your backups might be worthless.

Categories

  • Backup and Recovery
    • Transaction Log
  • BI
  • Conferences
  • Data Engine
  • Performance
  • Security and encryption
  • Storage
  • TSQL and SQL Client Code
  • Uncategorized

Recent posts

  • How to pass arrays to SQL? TVP – The Ultimate Guide
  • SQL for absolute beginners
  • 4 tips to Boost Performance of Azure SQL Server
  • How NOT to use CROSS APPLY
  • Capacity Calculator for Storage Spaces
© 2022 Vedran Kesegic Blog | Powered by Responsive Theme
Visit Us On TwitterVisit Us On FacebookCheck Our FeedVisit Us On LinkedinVisit Us On Youtube