Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  SQL Server
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...
    on17 Sep 2013

  • 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...
    on17 Sep 2013

  • 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...
    on17 Sep 2013

  • 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...
    on17 Sep 2013

  • 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...
    on17 Sep 2013

  • 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...
    on17 Sep 2013

  • 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...
    on17 Sep 2013

  • 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...
    on17 Sep 2013

  • 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...
    on17 Sep 2013

  • 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...
    on16 Sep 2013

  • 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...
    on16 Sep 2013

  • 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...
    on16 Sep 2013

  • Wiki Page: Sort Letters in a Phrase using T-SQL

    Table of Contents Problem definition Introduction Solution Limitations 1. Data Type 2. Data Length See Also Problem definition This article comes up from this MSDN forum post. The problem is how can we sort the letters in a phrase just using T-SQL? To clarify the question, for instance...
    on15 Sep 2013

  • Wiki Page: SQL Server Glossary

    Term Definition .NET Framework An integral Windows component that supports building, deploying, and running the next generation of applications and Web services. It provides a highly productive, standards-based, multilanguage environment for integrating existing investments with...
    on15 Sep 2013

  • Wiki Page: Create a User for SQL Server 2008 Express Edition

    How to set a user to access on a db: Open Management Studio Go on properties of the server ex: SRV-2008\SQLEXPRESS Select mixed mode (SQL Server and Windows Authentication). Click OK. Always in Studio Management, add a new connexion ( unroll security) In general, enter a name for the account and...
    on15 Sep 2013

  • Wiki Page: Using Bulk Insert to import inconsistent data format (using pure T-SQL)

    Table of Contents Introduction The problem Our Case Study The solution: STEP 1: Identify the import's file format Finding the problematic columns and the consistent columns format STEP 2: insert the data into temporary table Step 3: parsing the data into the final table Summary Comments Resources...
    on15 Sep 2013

  • Wiki Page: Shrink SQL Database During Restore

    Table of Contents Case Study: First option: using compressed folder & symbolic link Step 1: Create a compressed folder Step 2: Backup your database Step 3: Create symbolic link to the compressed folder Step 4: Restore your database using the symbolic link. Step 5: Shrink the Database Step 6: Detach...
    on15 Sep 2013

  • Wiki Page: T-SQL Useful Links

    This article will share collection of links in regards to various aspects in Transact-SQL language I acquired over the years and saved in links.txt file. Many of these links come very handy answering various questions in SQL Server related forums. Table of Contents Select Top N Rows per Group Performance...
    on15 Sep 2013

  • Wiki Page: SSRS: Troubleshoot Issues and Errors with Reporting Services

    Table of Contents Troubleshooting General Installation and Upgrade Configuration and Operations Samples Report Builder 3.0 SharePoint Integration and the SSRS SharePoint Add-In Report Server Report Manager See Also External Links Troubleshooting SQL Server 'Denali' Reporting Services...
    on13 Sep 2013

  • Wiki Page: Connectors for SSIS: Persistent Systems

    If you are looking at various Data source and Target connection options to SSIS, visit the following Web site: http://www.persistentsys.com/products/ssisoracleconn/ssisoracleconn.htm Our Oracle bulk load is over 100 times faster than the OLEDB provider. It currently has high speed connectivity...
    on13 Sep 2013

  • Wiki Page: SSRS Troubleshooting: Report Builder does not work after you upgrade from SQL Server 2008 SP1 to SQL Server 2008 R2

    Background: The default click-once version of Report Builder that will be used with SQL Server 2008 Reporting Services is Report Builder 1.0. If the Custom Report Builder Launch URL was modified to use Report Builder 2.0, then Report Builder may no longer work following an upgrade to SQL Server...
    on13 Sep 2013

  • Wiki Page: SQL Server PIVOT

    Table of Contents Problem Definition Common Problem Other Blogs See also Problem Definition Recently in this thread I helped to solve a relatively simple problem. I will quote my solution and then I will explain the main problem people often encounter with PIVOT solutions ; WITH...
    on12 Sep 2013

  • Wiki Page: SSIS: Flat File Source - Datetime Column Format Issue & Solution

    Table of Contents 1.0 Introduction 2.0 Problem Definition 3.0 How does it work 4.0 Solution 1.0 Introduction Flat files as Source are widely used in SQL Server Integration Services Tool. This article will discuss about one common issue with Flat File Date time Columns. (Details can be found...
    on12 Sep 2013

  • Wiki Page: Wiki: Troubleshooting Portal

    This page is a community-driven list of troubleshooting portals and articles covered on the TechNet Wiki and the top associated articles for each technology. This list is not intended to include all the articles about each product, and this list only includes TechNet Wiki articles . The links are organized...
    on12 Sep 2013

  • Wiki Page: BizTalk Server Installation and Configuration Checklist

    Table of Contents Introduction General information regarding updating this article General advices before Installation of BizTalk and SQL machine SQL Server Installation Install BizTalk After installation SQL BizTalk See Also Introduction This list is intended as a simple checklist to verify the...
    on11 Sep 2013
Page 2 of 31 (766 items) 12345»
Can't find it? Write it!

Post an Article