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, Servers, SQL, 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
I have a business client uses Microsoft Hosted Exchange. One of the 15 users is having difficulty creating appointments in shared calendars. On one PC, she uses Office 2007 with Outlook 2013, and on another, Office 2013. In the shared calendars, when this user tries to add an appointment to any...
I have 5 PF. Now I want to select data from my PF and selected data need to convert into XML. Please give me guidelines, how do I do a step-by-step?
What do you understand by loop in flowchart?
I want to write a function that returns a tuple of (start,end) where start is the Monday at 00:00:00:000000 and end is Sunday at 23:59:59:999999. start and end are datetime objects. No other information is given about day, month or year. i tried this functiondef week_start_end(date):start=...
HI ,I'm currently learning Oracle. Is it wise to Take up MCSE :Data platform as well to get a fill for both platforms ?
I'm rewriting an application for my company which requires a database. I will be updating the database using SQL Server 2008 R2. Now, here's my big question: Should I use PostgreSQL 9?Note: I won't be doing any conversions so that's not a problem.
I am trying to count logins by hour, by month, etc., in SQL Server 2008. To do this, I believe I need to create two PIVOTs or an UNPIVOT and then PIVOT? However, I can't seem to make it work. SELECT loginid ,DATEPART(MONTH,logtime) Month , DATEPART(HOUR, logtime) Hour FROM somelog (nolock) ) temp...
I just recently moved my .NET Development over from a Core2Duo to a new Core i7-3820 machine. No changes were made to the project code and both run on SQL Server 2012 Express.For the past week, I've seen a dramatic slowdown with INSERT INTO commands. Can someone tell me why this is happening?...
after a migration from winxp to win7, my encrypted *.enp files cannot be opened. i have sensible data there and cannot open them with any program. i really need some help.many thanksana
I have configured my server with a static IP and installed SQL Server 2008 R2 with ITAPP. The following happens when I use the IP to access SQL Server: Client Machine: sqlcmd -S XXX.XXX.XXX.XXX -U sa -P mypass A successful connection! But when I use: sqlcmd -S XXX.XXX.XXX.XXX\ITAPP -U sa -P mypass...
This is more a general question but a friend of mine is in the business of making websites and applications that aren't mission critical. So with that, is it bad practice to use the NOLOCK hint in SQL Statements? He was told by an SQL administrator that he should use it if he's satisfied with a...
How to give access to the sign off database for user?
How do I get the weather to show up in the notification center on my iPhone 5?
I have a weird problem. Why in the the following SQL query does print 'equal' when run against SQL Server 2008. The database compatibility level is set to 100. if '' = ' ' print 'equal' else print 'not equal'And this returns 0: select (LEN(' '))I think its auto trimming in space. Anyone know if...
I have installed, uninstalled and installed Adobe Reader again, and get Acrobat failed to connect to a DDE Server message. Could open PDF files when we had XP on other computer but not able to since we got Windows 7 on new computer. Have not been able to save and open in another window either....
I'm trying to connect to SQL Server 2008 R2 using Windows authentication. However, I can't because I keep getting this error:Login failed for user 'AVATOPIA\ian'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]Now, I can log in...
How to check the status of offline backup in brtools
Hi, I have a requirement where I need to send data/file to server using HTTP from my AS/400 server and then receive a response back from web server. Web server is using Java/PHP to accept data files. Please advise me an approach to do this. Thanks in advance.
While using SQL Server 2008 R2, I was able to execute ASCMD SSAS queries. We recently upgraded to SSAS 2012 servers and I hope to reinstall all my maintenance scripts. I can't find any ASCMD tools in SQL Server 2012, nor any documents on the internet. When I try to execute a query I get the...
Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process: Get file from local or FTP Delete the old file which doesn't exist anymore in the database Insert only new records in the database Automated Don't overheat SQL...