-
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.
-
Eight ways that SQL Server developers hurt performance
Application developers who access SQL Server can affect server performance without knowing it. Here are eight things SQL Server developers often do wrong.
-
Coding for seamless SQL Server database mirroring
SQL Server database mirroring can provide high availability to your database. Expert Roman Rehak shares his favorite pieces of code for flawless mirroring.
-
SQL Server stored procedures vs. CLR
Should you use SQL Server stored procedures or CLR stored procedures? Expert Serdar Yegulalp helps you decide which is more appropriate for you.
-
Licensing for SQL Server virtual environments
SQL Server 2012 licensing is complicated enough. Now add in SQL Server virtual environments and try not to let your head spin.
-
Managing linked server security in SQL Server
What do you need to know to effectively manage your linked server? Find out in this tip from SQL Server expert Roman Rehak.
-
SQL Server analytic functions can fix problems quickly
With the help of T-SQL analytic functions, we can quickly solve complex analytical tasks. Learn more from SQL Server expert Basit Farooq.
-
Best practices for preventing a SQL injection attack
One of the sneakiest ways for a hacker to invade your system is via a SQL injection attack. Expert Robert Sheldon explains how to keep hackers out.
-
SQL Server security and user-defined roles
SQL Server security is a topic on many DBAs' minds. But what are the implications of user-defined roles? Expert Serdar Yegulalp explains.
-
More SSIS tips: Parameters and undoing operations
Learn more new tips and tricks for SSIS from expert Robert Sheldon. Check out the last of a three-part series on changes to this important tool.
-
Business intelligence: Don't give it away
With the various challenges SMBs face, securing their business intelligence efforts may seem unimportant. Not so, says expert Don Jones. Find out why.
-
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 Basit Farooq 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.