Posts

How to Fix ( Failed To Create A Phonebook Entry)

Failed To Create A Phonebook Entry |Fix This Error If you are logged on to your PC or laptop using a Guest account. Try to logon using an account with Administrative rights and then try if you are getting the same error ”Failed to create a phonebook entry". If the answer is yes, then try the following… For Windows XP Operating System: First ensure show hidden Files & Folders is checked under folder options. From  My Computer  select  Tools  followed by  Folder Options  then  View.  Under  Advanced settings  tick  Show Hidden Files and Folders  then select  Apply , then  OK. Browse to  C:\Documents and Settings\All Users\Application Data\Microsoft\Network\Connections\Pbk Right click on  Rasphone  file and click  Properties . If the  Read Only  box is checked, remove this, then select  Apply  then  OK . Rename the folder called  pbk  to  pbk.old  close the window and re-test connection. For Windows Vista And Windows 7 Operating Systems: First make sur

SIZE OF TABLES IN SQL SERVER

SELECT t . NAME AS TableName , s . Name AS SchemaName , p . rows AS RowCounts , SUM ( a . total_pages ) * 8 AS TotalSpaceKB , SUM ( a . used_pages ) * 8 AS UsedSpaceKB , ( SUM ( a . total_pages ) - SUM ( a . used_pages )) * 8 AS UnusedSpaceKB FROM sys . tables t INNER JOIN sys . indexes i ON t . OBJECT_ID = i . object_id INNER JOIN sys . partitions p ON i . object_id = p . OBJECT_ID AND i . index_id = p . index_id INNER JOIN sys . allocation_units a ON p . partition_id = a . container_id LEFT OUTER JOIN sys . schemas s ON t . schema_id = s . schema_id WHERE t . NAME NOT LIKE 'dt%' AND t . is_ms_shipped = 0 AND i . OBJECT_ID > 255 GROUP BY t . Name , s . Name , p . Rows ORDER BY t . Name
Image
Elements for IS Auditing An information system is not just a computer. Today's information systems are complex and have many components that piece together to make a business solution. Assurances about an information system can be obtained only if all the components are evaluated and secured. The proverbial weakest link is the total strength of the chain. The major elements of IS audit can be broadly classified: Physical and environmental review —This includes physical security, power supply, air conditioning, humidity control and other environmental factors. System administration review —This includes security review of the operating systems, database management systems, all system administration procedures and compliance. Application software review —The business application could be payroll, invoicing, a web-based customer order processing system or an enterprise resource planning system that actually runs the business. Review of such application software includes acce

PL/SQL Course Coming soon

Image

CASE Statements in A SQL UPDATE Query

UPDATE [account] SET balance = ( CASE WHEN ((balance - 10.00) < 0) THEN 0 ELSE (balance - 10.00) END ) WHERE condition

DBA /BI Engineer Post

Country: Tanzania City: Dar Es Salaam Qualification A Bachelor’s degree in Computer Engineering, Computer Science, Industrial Engineering/Operations  Mathematics, Management Information Systems. Skills in Database operations, SQL queries, etc Knowledge of best practices and principles for ETL, data modeling, dashboards, report design, analytics, and data mining Strong work ethic Ability to multi-task effectively and be comfortable working in a fast-paced, dynamic environment without close guidance or supervision Strong leadership skills Excellent verbal and written communication skills High degree of attention to detAILS dEADLINE 16/07/2013

Find Last Day of Any Month (SQL Server)

a) Find the last day of the previous month, current month and next month. Last Day of Previous Month SELECT  DATEADD ( s ,- 1 , DATEADD ( mm ,  DATEDIFF ( m , 0 , GETDATE ()), 0 )) Last Day of Current Month SELECT  DATEADD ( s ,- 1 , DATEADD ( mm ,  DATEDIFF ( m , 0 , GETDATE ())+ 1 , 0 )) Last Day of Next Month SELECT  DATEADD ( s ,- 1 , DATEADD ( mm ,  DATEDIFF ( m , 0 , GETDATE ())+ 2 , 0 )) b) . Last day of any day specified. Last Day of Any Month and Year DECLARE  @dtDate  DATETIME SET  @dtDate  =  '8/18/2007' SELECT  DATEADD ( s ,- 1 , DATEADD ( mm ,  DATEDIFF ( m , 0 , @dtDate )+ 1 , 0 ))