January 15, 2010 - 12:17 pm
Tags: 246133, knowledge base, logins, microsoft, passwords, sql server 2005, sql server 2008
Posted in Software, computers, microsoft, sql server, windows, windows server 2008 | No comments
This link is very useful and details how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, and Microsoft SQL Server 2008, on different servers. – Microsoft Knowledge Base: #246133
Got this error a lot when trying to add NT user accounts on a SQL Server 2008 installation that was connected to a Windows 2008R2 server running Active Directory 2008 at Windows 2000 functional level. Same error message appeared when troubleshooting this from a SQL Server 2005 instance in the same server environment.
You’ll keep getting [...]
December 27, 2009 - 2:43 pm
Tags: business intelligence, OLAP, OLTP, sql server 2008, SSIS. SSAS
Posted in Software, computers, programming, sql server, windows, windows server 2008 | No comments
Currently reading “Delivering Business Intelligence with Microsoft SQL Server 2008 by Brian Larson”
Interesting quotes/definitions:
“Would you tell me please, which way I ought to go from here?” asked Alice.
“That depends a good deal on where you want to get to,” said the Cat.
“I don’t much care where,” said Alice.
“Then, it doesn’t matter which way you go,” said [...]
December 24, 2009 - 6:21 pm
Tags: adventureworks, azure, cloud computing, database, microsoft, sample, sql server 2008
Posted in Software, computers, microsoft, sql server, windows | No comments
Adventure works sample databases are now available for Microsoft’s SQL Azure at codeplex – click here.
December 6, 2009 - 2:49 am
Tags: azure, msdn, northwind, sql server, wpf
Posted in General, Software, internet, silverlight, visual Studio .Net, websites | No comments
SQL Azure is a fully relational database in the cloud by Microsoft.
See this link for the main website.
For how to connect to Azure using ADO.Net heres a good link from msdn and another link which l’m currently using to work on plugging the northwind sample database to azure and using a WPF datagrid view to [...]
Keep getting the error messages below from the logs:
To view the detailed logs in SSMS 2008:
Drill down on
Management -> data collection -> query statistics -> view logs
====== Error Messages Below=====
Event
Data Code
Message
SSIS error. Component name: DFT – Upload collection snapshot, Code: -1073450974, Subcomponent: SSIS.Pipeline, Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component “ODS [...]
Microsoft Research at this link, provides for free the lecture series of iconic physicist Richard Feynman.
May 24, 2009 - 10:28 am
Tags: sql, sql server 2005, sql server 2008, t-sql
Posted in General, Security, Software, computers, internet, sql server, windows server 2008 | No comments
Useful commands I’ve found from various sources for Microsoft Sql Server 2005/2008 include:
EXEC sp_configure
GO
–Instance level principals.
SELECT * FROM sys.asymmetric_keys
SELECT * FROM sys.certificates
SELECT * FROM sys.credentials
SELECT * FROM sys.linked_logins
SELECT * FROM sys.remote_logins
SELECT * FROM sys.server_principals
SELECT * FROM sys.server_role_members
SELECT * FROM sys.sql_logins
SELECT * FROM sys.endpoints
GO
–Database level principals.
SELECT * FROM sys.database_principals
SELECT * FROM sys.database_role_members
GO
ALTER LOGIN sa WITH NAME [...]
Using Windows 2008 Server Operating system, this allows you to create a server based virtualized computing platform.
An x64-based processor. Hyper-V is available in x64-based versions of Windows Server 2008—specifically, the x64-based versions of Windows Server 2008 Standard, Windows Server 2008 Enterprise, and Windows Server 2008 Datacenter.
Hardware-assisted virtualization. This is available in processors that include a virtualization [...]
On a new instalaltion of SQL Server 2008, running on Windows Server 2008, l cannot connect to SSIS from SSMS (Sql server management console) 2008 running on a client workstation. I can connect from the local server end.
I tried adding the users Group to the permissions option on Component Services/MsdtsServer100 as suggested by many sites [...]
