SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...

SQL Server 2008 Integration Services ships with the wonderful new Data Profiling Task. Much as the name implies, it profiles the data in a given table and returns a ton of useful information. The task ...

PASADENA, USA: DiscountASP.NET, leader in Windows hosting, announces enhancing their SQL Server hosting with the launch of SQL Server Profiling as a service. SQL Profiler is a powerful tool that ...

One of the dreaded error codes we get in the SQL log is the “1205”. It represents the infamous deadlock where two transactions are locking each other out. No way ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 ...

Microsoft has updated its SQL Server Management Studio to version 17.3, adding two features along with various minor enhancements and bug fixes. The Import Flat File Wizard streamlines the process of ...

Power BI experts discuss ways to preserve data types with queries, optimize CPU usage, and connect with Power BI Premium User with SQL Profiler. Chris Webb built off a recent blog topic about enabling ...

This book aims to provide SQL developers with knowledge to get the most out of SQL Server 2012. How does it fare? I did wonder if the next three chapters should be in this book, but I guess as the job ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

This chapter shows the various ways in which different .NET clients can use SQL Server. Knowing how clients use T-SQL code should give you a better insight into how your code is used, and might also ...