Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  SQL Server 2008
Tagged Content List

  • Wiki Page: SQL Server Express: Troubleshoot Installation

    This article contains information on common problems that occur during the installation of SQL Server Express, why they occur and how to resolve them. If you have encountered and resolved a problem that is not listed, or have information to contribute to the resolutions already listed, please edit...
    on14 May 2013

  • Wiki Page: Exam 70-450 - PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

    Table of Contents Overview Skills Measured Preparation Materials Community Related Forum Posts Overview Language(s): English, French, German, Japanese, Spanish, Chinese (Simplified) Audience(s): IT Professionals Technology: Microsoft SQL Server 2008 ...
    on13 May 2013

  • Wiki Page: How to Reset MS SQL Server 2008 Password

    I’ve forgotten the password of SA account, therefore I am not able to login to my SQL Server 2008 R2. I have another account, but with no special privileges. Anyone here can tell me how to reset SQL Server 2008 password ? Thanks in advance. Users who don’t regularly log into the SQL Server database...
    on13 May 2013

  • Wiki Page: Effective Database Engine Permissions

    This topic describes how to determine who has permissions to various objects in the SQL Server Database Engine. SQL Server implements two permission systems for the Database Engine. An older system of fixed roles has preconfigured permissions. Beginning with SQL Server 2005 a more flexible and precise...
    on9 May 2013

  • Wiki Page: Notas de Versão do Microsoft SQL Server 2008 SP2 (pt-BR)

    Clique aqui para alterar o idioma . Table of Contents Sumário 1.0 Novidades no Service Pack 2 2.0 Antes de instalar o Service Pack 2 2.3 Todos os recursos de uma instância do SQL Server devem ter a mesma versão antes de aplicar uma atualização cumulativa 3.0 Notas de Versão da Versão Original...
    on8 May 2013

  • Wiki Page: Grain (OLAP)

    Overview In SQL Server Analysis Services (SSAS) , the grain or granularity of a fact defines the level of detail recorded in the fact; it is determined by the dimension keys of the fact. If a fact references the key attribute of a dimension, then it records data at the most descriptive level of...
    on8 May 2013

  • Wiki Page: Snowflake Schema

    Overview In SQL Server Analysis Services (SSAS) , snowflake schema describes a popular data model for relational data warehouses. Similar to a star schema , a snowflake schema contains fact and dimension tables, with the fact table storing facts about business transactions and some columns...
    on2 May 2013

  • Wiki Page: Unified Dimensional Model

    Table of Contents Definition Components Community Resources See Also Other Languages Brazilian Portuguese (pt-BR) German (de-DE) Definition The Unified Dimensional Model (UDM) is the model for data in a SQL Server Analysis Services (SSAS) database. The UDM is unified because it combines data...
    on1 May 2013

  • Wiki Page: Star Schema

    Overview In SQL Server Analysis Services (SSAS) , a star schema describes a common data model for relational data warehouses. In a star schema, there are two types of tables: fact tables and dimension tables. In general, a relational data warehouse is a historical repository of a business's...
    on1 May 2013

  • Wiki Page: Fact (OLAP)

    Overview In SQL Server Analysis Services (SSAS) data warehousing and OLAP/UDM solutions, a fact is a single record, usually representing a business transaction, at the lowest level of granularity recorded in the database. Facts are composed of dimension keys and measures ; the dimension keys reference...
    on1 May 2013

  • Wiki Page: How to Convert a SQL Server Text Column data to VarBinary/Image Column data and back.

    This article is just to show some code to help convert data between SQL server text column and varbinary/image column. This also can help you using the SQL Server READTEXT, WRITETEXT and UPDATETEXT statements. These kind of statements use pointer that are not trivial to SQL Server programmers. ...
    on19 Feb 2013

  • Wiki Page: Reporting Services Samples on CodePlex (SQL Server Reporting Services SSRS)

    Table of Contents Troubleshooting AdventureWorks sample reports Embedded Reporting The CodePlex home page for all SQL Server Reporting Services (SSRS) samples is SQL Server Reporting Services Product Samples . All of the samples are in one download package. If you are interested only in the standalone...
    on15 Feb 2013

  • Wiki Page: MCITP: Business Intelligence Developer 2008

    The Business Intelligence Developer 2008 certification is for IT professionals who design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2008 BI tools. The qualified candidate for this exam typically has two to three years of experience in the following: Working with...
    on12 Feb 2013

  • Wiki Page: KPI

    Overview In SQL Server Analysis Services (SSAS) , a key performance indicator (KPI) is a metric that a business uses to measure its success and progress. The metric is compared against a goal to determine its position relative to that goal and its velocity (trend). For example, a business might...
    on7 Feb 2013

  • Wiki Page: SQL Server Database Engine Configuration: Best Practices For Sharepoint 2010/2013 On SQL Server

    Overview The following is a collection of checks that can be run against an instance of SQL Server 2005/2008/2008R2/2012 that is currently or will be used as a dedicated instance for sharepoint databases. The checks come from standard best practices and also from the Sharepoint best practices...
    on1 Feb 2013

  • Wiki Page: Exam 70-452 - PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 (en-US)

    Table of Contents Overview Skills Measured Preparation Materials Community Related Forum Posts Overview Language(s): English, French, German, Japanese, Spanish, Chinese (Simplified) Audience(s): IT Professionals Technology: Microsoft SQL Server 2008 ...
    on23 Dec 2012

  • Wiki Page: SQL Server Books

    Introduction This article is designed to keep a track of all SQL Server related books on the marked. Feel free to update the list with the desired books and links to get them. SQL Server 2012 Introducing Microsoft SQL Server 2012 Microsoft SQL Server 2012 High-Performance T-SQL Using...
    on10 Dec 2012

  • Wiki Page: How to Encrypt Database Backup (id-ID)

    Hasil Backup suatu database dapat dengan mudah untuk bisa di restore di engine SQL Server lain manapun. Tentunya hal ini sangat berbahaya jika hasil backup yang kita hasilkan tercuri atau di copy oleh lawan bisnis kita. Namun sejak versi SQL Server 2008 telah tersedia sebuah fitur “Transparent...
    on6 Dec 2012

  • Wiki Page: SQL Server Database Engine Permission Posters

    Posters are available that list all the granular permissions of the SQL Server Database Engine and Windows Azure SQL Database. Select the pdf images below. You can display these on your computer, expanding or shrinking them to focus on specific areas. Use Control+F to search for a specific permission...
    on29 Nov 2012

  • Wiki Page: Sql server Installation and database Creation with visual studio setup

    Step 1: Create a Setup project right click and select Sql server 2008 as prerequisite. In VS2008 Sql Server 2005 available as prerequisite. Here are the steps to install sql server database with setup using custom action. Step 2: create a text file that contains a...
    on19 Oct 2012

  • Wiki Page: Database Engine Permission Basics

    In SQL Server 2008 R2, Database Engine permissions are managed at the server level through logins and fixed server roles, and at the database level through database users, fixed database roles, and user-defined database roles. Download the Permissions Poster PDF file . Table of Contents Logins...
    on25 Sep 2012

  • Wiki Page: How to Troubleshoot Connecting to the SQL Server Database Engine

    This is an exhaustive list of troubleshooting techniques to use when you cannot connect to the SQL Server Database Engine. These steps are not in the order of the most likely problems which you probably already tried. These steps are in order of the most basic problems to more complex problems. These...
    on13 Sep 2012

  • Wiki Page: SQL Server 2008 Security Permissions – Windows / Active Directory Authentication Issues

    By: Brenton Blawat Table of Contents User Security Identifiers Now in the Sys.SysLogins Correcting SID Issues NetBIOS Based Windows Authentication Only Workarounds for Domain Authentication Systems Administrators around the world have been baffled by security changes with SQL Server 2005/2008...
    on30 Aug 2012

  • Wiki Page: Uninstalling a Service Pack or Cumulative Update Causes Requests to a Report Server and Report Manager to Fail (SSRS)

    Table of Contents Background Workaround if you have a backup of the report server symmetric key Workaround if you do not have a backup of the report server symmetric key Applies to More Information Background Uninstalling a Service Pack or Cumulative Update causes requests to Report Server...
    on26 Aug 2012

  • Wiki Page: Get Job Status of SQL Jobs of Multiple Instances into a Single Excel File

    This is a standard proceedure to Monitor the SQL Jobs of Multiple Instnaces into a Single Excel File. Event though we have SCOM Setup to monitor the SQL Jobs, we didnt want to rely on it, so went for this Monitoring of the SQL jobs through an excel file. So how we performed is 1. We created...
    on19 Aug 2012
Page 1 of 4 (88 items) 1234
Can't find it? Write it!

Post an Article