Data Otaku

A seemingly random collection of data- and database-related posts

Posts
  • Data Otaku

    Creating Your First FileTable in SQL Server Denali CTP3

    • 4 Comments
    With SQL Server Denali CTP3 now available , I'm starting to explore some of the new Database Engine capabilities. One that caught my attention is the FileTable . The FileTable builds upon FileStream storage which allows BLOB data to be stored as individual...
  • Data Otaku

    Building a Writeback Application with Analysis Services

    • 3 Comments
    Recently, I delivered a presentation at the 2012 PASS SQL Rally titled Building a Writeback Application with Analysis Services. Based on feedback from that session, I’ve decided to address this topic in my blog, making this information accessible...
  • Data Otaku

    Digital Signing Demo

    • 3 Comments
    This post demonstrates the use of a digital signing function to ensure data within a table is unaltered outside a given set of stored procs. To understand how these and other crytographic functions can be employed to improve the security of database applications...
  • Data Otaku

    Regulate Network Connectivity

    • 2 Comments
    SQL Server accepts client connections over specific network protocols and (for lack of a better term) associated channels. The combination of network protocol, a channel, and the type of communication taking place over it is managed from within SQL Server...
  • Data Otaku

    Cryptographic Function Demo

    • 2 Comments
    This post demonstrates the use of a cryptographic function encrypt data within a table. To understand how the crytographic functions can be employed to improve the security of database applications, please review this post . The first step in the demonstration...
  • Data Otaku

    Securing the Data Warehouse

    • 1 Comments
    After completing a series of posts on Building Secure Database Applications , the question of how the practices and features highlighted apply to data warehouses arose. In a traditional database application, the database is a behind-the-scenes element...
  • Data Otaku

    Writeback Application Code Samples

    • 1 Comments
    In order to help folks get started with writeback applications, I'm posting here an Analysis Services database, it's associated data source, and three sample Excel applications demonstrating different forms of writeback. By downloading these, you assume...
  • Data Otaku

    Build Secure Database Applications with Microsoft SQL Server

    • 1 Comments
    The recent spate of breaches and attacks targeting various business and government computing systems drives home the message that our (collective) systems are at risk from threats both internal and external. As a database professional, I'm inclined to...
  • Data Otaku

    Harden the Database Server

    • 0 Comments
    Reducing the database server’s exposure to attacks (hardening) is a pretty big task. The physical security of the server along with that of the infrastructure on which it depends must be considered. Then there's the network and the operating system...
  • Data Otaku

    Secure the Authentication Process

    • 0 Comments
    SQL Server supports two authentication mechanisms: Windows authentication and SQL Server (SQL) authentication. With Windows authentication, SQL Server simply validates a user’s Windows identity with an identity management solution such as Active...
  • Data Otaku

    Assign Minimal Permissions

    • 0 Comments
    Users should be permitted to perform just those operations required within the context of an application and nothing more. Restricting user permissions in this manner limits the potential for inappropriate data access and database actions. With this...
  • Data Otaku

    Application-Specific Endpoint Demo

    • 0 Comments
    This post demonstrates the use of endpoints to secure application connectivity to an instance of SQL Server. The first step in the demonstration is to create two logins to test the functionality of the endpoints. In the code below, I'm using local...
  • Data Otaku

    Ownership Chain Demo

    • 0 Comments
    This post demonstrates the use of ownership chains to provide controlled access to objects to which a user otherwise does not have permissions. To understand how ownership chains can be employed to improve the security of database applications, please...
  • Data Otaku

    Context Switching Demo

    • 0 Comments
    This post demonstrates the use of context switching to provide controlled access to objects to which a user otherwise does not have permissions. To understand how context switching can be employed to improve the security of database applications, please...
  • Data Otaku

    Module Signing Demo

    • 0 Comments
    This post demonstrates the use of module signing to provide controlled access to objects to which a user otherwise does not have permissions. To understand how module signing can be employed to improve the security of database applications, please review...
  • Data Otaku

    Encrypt the Data

    • 0 Comments
    SQL Server supports the encryption of data through a number of mechanisms. These include: Cryptographic functions for the encryption and signing of individual values, The Transparent Data Encryption (TDE) feature through which the data and log...
  • Data Otaku

    Understanding What-If Analysis

    • 0 Comments
    NOTE This is the first of a series of entries on the topic of Building Writeback Applications with Analysis Services . Business analysts frequently encounter questions focused on the impact of potential change: What if we raised our parts and...
  • Data Otaku

    A Simple Demonstration of What-If Analysis

    • 0 Comments
    NOTE This is the second of a series of entries on the topic of Building a Writeback Application with Analysis Services . To demonstrate writeback with Analysis Services, I’ll leverage a simple model built around a project selection process that...
  • Data Otaku

    Sidebar: The Other What-If Analysis Options in Excel

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building a Writeback Application with Analysis Services . What-if analysis against Analysis Services is just one form of what-if analysis supported by Excel. Other forms focus on spreadsheet...
  • Data Otaku

    A Technical Review of the Simple Demonstration

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building a Writeback Application with Analysis Services and makes direct reference to a previous post containing a simple demostration of what-if analysis . In the simple demonstration of writeback...
  • Data Otaku

    Building a Write-Enabled Cube

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . To build a writeback application, you need a write-enabled cube and an application with which to interact with it. I’ll cover the...
  • Data Otaku

    Building a Custom Writeback Application

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . If you have not read the other posts in this series, you will want to read A Technical Review of the Simple Demonstration before proceeding...
  • Data Otaku

    Sidebar: The MS IT Pattern for Custom Writeback Applications

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building a Writeback Application with Analysis Services . Writeback to cubes through Excel applications is used extensively within Microsoft to support a number of our internal processes, including...
  • Data Otaku

    Understanding Allocations

    • 0 Comments
    NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . In my previous entries on this topic, I’ve been writing data to the Score measure at the intersection of an individual project and...
  • Data Otaku

    Allocation across a Parent-Child Hierarchy

    • 0 Comments
    NOTE This is part of a series of entries onthe topic of Building Writeback Applications with Analysis Services . A parent-child hierarchy consists of members with which values are associated at various levels. A frequently cited example of such a hierarchy...
Page 1 of 2 (38 items) 12