Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    Microsoft Enables Database Auditing on Azure SQL Data Warehouse

    By
    Pedro Hernandez
    -
    October 9, 2015
    Share
    Facebook
    Twitter
    Linkedin
      cloud database

      Microsoft is eliminating a blind spot for businesses looking to keep their cloud databases safe and compliant with regulations affecting how their industries manage and secure data.

      Matt Usher, senior program manager, Microsoft SQL Engineering, announced in a blog post that the database auditing feature on Azure SQL Database has been enabled for customers to use. “Using a very simple and intuitive configuration interface, you can now have auditing up and running on your database within minutes,” he said.

      Configuring database auditing is straightforward and requires that administrators specify the Azure Storage account the service writes audit logs to, said Usher, noting that the logs count against a customer’s cloud storage plan. “Once auditing has been enabled, an Azure Table is automatically created on that designated storage account, and records for selected events (based on what you configured) are written to that table,” stated Usher.

      Naturally, Microsoft also provides ways to view and interpret the audit data.

      “To view the logs, you can connect to the Azure Storage account via your tool of choice, such as Azure Storage Explorer, or via our predefined Excel dashboard and reports template, which can retrieve the logs from your Azure Storage Account using Power Query,” said Usher. Power Query is an Excel add-on that links Microsoft’s spreadsheet software with its cloud-based business intelligence offering, Power BI.

      Recorded events can help businesses spot activity that not only puts their data at risk, but also places them in the cross hairs of regulatory bodies.

      One use for the new database auditing feature is to sniff out signs of authorized access and other suspicious activities. “An analysis of audit data can expose discrepancies and anomalies in data-related activities across the organization. This can lead to the identification of potential security incidents,” Usher said.

      Another, less obvious use of the audit data is as a business performance indicator.

      Data that reveals changes in database activity can provide business managers with an early warning system, of sorts.

      Usher asserted that an audit trail “can readily be used to enhance business visibility; such data can help to identify business trends or potentially indicate business concerns. For instance, an analysis of the data may identify a drop in activity levels over time in a database located in a particular geographic location, which can then be addressed by the business.”

      Finally, and perhaps must crucially for businesses operating in regulated industries, the database auditing helps keep the lawman away.

      “Auditing is a valuable tool that can be used to help organizations meet various industry compliance requirements and regulations, such as PCI DSS [Payment Card Industry Data Security Standard], SOX [Sarbanes-Oxley] or HIPAA [Health Insurance Portability and Accountability Act],” Usher said. “Many such regulations require an audit trail on data-related activities against the underlying databases.”

      Auditing only goes so far, Usher said. Often, it can only expose problems, not prevent them. “It remains the organization’s responsibility to ensure the application design and database practices are implemented to adhere to the required corporate or industry security and compliance standards,” he said.

      Pedro Hernandez
      Pedro Hernandez is a contributor to eWEEK and the IT Business Edge Network, the network for technology professionals. Previously, he served as a managing editor for the Internet.com network of IT-related websites and as the Green IT curator for GigaOM Pro.

      MOST POPULAR ARTICLES

      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Cloud

      Yotascale CEO Asim Razzaq on Controlling Multicloud...

      James Maguire - May 5, 2022 0
      Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Applications

      Cisco’s Thimaya Subaiya on Customer Experience in...

      James Maguire - May 10, 2022 0
      I spoke with Thimaya Subaiya, SVP and GM of Global Customer Experience at Cisco, about the factors that create good customer experience – and...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×