Browse by Tags

Basado en este articulo En LINQ to SQL, las operaciones Insert, Update y Delete se realizan agregando, cambiando y quitando objetos en el modelo de objetos. De forma predeterminada, LINQ to SQL convierte estas acciones a SQL y envía los cambios a la base de datos. LINQ to SQL proporciona...

Table of Contents Symptoms Causes Troubleshooting steps Symptoms Causes Troubleshooting steps 1. Check logs: 2. Verify that the SQL database is running and services. 3. Firewall 4. Is your SQL configured correctly? 5. User Permissions 6. Can they talk to each other? 7. SID 8. ...

Script to check the SQL Server Instance Path Problem: For database creation we specify the default path including the drive name e.g. (C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA). If SQL Server Instance is installed on the different drive or path e.g. (d:,e:)...

This is a partial list of keyboard shortcuts for SQL Server Management Studio (SSMS) . Hot Key Effect ALT + N New query window CTRL + F4 Close current query window CTRL + W Highlight the word where the cursor is currently located ...

Introduction This article demonstrates how to create an encrypted stored procedure in SQL Server. This article starts with introduction of how to create a stored procedure in SQL server. After that, it demonstrates how to encrypt stored procedure. Every developer wants to secure her/his SQL code...

Introduction "SQL Server Service Broker provides the SQL Server Database Engine native support for messaging and queuing applications. This makes it easier for developers to create sophisticated applications that use the Database Engine components to communicate between disparate databases...

Microsoft SQL Server 2012 ile beraber raporlama platformunu bir adim daha ileri götürerek kullanicilara kendi raporlarini hazirlama imkani PowerView eklentisi artik gelistiricilerin ve son kullanicilarin hizmetinde. PowerView su hali ile degerlendirilir ise SSRS in yerine geçmek için degil ancak...

Esta pergunta é frequente, principalmente porque como consultor de soluções de um fabricante de servidores temos que saber. O que são IOPS? É o número de operações por segundo que um disco individual consegue chegar. Por exemplo, um disco SAS de 10K consegue em média 140 IOPS. Esta velocidade...

Table of Contents Background Workaround Applies to See Also Background URLs that use the SharePoint server's IP address instead of the server's computer name may result in a "404 Not Found" error. Workaround Add the IP address of the computer as a new internal...

Table of Contents Background Workaround Applies to See Also Background When you are viewing reports from a SharePoint document library, if you click Cancel while a report is loading, the Apply button in the parameters pane will no longer work. The Apply button is enabled but clicking it...

Business continuity is the activity performed by an organization to ensure that critical business functions will be available to customers, suppliers, regulators, and other entities that must have access to those functions. These activities include many daily chores such as project management, system...

Este es un curso desarrollado para poder proveer los fundamentos necesarios para poder desarrollar e implementar soluciones de inteligencia de negocios utilizando tecnologías Microsoft. Nota: El continendo del curso puede ser modificado dependiendo del desarolle de los recursos. Contenido. ...

Below are some restatement about some facts in the SSAS/MDX world: 1. SSAS cannot handle two time dimensions (dimension type = time) which has semi-additive measures (such as Average of children) a. Work around: Instead we have to use either calculated measure to construct the AVG...

This article lists known TechNet Wiki articles about SQL Server Analysis Services (SSAS) . Table of Contents Unified Dimensional Model Security Performance Administration and Monitoring Tools Query and DDL Languages Data Mining Aggregations Troubleshooting Power Pivot See Also Additional...

Overview Microsoft SQL Server Reporting Services (SSRS) provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise. Reporting Services provides a...

This article is a guide of SSIS community resources. Find community contributed tasks in this other Community Contributed SSIS Tasks article. http://www.sqlis.com/ A dedicated SSIS community site maintained by SQL Server MVPs Darren Green and Allan Mitchell. http://msdn...

Overview The Dataflow engine is the software component in SSIS that powers the Dataflow Task . It moves data from one place to another in memory-resident data structures called buffers (sometimes called pipeline buffers). A buffer is effectively a subset of all the data that is being processed by...

Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Dataflow Task , between data source and destination components, or other transformations . In a BI environment, data consumers might not be interested of details which are irrelevant...

When it comes to data processing, Integration Services reads data from various sources, and writes them to their destinations, but usually some transformation of the data is needed in the meantime (according to the requirements, of course). SSIS can transform the data using its own transformation components...

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 relacional é um repositório histórico de transações...

The SQL Server 2012 Developer Training Kit is a collection of content that can be used to familiarize a developer or IT professional with key improvements in SQL Server 2012. Download and install the SQL Server 2012 Developer Training Kit to get your own copy of the training kit content. See the SQL...

Público alvo : Os desenvolvedores de aplicativos que não estão familiarizados com a concepção, implementação ou manutenção de bancos de dados, que ainda precisará criar um banco de dados para uso com seus aplicativos . Os links abaixo são links externos e fornecer informações e orientação sobre...

Important: Submit your ideas and feedback at http://bit.ly/sql2012kitfeedback ! We develop and test all of the demos and hands-on labs included in the SQL Server 2012 Developer Training Kit Content on a couple of different virtual machine configurations. It's not practical to make these virtual...

Always we should take care of database server performance but sometimes you need to perform a huge update on your table/tables this will affect performance for concurrent users and they will complain about it. For example if you have a table contains more than billion row and you want to update a...

Table of Contents Introduction Overview Two Values Multiple Values Separate Datasets Summary Introduction If you have worked with SQL Server Reporting Services reports, then you should be familiar with parameters. If you have not worked with parameters before, it may help you to understand the...