-
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.
-
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.
-
SQL server high availability and 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.
-
When virtualizing SQL Server isn't 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.
-
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.
-
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.
-
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.
-
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.
-
Top SQL Server 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.
-
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.
-
Maximizing SQL Server database performance
Roman Rehak shows you some quick and easy ways to streamline and improve performance of your SQL Server databases.
-
Pros and cons of virtualizing SQL Server environments
What are the pros and cons of virtualizing SQL Server environments? Basit Farooq takes you through the potential good, bad and the ugly.
-
Scaling out SQL Server the easy way
It's never too early to prepare for a SQL Server scale-out. Read this tip from Roman Rehak to learn three popular ways to scale out SQL Server.
-
Index tuning for the reluctant DBA
Many reluctant DBAs find index tuning intimidating. Read this article by Don Jones to learn why index tuning is a must for your SQL Server shop.
-
What to keep in mind when virtualizing SQL Server
Thinking about virtualizing SQL Server? Roman Rehak gives you a rundown about what you should keep in mind when planning your migration.
-
In-memory databases: The implications of integration
How is in-memory SQL Server different from SQL Server with a bunch of RAM? SQL Server guru Serdar Yegulalp explains what to know before you install.
-
Tips for scaling your BI system...in human terms
BI systems are great...if you can get your employees to use them. How do you make your system scalable? Read this tip from Don Jones to find out.
-
Scale out with Windows Azure SQL Database
Scaling out Azure SQL doesn't have to be a painful process. Microsoft Windows expert Bob Sheldon shows you an easier way with Azure SQL federations.
-
Three tricky questions a BI system can answer
Should a small or medium-sized business 'trust its gut' or get a BI system? Don Jones shows three examples of things you can't determine without BI.
-
Introduction to SQL Server 2012 Express LocalDB
SQL Server 2012 Express LocalDB is a good way for developers to be able to play around with SQL Server 2012. Learn how to install and get started with it.
-
Setting up a SQL Server contained database
Learn how to implement and configure contained databases in SQL Server 2012.
-
The SQL Server 2012 contained database's ins and outs
Contained databases could be one of the most important features of SQL Server 2012.
-
Learn about your SQL Server upgrade paths
Planning your SQL Server upgrade is probably the most important step if you want to avoid problems.
-
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.