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 [...]
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 [...]
Passed my Microsoft Cerfification Exam on first attempt on Tuesday June 2nd! Score: 814 The certificate says l’m now recognized as a MCTS – Microsoft Certified Technology Specialist: SQL Server 2008, Implementation and Maintenance. The exam is the MCTS 70-432. Next goal is the 70-450 which has no study book in print, and the only [...]
If you keep getting this error: The DELETE statement conflicted with the REFERENCE constraint “FK_subplan_job_id”. The conflict occurred in database “msdb”, table “dbo.sysmaintplan_subplans”, column ‘job_id’. The statement has been terminated. (Microsoft SQL Server, Error: 547) RUN: (1) Use MSDB GO Delete from sysmaintplan_subplans Where subplan_name = ‘xyz’ GO If theres a reference error to sysmaintplan_log, [...]
Cannot insert the value NULL into column ‘owner_sid’, table ‘msdb.dbo.sysjobs’; column does not allow nulls. INSERT fails. If you get the above message, make sure you set the login correctly in the script you are attempting to run: For example, on my script that causes the error above, changing @owner_login_name=N’sa’, to @owner_login_name=N’stevesadminaccount’, Obviously logging in [...]
Trying to un-install a Microsoft Heros event 2008 release of SQL Server 2008 on my Windows 2008 server box but each time l uninstall it and all related components, on trying a fresh install for a default instance l keep seeing the previous default MSSERVER instance. Heres the link to Mark Michaelis Weblog which has [...]