Join us for this webcast as we demonstrate how SQL Diagnostic Manager identifies previously undetected performance issues, visualizes complex SQL queries, pinpoints root causes, and generates expert recommendations to tune the performance of SQL queries.
Although there are many different things that can be done to improve the performance of a database system, creating indexes is the main tool in every DBA's toolbox that is used when we are trying to improve the performance of a query.
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and t
One issue that I am often faced with is determining what service pack is installed on the SQL Server. Until recently the version of SQL Server that was installed was just a number, but now with the later service releases for SQL Server 2000 you can also
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
Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email itself
Developers using SQL Server Express face a few challenges in their day to day work. One is that setting up and maintaining Express can be a daunting task. Another is that using the "User Instances" feature (which has been deprecated) leads to a lot of con
The solution is to convert a SQL database into a tabular model sample by making changes in such a way that it looks as if the data model has gone through all the stages of a data warehouse and is ready to be used with a tabular analysis services...
This tip will help you better understand what connection pooling is and provide knowledge on how to take advantage of the connection pooling mechanism when writing .NET data access code that communicates with SQL Server.
In this tip we will provide you with scripts to generate a Custom Intrusion Detection Report. This report will read SQL Server error logs from multiple SQL Servers and filter them based on the list of allowed white-listed connections.