(Mike Wachal) If you’ve done any troubleshooting of T-SQL, you know that sooner or later, probably sooner, you’re going to want to take a look at the actual statements you’re dealing with. In extended events we offer an action (See the BOL topic that covers Extended Events Objects for a description

(David Bird) You need to edit a SSRS report, but you do not have the source code. How do you get it?

(Mark Prazak) Some of you that attended Convergence may have heard about a significant SQL Server change that can result in substantial performance improvements for Dynamics AX customers.

(Rick Vanover) SQL Server 2008’s backup compression feature allows IT pros to save disk space when making full SQL backups. Database administrators, as well as SQL administrators, have long preferred to have a SQL backup (or a flat file) on disk coupled with transaction log backups on disk for full

(Jason Thomas) Yesterday, I was reading through some articles and happened to glance through a very memorable quote by Berthold Auerbach – “ The little dissatisfaction which every artist feels at the completion of a work forms the germ of a new work “. That was when I realized I haven’t yet complet

(Atif Shehzad) I have to manage a number of SQL Server instances across the network. To access the servers I generally use IP addresses along with a custom port number if one is configured. I could use the server name, but the server names are getting longer and also less meaningful.

Don’t worry, I haven’t suddenly switched the topic of this blog to English grammar, but if you want to learn more about Predicates as they apply to sentence constriction you can start with this article on WikipediA. Rather, today’s topic is about predicates in Extended Events.

(Akbar Ali Bhatti) In this article I would describe how to invoke a web service from within a CLR based Table Valued Function (TVF) and then how to represent the IEnumerable output of that web service as a table directly in SQL Server 2005. I would present two methods of executing a web service to o

(Richard Waymire) SQL Server failover clustering can be intimidating if you’re not used to administering clustered systems. In my earlier post, I discussed how to install Windows and SQL Server in a failover cluster configuration. ENOVIA V6 fully supports using a clustered SQL Server configuration a

(Michael Coles) We all know that dynamic SQL runs in its own scope (see here for details), and that if used improperly it can have serious security implications. But it’s also important to realize that dynamic SQL evaluates your SQL statements more like a stored procedure than a regular script. In