Browse by Tags

Tagged Content List
  • Wiki Page: SQL Server 2012 Early Adoption Cook Book

    Table of Contents Introduction Wiki Page Index Other Great Early Adoption Resources Introduction If you want to skip all of this and go right to the content click here . Microsoft creates a lot of content designed to drive early adoption for new releases of SQL Server. We use this as a tool...
  • Wiki Page: How to Check when Index was Last Rebuilt

    I have executed the script (given on below link) to rebuild all table indexes on SQL Server, but how do I know whether it is updated or not. SQL Script for rebuilding all the tables’ indexes Now the problem is that SQL Server does not store the information when all the indexes were rebuilt...
  • Wiki Page: SQL Server: No Fragmentation in HEAP from INSERT / UPDATE

    A HEAP won't be "fragmented" in two cases: - only INSERTS may occur - UPDATES will occur in the attributes with fixed data length (e.g. char ) The following example demonstrates the above mentioned situations: First a simple HEAP will be created: 01. USE tempdb; ...
  • Wiki Page: Database Engine Security Checklist: Database Engine Security Configuration

    This checklist reviews key security configuration options for the SQL Server Database Engine. Use this checklist to periodically audit your Database Engine environment. These recommended settings should be adjusted based on your security and business needs. Table of Contents Physical Security Operating...
  • Wiki Page: Database Engine Security Checklist: Limit Access to Data

    This checklist helps you review how you limit access to data in your organization. Use this checklist to periodically audit how users access information stored in the SQL Server Database Engine. Access to the Instance of SQL Server These items relate to the entire instance of the Database Engine...
  • Wiki Page: Database Engine Security Checklist: Enhance the Security of Database Engine Connections

    This checklist reviews key options to use when connecting to the SQL Server Database Engine. Use this checklist to review your environment to make sure that connections are made to the Database Engine as securely as necessary for your business needs. Database Engine Configuration ....
  • Wiki Page: Database Engine Security Checklist: Encrypt Sensitive Data

    This checklist helps you confirm that encryption is used appropriately in your environment. Use this checklist to periodically audit your use of encryption with the SQL Server Database Engine. Database Level ... Description Have you evaluated encrypting...
Page 1 of 1 (7 items)
Can't find it? Write it!