about 2 months ago - No comments
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 new book that came out l’ll immediately recommend to anyone – its very concise, real-world
about 3 months ago - No comments
“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
about 5 months ago - No comments
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
about 6 months ago - 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
about 7 months ago - No comments
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
about 7 months ago - 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
about 7 months ago - No comments
Adventure works sample databases are now available for Microsoft’s SQL Azure at codeplex – click here.
about 9 months ago - No comments
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
about 1 year ago - No comments
If you get the error below, “Loading of custom driver failed, forcing null driver mode.” Simply go to customize menu/preferences/viewport/choose driver and select OpenGL – if your graphics card supportsw this, then restart 3ds max. You have to do this for the 32bit and 64bit if you have both installed.
about 1 year ago - 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