(Summer S. Wilson) In one of our applications, we have a couple of “core views”, i.e. view stuff that is used in a couple different places, so we have it in one tidy CFM for easier maintenance. For most of them, the content coming in is the same or similar in nature, however we have one where they a
Author: SSWUG Research
Extending sp_WhoIsActive With context_info
(Jesse Taber) If you work with SQL Server you should be familiar with Adam Machanic’s fantastic sp_WhoIsActive stored procedure. This procedure provides high levels of detail about all commands that are currently being executed on a SQL Server instance. I’ve found it immensely helpful for troublesho
View SQL Server log files offline in SQL Server 2012
(Sandesh Segu) Viewing the SQL server log files when the SQL server instance is offline or not accessible is something that every DBA would always wish to have as this helps in better troubleshooting.
SQL Server Login Management using LOGINPROPERTY function
(Svetlana Golovko) One of the Support Analysts asked me if it is possible to send him notifications 5 days before a user’s password expires for a SQL Server Standard login. He wants to be proactive and help users reset their passwords before they expired. The application uses SQL Server authenticati
SharePoint: Creating site collections…the easier way
(Jason MacKenzie) Anyone who has administered SharePoint will acknowledge that creating site collections and their associated content databases is not the most challenging task they are likely to be faced with.
Search in XsltListViewWebPart
(Dmitriy Kozlov) I had the following problem in our project: my customer has a long list with many text fields. I should give his users a tool for quick navigation in this list, as well as for searching and editing elements.
Accelerating batch processing with IBM DB2 Analytics Accelerator
(Philipp Spaeti) This article provides an overview of the benefits that a company can achieve by introducing IBM DB2 Analytics Accelerator in batch processing systems. The example given is based on a real implementation done at Swiss Re, a major re-insurance company based in Zurich, Switzerland.
The DB2Night Show z35: ‘DB2 V10 Hint Functions for Dynamic SQL’
(Martin Hubel) 92% of our studio audience learned something! Gerry showed the steps to properly enable hints in DB2 10 for z/OS, talking about maintenance levels, and showed the benefits and pitfalls of hints in DB2 10.
SQL Parser
(Jack Vamvas) Question : In my application, I am receiving SQL from other application. I want to validate that SQL text on my client. I don’t want to add the performance overhead to the database , what options are available?
Identifying the Namespaces in an Assembly
(Richard Carr) Sometimes it is necessary to find the names of all of the namespaces that are defined in a .NET assembly. Although reflection does not provide a method for this purpose, it is possible to get this information indirectly.