THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Security   (RSS)
Showing page 1 of 9 (90 total posts)
  • Row Level Security–Part 2-Write Operations

    In the first entry in this series (to view, follow this link), I took a look at the how row level security worked with read operations. Now in this entry, I want to expand that to how you use it to limit what a user might write to, or delete from a table. To recap our current situation, we have three users: CREATE USER BigHat WITHOUT ...
    Posted to Louis Davidson (Weblog) by drsql on March 4, 2016
  • Row Level Security – Part 1–Simple Read operations

    This is part 1 of my Row Level Security blogs for my upcoming book project. Row Level Security is a very interesting feature. Unlike Dynamic Data Masking (link), which looks interesting on it's face, once you dig in the utilization of the feature looks to be limited by how granular you can make the security work. Row Level Security on the other ...
    Posted to Louis Davidson (Weblog) by drsql on February 15, 2016
  • Dynamic Data Masking - Part 2–Security and Incorporating into Code

    This is part 2 of my Dynamic Data Masking blogs for my upcoming book project. Part 1 is here: Dynamic Data Masking - Part 1 - The Mechanism. Previously, in my first blog on Dynamic Data Masking - Part 1 - The Mechanisms, we had created the following table (I include this so you can see the DDL of creating the table with the MASKED WITH clause on ...
    Posted to Louis Davidson (Weblog) by drsql on February 8, 2016
  • What you should have read :) during the weekend - weekly SQL Server blogs review part 11

    Hello! It is Tuesday already. I hope you had great last week especially we have Christmas this week J. Maybe you will find some time to read the great posts I prepared? Hope you will have a lot of fun reading all of them.    ...
    Posted to Damian Widera (Weblog) by Damian Widera on December 22, 2015
  • Real World SSIS: A Survival Guide, 8 May, Baltimore

    My friend and fellow Linchpin, Tim Mitchell (blog | @Tim_Mitchell) will deliver a day-long seminar titled Real World SSIS: A Survival Guide the day before SQL Saturday – Baltimore (9 May). Attend and learn more about: Handling warnings, errors, and other bad stuff Data cleansing using SSIS, T-SQL, and DQS More than just a green box: ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 8, 2015
  • Secure Connections Management in SSIS, Part 2

    SQL Server Integration Services (SSIS) is built to move data. SSIS ships with features to support the secure transmission of data. In this series, my goal is to promote awareness of these features and advocate for their use. SSIS Connection Managers In Secure Connections Management in SSIS, Part 1, I demonstrated configuring an SSIS Connection ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 2, 2015
  • Secure Connections Management in SSIS, Part 1

    SQL Server Integration Services (SSIS) is built to move data. SSIS ships with features to support the secure transmission of data. In this series, my goal is to promote awareness of these features and advocate for their use. SSIS Connection Managers Let’s begin by examining ways to connect to a database – any database – using SSIS. ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 25, 2015
  • Administering SSIS: Security-related SSIS Questions

    I credit my friend and brother, Chris Yates (Blog | @YatesSQL), for inspiring me to write this post with his (excellent) post: Reports in SSIS. If I had a nickel for each time I’ve been asked, “What permissions are required for SSIS?” I would have a lot of nickels. It’s a fair question with an unfair answer, “It depends.” “It Depends on ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 19, 2015
  • Third Party Applications and Other Acts of Violence Against Your SQL Server

    I just got finished reading a great blog post from my buddy, Thomas LaRock (t | b), in which he describes a useful personal policy he used to track changes made to his SQL Servers when installing third-party products. Note that I'm talking about line-of-business applications here - your inventory management systems and help desk ...
    Posted to Kevin Kline (Weblog) by KKline on August 12, 2014
  • DevOps for Windows Azure

    ''DevOps'' (Short for Developer Operations) is one of a group of new terms such as ''Cloud'', ''Big Data'' and ''Data Scientist'' - words that are somewhere between marketing and tasks we've actually had around in other forms for years.However, working in a Distributed Environment (Both on and off premises)  like Windows Azure does bring a ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 12, 2013
1 2 3 4 5 Next > ... Last »
  Privacy Statement