Did an upgrade today from SQL Server 2008 R2 CTP [community technical preview] evaluation software to the final RTM [release to manufacturing] version. One thing l noticed – l cant find a service for SSIS – Sql server integrated services – under the usual list of SQL services using SCCM – SQL server configuration manager. [...]
“SQL Server 2008 provides a data collector that you can use to obtain and save data that is gathered from several sources. The data collector enables you to use data collection containers, which enable you to determine the scope and frequency of data collection on a computer that is running SQL Server 2008.” Setup steps [...]
Click here to view my installation by pictures webpage for Microsoft SQL Server 2008 R2
Microsoft Sharepoint 2010 beta software requires the following: Application server role, web server IIS Role SQL Server 2008 native client Microsoft “Geneva” framework runtime Microsoft Chart Controls for Microsoft Framework 3.5 Microsoft Filter Pack 2.0 SQL Server 2008 Analysis Services ADOCMD.NET I attempted to install this on a development Windows 2008 R2 server, which already [...]
Issue: use [MyDB] exec sp_dropsubscription @publication = N’pbMyDBSnapshotPull’, @subscriber = N’YYY\MyDBX’, @destination_db = N’MyDB’, @article = N’all’ GO Result Msg 20032, Level 16, State 1, Procedure sp_MSdrop_subscription, Line 85 ‘YYY\MyDBMOBILE’ is not defined as a Subscriber for ‘YYY\MYDBINSTANCE’. Msg 14070, Level 16, State 1, Procedure sp_MSrepl_changesubstatus, Line 1210 Could not update the distribution database subscription [...]
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 [...]
Notes on setting up the sample database – adventureworks [click here] for Microsoft’s cloud computing sql server called Azure: you need an account – get one from sql.azure.com – it takes some time for your access information to arrive by email. download the sample database using link above extract/unzip to a known location make sure [...]
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 [...]
Adventureworks is a huge sample database of a make believe bike company provider by Microsoft, and l find this particularly useful when working on/learning OLTP and SSAS – ie Online transaction processing as well as SQL Server analysis services used to make business intelligence decisions, datamarts etc. Helpful notes: download the latest version from codeplex [...]