(Richard Carr) SQL Server allows data in selected columns from entire tables to be indexed, in order to improve the performance of some queries. SQL Server 2008 introduces the concept of filtered indexes. These index a limited set of the rows in a table.
Author: SSWUG Research
PowerShell Basics: Using Variables
(Scott Mattie) Variables are a fundamental part of Windows PowerShell. They’re quite different from the variables in Cmd.exe. In Cmd.exe, all variables are environment variables, which you primarily access with the Set command. The environment variables can store only strings of text.
Find Orphan SQL Users and Fix using ALTER USER
(Vinoth NM) For years i have been using syslogins and sysusers tables in a cursor to find orphan users and sp_change_users_login to fix orphan users in SQL Server database.
Copying and Pasting data between ListViews and TextBox
(Ged Mead) I saw a forum post recently (not on VB City but another VB developers’ site) where the question was asked: “How can I copy items from one list view to another?”. The answer that was posted looked like this:
Visual Studio Tip: The Difference Between Start Without Debugging and Start with Debugging
(Peter Vogel) This isn’t so much a tip as a clarification: I often find that people are confused about what happens when you press F5 vs. when you press Control_F5. Here’s the best description I’ve found (and it’s from the blog where I’ve found most of the Visual Studio tips that I talk about here).
ODI 12c – Getting up and running fast
(David Allan) Here’s a quick A-B-C to show you how to quickly get up and running with ODI 12c, from getting the software to creating a repository via wizard or the command line, then installing an agent for running load plans and the like.
Constraints (Part 4) – ORA-02299
(Andrew Reid) This was tested on an Oracle 11.2 database. As I have already said, you can add a constraint when a table is created or you can modify an existing table as shown below:
Reproducing WebLogic Stuck Threads with ADF CreateInsert Operation and ORDER BY Clause
(Andrejus Baranovskis) This is a second post related to WebLogic Stuck Threads. You can read the first one – Evil Behind ChangeEventPolicy PPR in CRUD ADF 12c and WebLogic Stuck Threads. In the previous post, I was describing how to reproduce WebLogic Stuck Thread in ADF 12c, with ChangeEventPolicy
What’s the easiest way to create an XML document in C++?
In some recent posts, I’ve been sharing with you how we develop software at Trade-Ideas. Before I answer the question above, I think we should take a moment to ponder the question. What’s the easiest way…
SSWUGtv: Steve talks to DH2i’s Founder and CEO, Don Boxley regarding the launch of its brand new DxConsole High Availability Disaster Recovery (HADR)
Video Programming for IT Professionals