Pages
-
Recent Posts
Tags
3d 3ds max 2009 24 64bit 2010 2012 adobe adventureworks africa ajax android animation asp asp.net azure basketball Beijing benchmark big brother camera canon China chiwetel ejiofor cinebench r10 cloud computing cs4 database data collection dell ella wheeler wilcox linux microsoft nigeria nvidia samsung silverlight sql server sql server 2005 sql server 2008 sql server 2008 R2 SSRS ultimate vista windows wpfMeta
Blogroll
Tag Archives: sql server 2008
MCITP Exam 70-450
Microsoft Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 Passed this exam on 5/25. It rained heavily all day. Books for this exam arent really out yet, even from Microsoft. Theres a … Continue reading
Posted in General
Tagged exam 70-450, kaaplan, MCITP, MCP, selft test software, sql server 2008, tom carpenter
Leave a comment
SQL Server 2008 Data Collection..
“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 … Continue reading
Posted in Software, sql server, windows server 2008
Tagged data collection, dmv, management, sql server 2008
Leave a comment
Installing Sharepoint 2010 Beta..
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 … Continue reading
Transferring logins and passwords between SQL Server 2005 and SQL Server 2008
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
Posted in Software, computers, microsoft, sql server, windows, windows server 2008
Tagged 246133, knowledge base, logins, microsoft, passwords, sql server 2005, sql server 2008
Leave a comment
Microsoft SQL Server, Error: 15401
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 … Continue reading
Posted in Software, computers, microsoft, sql server, windows, windows server 2008
Tagged 1501, error, microsoft sql server, sql server 2008
Leave a comment
Azure sample database setup….
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 … Continue reading
Posted in Software, computers, microsoft, programming, sql server, visual Studio .Net, websites, windows, windows server 2008
Tagged adventureworks, azure, microsoft, sql server 2008
Leave a comment
Business Intelligence w/SQL 2008
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 … Continue reading
Posted in Software, computers, programming, sql server, windows, windows server 2008
Tagged business intelligence, OLAP, OLTP, sql server 2008, SSIS. SSAS
Leave a comment
Azure SQL….
Adventure works sample databases are now available for Microsoft’s SQL Azure at codeplex – click here.
Posted in Software, computers, microsoft, sql server, windows
Tagged adventureworks, azure, cloud computing, database, microsoft, sample, sql server 2008
Leave a comment
collection_set_3_upload job keeps failing on uploading Query Statistics – SQL Server 2008
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. … Continue reading
Posted in General, Software, computers, sql server
Tagged data collection, query statistics, sql server 2008
Leave a comment
Microsoft Sql Server Administration…
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 … Continue reading
Posted in General, Security, Software, computers, internet, sql server, windows server 2008
Tagged sql, sql server 2005, sql server 2008, t-sql
Leave a comment