Tips

Tips

• Configuring and implementing a SQL Server contained database

  Learn how to implement and configure contained databases in SQL Server 2012.  Continue Reading

• The ins and outs of the SQL Server 2012 contained database

  Contained databases could be one of the most important features of SQL Server 2012.  Continue Reading

• SQL Server upgrade paths: What to do before, during, after upgrading

  Planning your SQL Server upgrade is probably the most important step if you want to avoid problems.  Continue Reading

• How to start and set up SQL Server Audit

  Get an overview of the SQL Server Audit process, and check out the details for defining a target, setting up specifications and reading logged events.  Continue Reading

• The lowdown on SQL Server auditing tools

  Learn about the various components of SQL Server auditing tools such as server and database audit specifications as well as action groups.  Continue Reading

• Microsoft SQL Server security best practices checklist

  Authentication, complex passwords and limiting permissions are three of the top bullet points on this SQL Server security best practices checklist.  Continue Reading

• SQL Server high availability: Natural enemy of virtualization?

  Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.  Continue Reading

• SQL Server virtualization: When it's just not a good idea

  Virtualizing SQL Server is a good idea for many IT shops, but it's not for everyone. Robert Sheldon explains when it might not be a good choice.  Continue Reading

• Database index design and optimization: Some guidelines

  What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.  Continue Reading

• SQL Server meets database application security

  Make sure your SQL Server is secure by studying these general guidelines for secure database applications from SQL Server expert Roman Rehak.  Continue Reading

• xVelocity Columnstore Indexes in SQL Server 2012

  Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out.  Continue Reading

• Useful SQL Server 2012 features to become familiar with

  SQL Server expert Roman Rehak shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more.  Continue Reading

• Six top SQL Server 2012 management tools you should know about

  Read this tip from Basit Farooq to learn which time-saving and job-improving SQL Server 2012 management tools you need to know about.  Continue Reading

• Splitting SQL Server backups to multiple files

  Splitting database backups helps save space and run your SQL Server backups more efficiently. Get tips for executing this from Ashish Kumar Mehta.  Continue Reading

• Maximize SQL Server database performance by streamlining your data

  Roman Rehak shows you some quick and easy ways to streamline and improve performance of your SQL Server databases.  Continue Reading