(Matan Yungman) For most DBAs, Management Studio is the primary work tool.

(Pinal Dave) This blog post is inspired from my earlier blog post of UPDATE From SELECT Statement – Using JOIN in UPDATE Statement – Multiple Tables in Update Statement. In the blog post I discussed about how we can use JOIN and multiple tables in the UPDATE statement.

Steve Wynkoop and I talk a lot about designing and managing our professional careers on a weekly interview on SSWUG.org. This episode was about how to handle assignments that are beneath your grade. This article goes into more detail.

(Sadequl Hussain) When you start MAP, the application prompts you for a database name (see figure below). At the very beginning there will be no database to hold MAP inventory information, so you will need to specify a new database name. You can name it anything, but for our purpose, I have chosen t

(Kenneth Fisher) I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing 3 queries and wondered why the first took significantly longer than the other 2.

(Adamgorge) An SQL Server trace can be used to record events that you are interested in. You can create trace file and trace table workloads easily using SQL Server Profiler.

(Chad Churchwell) As DBA’s we rely heavily on email notifications when things go wrong in our environment such as failed jobs or alerts. In practice this is usually done through Operators in the SQL Server Agent. Recently I was working with a client and noticed a job that had been failing for as far

(James McCaffrey) Graph analysis is becoming increasingly important in software applications. Here a graph is a collection of nodes and edges, not a data visualization such as a bar chart. This article presents a demonstration of how to perform shortest-path analysis using a SQL CLR stored procedure

(Greg Larsen) When building applications that need to display lots of data to a customer, a common practice is to display one page of data at a time. Having your application only show a single page of data requires you to build a paging function, like a button into your application to allow the use

(Pinal Dave) This is one of the most interesting questions I keep on getting on this email and I find that not everyone knows about it. In recent times I have seen a developer writing a cursor to update a table.