Attend this webinar to learn how Precise for .NET can help pinpoint performance issues by collecting and analyzing performance data from end to end to isolate the root cause of application performance problems.
SQL Server has the ability to scale to very large databases with thousands of concurrent users, but having all of your data in one database is often not the most ideal solution. Learn how replication can play a key part in scaling your database applicatio
There are various options that can be used to create stored procedures. In these next few topics we will discuss creating a simple stored procedure to more advanced options that can be used when creating stored procedures.
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you p
SQL Server 2005 introduced the APPLY operator, which is very much like a join clause and which allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between join and APP
In our organization, I have noticed that database requirements are never included as a portion of the system requirements. The requirements always focus on the interface and we derive the database design from the interface as well as fill in some of the
Get your questions answered related to how to pass through an HR/non-technical screener, resume tips for older professionals, acquiring experience when your company isn’t working with new technology/features, finding cleared jobs and more.
Migrating data from one platform to another requires extensive planning. Some traditional migration methods are easy to use, but they only work for migrations on the same platform. Read this tech brief to see how Quest® SharePlex® can replicate data...
In SQL Server Reporting Services (SSRS), a report sometimes has large text columns that can distort the overall view of the report results and make the report not as useful. In this tip we look at one way of solving this problem and still providing all o
In a previous tip we developed a Personal Finance Calculator in Power BI. In this tip, we will enhance what we did in the first part of the series to get a better understanding of how to use Power BI features.
Learn SQL Server Management Studio productivity tips for launching SSMS from a command prompt, restoring the default layout, changing the default values, saving changes with table re-creation and vertical tab groups.