(Greg Larsen) If you are a DBA you probably are responsible for running and monitoring all the SQL Server Agent jobs on one or more SQL Server instances. How do you monitor these SQL Agent jobs? There is always the manual method of monitoring the history of all the SQL Server agent jobs. In this

(Kris Wenzel) In today’s lesson you’re going to learn more about filtering results returned from your queries using the WHERE clause.

(Vinoth N Manoharan) A database may go into suspect mode for various reason most of them are related to corruption of disk or data but SQL server may also put a database in a suspect mode if it’s not able to recover the database properly on restart

(Thomas LaRock) I was going through some old files recently and I came across a folder that was essentially a junk drawer of scripts I’ve put together over the years. I don’t know what to do with most of them now. For example, the isql scripts for some Sybase ASE 11.5 instances aren’t very helpful f

(Audrey and Julie) The BimlScript methods of Business Intelligence Markup Language (Biml) will only work (ie access SQL metadata) with SQL Server versions 2005 and higher. This article briefly tells the story of how Innovative Architects worked around this limitation for one of our projects and succ

(Kenneth Fisher) Quick quiz. Which of these two commands is the opposite of GRANT?

(Pinal Dave) My fascination for computers started way back when I was about to get into highschool. My father once took me to his office (was for some family day if I remember correctly) and it was fun to watch the PC.

(Rohit Garg) The name of the virtual server is always the same as the name of the SQL Network Name (the SQL Virtual Server Network Name). You can change the name of the virtual server, you cannot change the instance name like in the case of standalone named instance.

(Pinal Dave) My day has its own part of long meetings and my daughter tries to pull a string here and there to get my attention almost every other day. And recently I was made to watch one of her school assignment on drawing.

(blakhani) While answering on few forums I have realized that there are some variation of same question which I used in title of the blog.