Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, CRM, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, Oracle, OS, Routers, RPG, RPGLE, SAP, Security, Servers, SQL Server, SQL Server 2005, Storage, Virtualization, Visual Basic, VoIP, VPN, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
Not sure what's going on here. I created the following query to produce quantity results by month: SELECT CONCAT( MONTHNAME(published) , ' ' , YEAR(published)) AS monthyear, COUNT(*) AS total FROM blog_articles WHERE status = 'Online' AND Year(published) = 2013 GROUP BY CONCAT( MONTHNAME(published)...
We just got a new machine but everything was already installed on it, including SQL Server 2008 R2 and Visual Studio 2010 SP1. However, I don't have any intellisense in SQL Server Management Studio (aka it's not working). What should I do?
I’m having problems connecting to my database remotely in SQL Server 2008 R2. I get the following error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct...
How many remote notifications can a user have?
How can I unlock my inbox. I currently have three emails in my inbox (sent them from an old Android phone, but I have a new Samsung) and cannot access?
Is it possible to scan our active directory and see if people have weak passwords? We have upped the password policy but what about for users that already have passwords and are not scheduled to changed them yet?
Here's my scenario. I fall under guidelines of HIPAA. I have mobile users using laptops and tablets loaded with Cisco VPN CLient connecting to my Cisco 2811 ISR which functions as my router/firewall/VPN. I am using Micorosoft AD in my domain. To authenticate users to the domain. Is there an easy...
Cisco VPN worked great for several months and now will not establish connection. Info below. What's going on?Cisco Systems VPN Client Version 5.0.07.0440Copyright (C) 1998-2010 Cisco Systems, Inc. All Rights Reserved.Client Type(s): Windows, WinNTRunning on: 6.1.7601 Service Pack 1336 16:47:20.996...
Which is the proper way to store and date times in SQL Server 2008?datetimedatetime2I know the majority of differences between the two but should we just use datetime2 only?
Hi, I am acessing AS400 through Cirtix client. I am facing function key issues. For me some of the function keys are working well, but few are not working. Ex: F13, F15, and F24. If I hit F15, it asks me to disconnect the session. For F13, its showing me the windows Start menu. I have checked the...
I have email active on my phone but cant remotely search for old emails from my phone, because there is no option for it. I have compared the results with some other BB phones, but they all have option to either search the handheld/remotely. please help out.
How can I create a table variable (virtual in-memory table) with columns that match the stored procedure resultset? I tried to execute the procedure using column names I specified. Does the data type of the columns need to be the same as the stored procedure? Here is what I tried:DECLARE @Table...
Hi Group,I need a copy data from a file having 20 million records to another file. What could be best way to achieve this? One way is creating a duplicate object. Is there any other method?Regards,M
Hi.. I need to create a window subfile in RPGLE, and the subfile field values should be taken from the array which is defined in program itself. Can anybody give me the sample code for this? Surey
I’ve built a SQL Server table with several columns with an index starting from 1 as the primary key. I need to clone this table but without the data and with a different index starting from 100. I don’t know how to do this. I am using SQL Server 2012 Express that came with Visual Studio 2012.
Can someone help me with this question: RAID Levels, Hardware issues,choice of RAID level and improvement in performance via parallelism
Why would an undefine report attached itself to the bottom of a report that is defined?
I installed Ubuntu onto a WinXPP machine so that they are duo boot. The system should have automatically mounted my windows directory and created an icon on the desktop. It did not. I followed the directions and opened a bash shell and typed sudo vol_id -u /dev/sda1 Ubuntu returns the error command...
I run a system comprised of 36 IBM Blade servers, a Hitachi 64TB SAN, a Data Domain backup suite and connection devices. I run Windows 2003 R2 (32bit) and Red Hat 4 (64bit). I have just come across a problem in that all the windows blades in one (of three) chassis are displaying my drive E: (which...
I have three tables in SQL Server 2008 and they all have the PK-FK-FK-relationship. 1st table: I have a column name with the name as "STATUS" that contains the value "active" or "inactive". 2nd table: I have the column with the name FKNEWLoanReviewfieldid, which has multiple values 3rd table: The...