Tagged Content List
  • Wiki Page: SQL Server Developer Resources

    This page provides a listing of available resources for developers who are working with SQL Server. Table of Contents TechNet Wiki MSDN TechNet Blogs See Also Other Languages Español (es-ES) Deutsch (de-DE) Português (pt-BR) Japanese (ja-JP) TechNet Wiki Introduction to Development with...
  • Wiki Page: SharePoint 2010: Windows Server 8 üzerine SharePoint 2010'u SQL 2012 ile nasil yüklerim

    Table of Contents 1. Downloads Windows Server 8 2. Install Process: Server 8 3. Install Process: SQL 4. Install Process: SharePoint 1. Downloads Windows Server 8 ISO Windows Developer Preview with developper tools (64 bits) ISO Windows Developer Preview 64 bits Microsoft...
  • Wiki Page: Microsoft SQL Server Express 2012

    O Microsoft SQL Server Express é a edição gratuita do SQL Server. Esta edição é ideal para uso de aplicações webs leves e pequenas aplicações. Apesar de proporcionar uma experiência similar aos outros produtos da família SQL Server, o SQL Server Express possui limites quanto a sua utilização. Porém...
  • Wiki Page: Notes de publication de SQL Server 2012 (fr-FR)

    Cliquez ici pour changer de langue. Cette page est minutieusement et étroitement contrôlée. Toutes les modifications que vous apportez feront l'objet d'une évaluation et seront ensuite acceptées, affinées ou rétablies dans les plus brefs délais. Comme il s'agit d'un wiki, des ajouts...
  • Wiki Page: SEQUENCES en SQL SERVER 2012 (es-ES)

    Es frecuente al momento de crear tablas usar una columna con incrementos automáticos, para garantizar que siempre tendrá un valor único, para lo cual se suele recurrir en SQL Server a la función IDENTITY en una columna, esta función tiene sustituto dentro de lo nuevo de SQL Server 2012 con el objeto...
  • Wiki Page: MBAM Hardware and Recovery DB requires TDE on c

    Customers have been experiencing some pain with installing the Hardware and Recovery DB. The Transparent Data Encryption feature of SQL Server 2008 must be enabled for the Hardware and Recovery DB to install successfully. The documentation to date is missing this requirement. While we're fixing...
  • Wiki Page: SQL VDI Backups Fail with Error 9001

    Problem The issue was with SQL backups failing in SQL 2008 server due to the SQL Server VSS writer as posted by the user in the forum . Explanation When backup is occurring through SQL VDI Backups , it requires 3 threads to perform the backups for a single database. The link below...
  • Wiki Page: How to Create Query Shortcuts in SQL Server Management Studio

    You can create shortcuts for frequently used queries in Management Studio, some of the shortcuts are predefined, like pressing "Ctrl + 1" will execute "sp_who". You can create shortcuts for your own queries or change the existing shortcuts. To create a new shortcut, go...
  • Wiki Page: Rebuild and Re-index Database Gradually

    I had a problem in our live environment - the database was fragmented - badly. A solution had to be written to defragment the database, whilst providing the least downtime - and the script below was born. I create a function that will defrag the top X (in this case 20) indexes and created a SQL...
  • Wiki Page: SSRS (Matrix): How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling

    This article is an outcome of my answer to this question on MSDN SSRS forum . Previously I wrote similar article on SSRS: How to Repeat Headers on Each Page and keep headers fixed while scrolling for a table. In this article , let us see an example on how to repeat headers on each page and keep headers...
  • Wiki Page: SSAS Error: Error loading Metadata: No cubes were found

    Applies to: SQL Server Analysis Services (all supported versions) This error can occur if you deliberately or accidentally set a cube's Visible property to False . When developing a cube, you might have occasion to hide a dimension. If the dimension is not selected, you can inadvertently hide...
  • Wiki Page: Fixing Missing Data Based on Prior Row Information

    One of the commonly asked problems in the Transact-SQL forum is how to provide missing information based on the information in the first prior row that has data (or alternatively in the next row (by date)). One of the examples where this problem was discussed is this thread . In this thread...
  • Wiki Page: Extract Transform Load (ETL)

    ETL stands for Extract, Transform and Load, which are phases of data processing in a data warehouse. Extract In this phase, data is read from the source systems, and copied to the staging area of the data warehouse - in a Microsoft environment, it typically means copying data from various sources...
Page 3 of 62 (1,550 items) 12345»