Browse by Tags

Tagged Content List

Wiki Page: T-SQL: Group by Time Interval

Naomi N

Table of Contents Simple Problem Definition Solution Complex Problem Definition and Solution See Also Simple Problem Definition A question was posted today in Transact-SQL forum " Counts by Time Interval " The thread originator wanted to know how to find how many jobs were completed...

on3 Sep 2013
Wiki Page: How to find the SQL Server Running Jobs Time Elapsed status

Maheshkumar S Tiwari

There are many situations wherein we want to know the time for which a particular or all the jobs are executing. We can find the execution status from the Job Activity Monitor but we don't get the duration of execution in it. we can use the below query to find out the same. The Query fetches the...

on3 Sep 2013
Wiki Page: Recycle SQL Server ERROR log depend on log file size

Maheshkumar S Tiwari

Recently I have seen a question on MSDN forum site, where the asker want to know how can he recycle SQL Server ERROR log depend on its size. As we all there is no way we can do this using any SQL command. So I decided to write PowerShell Script to do the job [System.Reflection.Assembly]::LoadWithPartialName...

on3 Sep 2013
Wiki Page: Delete duplicate record from Microsoft Sql Server

Maheshkumar S Tiwari

Most important things is you have one identity column . Use this query for delete all duplicate record. you can use group by on multiple column . Query : delete from (TableName) where ID NOT IN(Select MAX(ID) from (TableName) group by ColumnName,ColumnName,ColumnName,....more columnname)...

on31 Aug 2013
Wiki Page: SQL Server 2008+: Merge (Unity is Strength - Strengthen your Performance by Merge)

Balaji M Kundalam

Table of Contents Problem Definition Solution MERGE Points to note Conclusion Problem Definition In SQL Server for each DML transaction (Insert, Update, Delete) we need to write separate statements which will be executed one by one in SQL Server execution engine. Let's give a basic...

on31 Aug 2013
Wiki Page: Руководство по доставке SQL Azure (ru-RU)

Richard Mueller

Это руководство содержит пример для разработчиков, начинающих проект, который, возможно, будет использовать SQL Azure. Руководство предназначено для опытных архитекторов и разработчиков, имеющих опыт работы с SQL Server и, возможно, с .NET Framework. Подразумевается хорошее...

on30 Aug 2013
Wiki Page: SSIS: List of Transformations

prasadnimmani

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

on29 Aug 2013
Wiki Page: PowerPivot Overview

Ed Price - MSFT

Microsoft’s Analysis Services product team (in the SQL Server division) has developed a new product that provides self-service BI (Business Intelligence) functionality for users of Microsoft Office. This product is generally referred to as PowerPivot , and it consists of both a client-side component...

on29 Aug 2013
Wiki Page: Instalar Manualmente SQL Server para uso com MAP Toolkit (pt-BR)

Michael Board [MSFT CSG]

This article is outdated. For more recent content please see the MAP Toolkit Survival Guide at http://social.technet.microsoft.com/wiki/contents/articles/1640.microsoft-assessment-and-planning-toolkit.aspx Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents...

on27 Aug 2013
Wiki Page: Care and Feeding of Your Tabular Workspace Database

Paul Turley

by Paul Turley , Mentor, SolidQ << This is a stub article – please edit and add content to the outlined topics >> How a Tabular Model Project is Structured System Requirements* (revisited later, after discussion about negotiating desktop restrictions with sys admin...

on23 Aug 2013
Wiki Page: Subir una base de datos de SQL Server 2012 a SQL Azure (Parte 1) (es-ES)

Victor Altamirano

En SQL Server 2012 existe un asistente, que ayuda a Subir una base de datos de SQL Server 2012 a SQL Azure en Windows Azure. Es una de las formas que se puede hacer Gracias :D

on23 Aug 2013
Wiki Page: Encriptar procedimientos almacenados SQL Server (es-ES)

Victor Altamirano

En este Screencast, aprenderemos a encriptar los procedimientos almacenado de SQL Server. La finalidad es que los usuarios finales no puedan modificarlos y así los sistemas no tengan problemas al momento de utilizarlos, La versión del SQL Server es 2012 Gracias :D

on23 Aug 2013
Wiki Page: Generar un Script de la base de datos en SQL Server con las tablas y la data (es-ES)

Victor Altamirano

En este screencast, aprenderemos a generar el script de una base de datos en SQL Server generando las tablas, procedimientos almacenados y los registros o información que tenga la base de datos Gracias :D

on23 Aug 2013
Wiki Page: Recommendations for Installing, Sizing, Deploying, and Maintaining a BizTalk Server Solution

Maheshkumar S Tiwari

Table of Contents Introduction Who Should Read This Guide Document Structure Initial Planning / determining which edition of BizTalk Server is appropriate for meeting your goals Determine the business goals of the BizTalk Server solution Create an architecture diagram Create a summary hardware diagram...

on23 Aug 2013
Wiki Page: BizTalk Server 2010: SQL Agent Jobs

Maheshkumar S Tiwari

Table of Contents BizTalk Server SQL Agent Jobs Backup BizTalk Server References CleanupBTFExpiredEntriesJob_BizTalkMgmtDb MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb MessageBox_Message_Cleanup_BizTalkMsgBoxDb MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb MessageBox_Parts_Cleanup_BizTalkMsgBoxDb...

on23 Aug 2013
Wiki Page: Buenas practicas de Usuario Sa de SQL Server (es-ES)

Ademir Soleto

Las buenas practicas de SQL SERVER al momento de habilitar el modo mixto de autenticación, aconseja no dejar por defecto el nombre del usuario “sa”, como buena practica es mejor deshabilitarlo y cambiar el nombre, el script para realizar esta operación es : use [master] GO ALTER LOGIN sa DISABLE;...

on22 Aug 2013
Wiki Page: Instaladores de SQL Server Express (es-ES)

LeoPonti

Al momento de descargar SQL Express contamos con diferentes instaladores cada uno con una función especial, para elegir correctamente cual es el mas optimo de acuerdo a nuestra necesidad aquí explicamos cada uno de ellos. Microsoft SQL Server Management Studio Express (SQLEXPR_x64_ESN.exe...

on22 Aug 2013
Wiki Page: Manejo de Cursores en SQL Server (es-ES)

LeoPonti

CURSORES Un cursor es una estructura de datos creada en memoria RAM producto de una sentencia SELECT y que nos permite navegar dentro de las filas para obtener la información. Cuando trabajemos con cursores debemos seguir los siguientes pasos. -Declarar el cursor, utilizando DECLARE...

on22 Aug 2013
Wiki Page: INSTRUCCION RANK y DENSE_RANK (es-ES)

LeoPonti

Imagina que contamos con un grupo de alumnos de los cuales tenemos las notas obtenidas en las materias de Matemática, Humanidades, Derecho y queremos saber en base a su nota la posición obtenida del alumno en cada materia, para esto necesitaríamos clasificar las notas de mayor a menor. Otro ejemplo...

on22 Aug 2013
Wiki Page: PowerPivot Measures

Ed Price - MSFT

This article shows you how to create a measure based on data in the Data Analysis Expressions (DAX) sample workbook. The workbook includes bike-related data from the AdventureWorks database. For information about where to get the sample workbook, see Get Sample Data for PowerPivot in the TechNet Library...

on21 Aug 2013
Wiki Page: Change Data Capture Known has CDC

Manjunath C Bhat

Change Data Capture popularly known as CDC is a new feature in SQL Server 2008 that records insert, update and delete activity in SQL Server tables. A good example of how this feature can be used is in performing periodic updates to a data warehouse. CDC records (or captures) DML activity on designated...

on21 Aug 2013
Wiki Page: Master Data Services (MDS)

Kumar Vivek

This is a list of TechNet Wiki articles about Master Data Services (MDS). Table of Contents SQL Server MDS Topics Troubleshooting Topics More Articles about MDS - Search by Tags See Also Credits SQL Server MDS Topics Display the Master Data Services Web Application in SharePoint http...

on20 Aug 2013
Wiki Page: How to Install SharePoint 2010 with SQL Server 2012 on Windows Server 8

Gokan Ozcifci

Table of Contents Downloads Windows Server 8 Microsoft SQL Server 2012 Denali Install Process: Server Install Process: SQL Install Process: SharePoint Downloads Windows Server 8 ISO Windows Developer Preview with developper tools (64 bits) ISO Windows Developer Preview 64 bits Microsoft...

on16 Aug 2013
Wiki Page: Kerberos for Microsoft BI - With Delegation and SPN references for SQL, SSRS, SSAS, and SharePoint

Gokan Ozcifci

Here are the articles that can help with Kerberos, delegation, and getting Integrated Windows Authentication working with the Microsoft BI stack. What is the Microsoft BI stack? http://www.microsoft.com/bi lists SQL Server, SharePoint and Office as part of the Microsoft BI stack. Historically...

on16 Aug 2013
Wiki Page: SharePoint 2013: Change the Default SQL Server Port Assignments

Gokan Ozcifci

Locking Down SharePoint's SQL Server Best practice guidance for SharePoint 2013 farms is that SQL Server's old familiar default port 1433 is now persona non grata for secure farm communication with the database. That port, and its near relative UDP 1434, should be specifically blocked...

on16 Aug 2013