The database schema is like a solid foundation for a house, if you want an application that will scale, perform well and be able to support the application growth, then you need to have a strong database design. By the end of this session, you will have a
This paper demystifies query tuning by providing a rigorous 12-step process that database professionals at any level can use to systematically assess and adjust query performance, starting from the basics and moving to advanced query tuning techniques.
On June 5, 2006 MSSQLTips.com started with just one tip in an effort to offer solutions to real world SQL Server problems. Ten years later, we never expected MSSQLTips.com to grow into a global community of millions of SQL Server Professionals.
I need to produce mailing labels from my SQL Server database so I am using the + sign for concatenation the first, middle, and last names together. The issue I see is I get NULL for a lot of rows. This makes me unable to produce the full names. What are
Sometimes you may have issues connecting to SQL Server and you may get messages such as "Could not open a connection to SQL Server". In this tip we look at different things you can check to resolve this issue.
I saw your recent tip on Calculating Mathematical Values in SQL Server and have some related issues as I try to round values in my application. My users and me have a difference of opinion on some of the calculations in our reporting applications. All o
Microsoft SQL Server Extended Events, a replacement for SQL Trace, provides a useful and very customizable framework for managing very technical, low-level event information about a SQL Server database and its instances. However...
In my daily work as a SQL Server DBA, there are many times I want to do things in parallel, for example:
I have a weekly full backup job for multiple big databases on a server, each job step doing one full backup of one database. However due to the size
We are taking a break from the tips format this month to provide you with some Best Practice articles for the many aspects of Microsoft SQL Server development, administration, and support. This article will focus on the use of Windows Groups for security
Do you know how to provide high availability protection for SQL Server without upgrading to Enterprise Edition? Learn how to get robust data protection features for a fraction of the cost of SQL Enterprise Edition with AlwaysOn Availability Groups in this