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 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

  • Wiki Page: Аудит SQL Server 2008 (ru-RU)

    Техническая статья по SQL Server Автор: Il-Sung Lee, Art Rask Технические рецензенты: Jack Richins, Rick Byham, Sameer Tejani, Al Comeau, JC Cannon Опубликовано: февраль 2009 Применимо к: SQL Server 2008 Предложенная статья является машинным переводом оригинала ( http://msdn.microsoft...
    on11 Aug 2012

  • Wiki Page: SQL Server Analysis Services (SSAS)

    Table of Contents Overview Analysis Services Wiki Articles Dimensional Modeling 101 Security Performance Administration and Monitoring Tools Query and DDL Languages Data Mining See Also Other Languages Brazilian Portuguese (pt-BR) German (de-DE) Overview SQL Server Analysis Services (SSAS) is...
    on3 Aug 2012

  • Wiki Page: Eliminate holidays (weekends, specific day) using T-SQL

    Eliminate holidays (weekends, specific day) using T-SQL One of the tasks that may we have to deal with is how to eliminate weekends and holidays from a period using SQL server, e.g. if you want to calculate number of business days for specific company you may need to eliminate Saturday and Sunday...
    on18 Jul 2012

  • Wiki Page: Database Mail Configuration in SQL Server 2008

    Remember SQL Mail? SQL Mail was introduced in SQL Server 2000. Those who worked on SQL Mail know how much they hate it. They have to do Outlook configurations, third party Simple Mail Transfer Protocol mapping, Messaging Application Programming Interface profiles (this mapping must also be installed...
    on14 Jul 2012

  • Wiki Page: Database Engine Security Checklist: Database Engine Security Configuration

    This checklist reviews key security configuration options for the SQL Server Database Engine. Use this checklist to periodically audit your Database Engine environment. These recommended settings should be adjusted based on your security and business needs. Table of Contents Physical Security Operating...
    on5 Jun 2012

  • Wiki Page: Service Manager (SCSM) 2012 : "The SQL Server is not running version SQL 2008 or SQL 2008 R2"

    Today when I started to install the SCSM Web portal I’ve got the following error: After some search on internet I found this good article which solved my issue. After running the command line on the Management Server… The problem has gone away.
    on5 Jun 2012

  • Wiki Page: Entity Framework FAQ: Error Messages (ru-RU)

    Содержание EF FAQ Table of Contents MetadataException: Unable to load the specified metadata resource Unable to create a constant value of type 'SomeType'. Only primitive types ('such as Int32, String, and Guid') are supported in this context. Cannot compare elements of type 'MyNamespace...
    on13 May 2012

  • Wiki Page: SQL server deployment - Useful links for trouble shooting deployment & upgrade issues

    Link Title URL Description SQL Server 2008 Failover Clustering http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx Multiple SQL Server Versions Within the Same Windows Server Cluster (SQL Server 2000 and...
    on1 May 2012

  • Wiki Page: How to Set Which Instance of SQL Server ( 2008 R2 or 2005) is Used in a Program

    You might be participating in a project that uses MS SQL Server 2008 R2 to connect to a database. It uses ADO.NET Entity Framework. I use Visual studio 2010 and WPF. I have instaled SQL SERVER 2005 Express. I got the project and i noticed that when i compile and run then: compilation is ok, but...
    on28 Apr 2012

  • Wiki Page: Data Mining with SQL Server Analysis Services 2008

    Introduction Data mining is a process of discovering pattern from a very large chunk of data. Pattern can be used for decision making by higher authorities, like Prediction of Sales, Probability of number of site visit in next month etc. Or in another word it is predictive analysis tool. Data mining...
    on18 Apr 2012

  • Wiki Page: Del Cursor y otros demonios (es-ES)

    A Lauren El titulo de este post es un pequeño homenaje a una novela del Nobel Gabriel García Márquez, su nombre me vino a la mente después de asociarlo a una serie de usos y malas prácticas que por lo general los desarrolladores cometemos al iniciar con la programación...
    on10 Apr 2012

  • Wiki Page: SQL Server Analysis Services (SSAS) (de-DE)

    Table of Contents Überblick Analysis Services Wiki Artikel Multidimensionale Modellierung Performance Administration und Monitoring Tools Abfrage und DDL Sprachen Data Mining Siehe auch Andere Sprachen English Português Überblick SQL Server Analysis Services (SSAS) ist Microsoft's...
    on30 Mar 2012

  • Wiki Page: Unified Dimensional Model (de-DE)

    Table of Contents Definition Komponenten Quellen Siehe auch Andere Sprachen English Português Definition Das Unified Dimensional Model (UDM) ist ein Datenmodell in SQL Server Analysis Services (SSAS) Datenbanken. UDM vereint dabei Daten von verschiedenen relationalen Datenbanken in einen...
    on30 Mar 2012

  • Wiki Page: Grupo de Medidas (pt-BR)

    Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/measure-group.aspx Visão Geral As medidas são valores numéricos dos fatos (operações) que analisam os usuários em um banco de dados OLAP. No SQL Server...
    on30 Mar 2012

  • Wiki Page: Measure Group (de-DE)

    Überblick Measures sind numerische Werte aus Fakten (Transaktionen), die ein Nutzer in einer OLAP Datenbank analysieren kann. Im SQL Server Analysis Services (SSAS) werden Measures, die aus der selben Quelltabelle der OLAP Datenbank kommen, in sogenannten Measue Groups zusammengefasst. ...
    on30 Mar 2012

  • Wiki Page: Snowflake Schema (pt-BR)

    Esse artigo foi originalmente escrito em : http://social.technet.microsoft.com/wiki/contents/articles/snowflake-schema.aspx Visão Geral No SQL Server Analysis Services (SSAS) , snowflake schema descreve um modelo de dados populares para data warehouses relacionais. Semelhante ao star...
    on30 Mar 2012

  • Wiki Page: Modelo Dimensional Unificado (pt-BR)

    Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/unified-dimensional-model.aspx Definição O Modelo Dimensional Unificado é o modelo de dados em um banco de dados do SQL Server Analysis Services (SSAS). O Modelo Dimensional...
    on30 Mar 2012

  • Wiki Page: Perspectiva (pt-BR)

    Esse artigo foi originalmente escrito em : http://social.technet.microsoft.com/wiki/contents/articles/perspective.aspx Visão Geral Em um banco de dados do SQL Server Analysis Services (SSAS) , uma perspectiva é uma visão limitada de um cubo . Perspectivas aprimoram a experiência...
    on29 Mar 2012

  • Wiki Page: MCITP: Business Intelligence Developer 2008 (de-DE)

    Die Business Intelligence Developer 2008 Zertifizierung ist für IT-Pros, die Business Intelligence (BI)-Lösungen mit den Microsoft SQL Server 2008 BI-Tools entwerfen und planen. Kandidaten für diese Prüfung hat in der Regel zwei bis drei Jahre Erfahrung in den folgenden Punkten: ...
    on29 Mar 2012

  • Wiki Page: MCITP: Database Developer 2008 (de-DE)

    Die Database Developer 2008 Zertifizierung ist für IT-Pros, die in einem Enterprise-Umfeld mit mehr als 500 PCs und mehr als 100 Server arbeiten und vor allem Lösungen für alle Arten von unternehmensspezifischen Probleme entwickeln. Sie haben Erfahrung in den folgenden Punkten: Schreiben...
    on29 Mar 2012

  • Wiki Page: MCITP: Database Administrator 2008 (de-DE)

    Die Database Administrator 2008 Zertifizierung ist für IT-Pros, die in einer Umgebung arbeiten, in der Microsoft SQL Server 2008 Datenbank-Lösungen verwendet werden. Sie haben Erfahrung in den folgenden Punkten: Definition von Lösungen mit hoher Verfügbarkeit Datenverteilung...
    on29 Mar 2012

  • Wiki Page: Star Schema (pt-BR)

    Esse artigo foi originalmente escrito em : No SQL Server Analysis Services (SSAS) , um star schema descreve um modelo de dados comum para data warehouses relacionais. Em uma star schema, existem dois tipos de tabelas: tabelas de fatos e tabelas de dimensão . Em geral, um data warehouse...
    on29 Mar 2012
Page 3 of 5 (104 items) 12345
Can't find it? Write it!

Post an Article