Resources For IT Professionals
Get this Tag RSS feed
Tag Cloud
Wiki  > All Tags > SQL Server
Tagged Content List

  • Wiki Page: SQL Server 2012 Developer Training Kit BOM

    Table of Contents Overview Day 1: Introduction and Database Engine Topics Module 1: Introduction to SQL Server 2012 Module 2: Introduction to SQL Server AlwaysOn Module 3: Exploring and Managing SQL Server 2012 Database Engine Improvements Module 4: SQL Server 2012 Database Server Programmability Day...
    on20 Sep 2013

  • Wiki Page: SQL Server Samples Readme

    The SQL Server 2012 samples provide a variety of databases and files that you can use to learn about new and existing features. This article is the consolidated Readme for each sample in the SQL Server 2012 release. It provides prerequisite information, installation instructions, and links...
    on20 Sep 2013

  • Wiki Page: Dropping a Clustered Index Will Not Reorganize the Heap

    If a clustered index will be turned into a HEAP, no reorganization of the data will occur. This "myth" is sometimes popping up in forums or blogs. A view "behind the scenes" will describe how Microsoft SQL Server is handling this operation. Before the deep dive into the internals...
    on19 Sep 2013

  • Wiki Page: SQL Server AlwaysOn

    Table of Contents Introdução HA e DR AlwaysOn Availability Groups Conceitos e Terminologia Availability Replica Roles Modos de Sincronização de Dados • Utilizando a forma síncrona = Synchronous-Commit Mode • Utilizando a forma assíncrona = Assynchronous-Commit Mode Modos de Failover nos Availability...
    on19 Sep 2013

  • Wiki Page: SQL Server Security

    This is first post about SQL Server Security, in this post we will speak about Sever Configuration: First you need clear plan about your installation; what services you want, and what you aren’t, if you need SSAS, SSRS, Filestream and so on. In SQL server you need service account to install services...
    on19 Sep 2013

  • Wiki Page: SSIS Control Flow

    The Control Flow is the component in SSIS which ensure task workflow is executed in orderly manner. Control Flow tasks are individual, isolated units of work. For example we can consider for loop container which perform looping, also can execute standalone SQL Scripts/Stored procedures, call into...
    on19 Sep 2013

  • Wiki Page: Understanding the Error 1105 in MS SQL Server Database

    You were taking a backup and suddenly the MS SQL Database application showed you error message which looks something like this “Error 1105” “Severity Level 17” and message which looks like this “Could not allocate space for objects ‘%.*ls’ in database ‘%.*ls’ because the ‘%.*ls’ filegroup is full”...
    on19 Sep 2013

  • Wiki Page: SharePoint 2010: Ten Points to Pay Attention to for a Good Infrastructure

    SharePoint 2010: Ten points to have a great infrastructure #1 Limit your SQL When you install SharePoint 2010 on a complete mode with a SQL SERVER 2008R2, there is an option on the properties of the server, that you can limit the RAM usage. If you don’t limit the usage, it will use 2.1 petabytes...
    on18 Sep 2013

  • Wiki Page: SharePoint 2010: Importing Data from a SQL Database into a SharePoint list

    When developing solutions for the SharePoint platform, there's often a requirement to import data from a SQL database into one or more SharePoint lists. This can easily be accomplished using PowerShell. By using PowerShell you have a lot of control over what data gets imported, and how it is formatted...
    on18 Sep 2013

  • Wiki Page: T-SQL: Display Horizontal Rows Vertically

    This article is an outcome of my answer to this question on MSDN forum. Consider this scenario : Table 1: DEPARTMENT EMPID ENAME SALARY A/C 1 TEST1 2000 SALES 2 TEST2 3000 Table...
    on17 Sep 2013

  • Wiki Page: SQL Server Query Language - Transact-SQL

    This article lists known TechNet articles that are devoted to various aspects of the Transact-SQL language. Table of Contents SQL Server in General PIVOT CLR Dates Related APPLY operator String Functions Meta-Data XML Miscellaneous Bulk Data (bulk insert / bcp / openrowset) See Also SQL Server...
    on17 Sep 2013

  • Wiki Page: SQL Server Analysis Services - List of TechNet Wiki Articles

    This article lists known TechNet Wiki articles about SQL Server Analysis Services . Table of Contents See Also Please add content See Also SQL Server Query Language - Transact SQL SQL Server Developer Resources SQL Server 2012
    on17 Sep 2013

  • Wiki Page: Troubleshoot Installation and Configuration Issues (Master Data Services in SQL Server 2012)

    When you install and configure Master Data Services (MDS) in SQL Server 2012, you might encounter any of the following issues. Fixing an MDS installation in a cluster Error when connecting to a remote database server Database creation fails when user account cannot be resolved Database...
    on17 Sep 2013
Page 2 of 62 (1,550 items) 12345»