Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  Linked from Portal
Tagged Content List

  • Wiki Page: Demo Transcript: Configuring SQL Server 2012 AlwaysOn Failover Clustering

    SQL11UPD01-TSCRIPT-08 This wiki is a transcript of a previously recorded video. Related content assets: Demo: Configuring SQL Server 2012 AlwaysOn Failover Clustering ( SQL11UPD01-DEMO-04 ) Video: Configuring SQL Server 2012 AlwaysOn Failover Clustering ( SQL11UPD01-REC-08 ) Configuring...
    on22 Sep 2013

  • Wiki Page: How to Compare Two Tables Definition / Metadata in Different Databases

    This article is about the example on T-SQL Script to compare two tables definition / metadata in different databases . The T-SQL Script [used to compare two tables definition / metadata in different databases] in this article can be used from SQL Server 2012 and above version because I have used...
    on22 Sep 2013

  • Wiki Page: How to Check the Syntax of Dynamic SQL Before Execution

    This article is about the system function sys.dm_exec_describe_first_result_set that can be used to check the syntax of dynamic SQL before execution. This system function sys.dm_exec_describe_first_result_set was introduced in SQL Server 2012. Create sample table and insert sample data : ...
    on22 Sep 2013

  • Wiki Page: How to Put a Sequence in a Column Already filled

    Suppose we would like to create a sequence in a table already filled with data. I found out this solution to be pretty easy: CREATE TABLE SEQ (COK NVARCHAR( 10 )) insert into seq values ( 'York' ),( 'Boston' ),( 'Chicago' ) select * from seq --step 1 , I create a table...
    on22 Sep 2013

  • Wiki Page: SQL Server Columnstore Index FAQ

    The SQL Server xVelocity memory-optimized columnstore index stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query processing in SQL Server 2012 through the current version, in many cases by a factor of 10 to 100. We'll...
    on22 Sep 2013

  • Wiki Page: SQL Server Columnstore Performance Tuning

    Table of Contents Introduction Fundamentals of Columnstore Index-Based Performance DOs and DON'Ts for using Columnstores Effectively Maximizing Performance and Working Around Columnstore Limitations Ensuring Use of the Fast Batch Mode of Query Execution Physical Database Design, Loading, and Index...
    on22 Sep 2013

  • Wiki Page: How To Find Various Day, Current Week, Two Week, Month, Quarter, Half Year and Year In SQL Server

    Table of Contents Date Computation Finding Current Date Finding Start Date and End Date of the Week Finding End Date of the Week Finding Start Date and End Date of the Two Weeks See Also Date Computation I was working on one of the financial projects on one of my own custom implementation for SQL...
    on22 Sep 2013

  • Wiki Page: Microsoft SQL Server 2012 New Functions

    EOMONTH We had a problem whenever we wanted to identify the end date of a month. There was no built in function. But now that problem is solved in SQL Server 2012. The function EOMONTH returns the date of the month. SELECT EOMONTH (‘05/02/2012’) ‘EOM Processing Date Output: 2012-02-29...
    on22 Sep 2013

  • Wiki Page: SharePoint 2013: Maximizing SQL Server 2012 Performance ( Free WhitePaper)

    Hello Everyone, For the past few weeks I was writing a Whitepaper about maximizing SQL 2012 Performance for SharePoint 2013. It’s been reviewed by 4 great guys , and after being exclusive to SharePoint-Community.net for one week, I release it to the public! Read the abstract or download the Whitepaper...
    on22 Sep 2013

  • Wiki Page: Microsoft Learning Training and Certification - SQL Server 2012

    MSL Training Portal: http://www.microsoft.com/learning/en/us/training/sql-server.aspx Courses: The SQL Server 2012 courses are designed to enable database professionals to take full advantage of SQL Server 2012 and if they choose to validate their skills with certification...
    on22 Sep 2013

  • Wiki Page: AD RMS (Windows Server 2008 R2) and SQL Server 2012 Install Steps

    Adding AD RMS on Windows Server 2008 R2 with a SQL Server 2012 backend is supported, but a hotfix (KB2619256) must be installed. The problem is that the hotfix will only install after some of the AD RMS components are installed. To get around this "Catch 22" situation, you can install using...
    on22 Sep 2013

  • Wiki Page: How to Disable SSLv2 on a Windows Server 2008 and Windows Server 2008 R2 Domain Controller (dsforum2wiki)

    For security reasons, you may need to disable SSLv2 on a domain controller to force secure LDAP communication using SSLv3 or TLSv1. The following article, What is the Point of Encryption if you Don't Know Who For? offers a description and comparison between SSLv2, SSLv3, and TLSv1 encryption methods...
    on22 Sep 2013

  • Wiki Page: Windows Server 2008 and Windows Server 2008 R2 Support Tools (dsforum2wiki)

    Unlike previous operating systems, in Windows Server 2008 and Windows Server 2008 R2, the resource kit tools are installed as part of the server role installation. In the past, you had to download the resource kit tools separately. For example, if you install the Active Directory Domain Services...
    on22 Sep 2013

  • Wiki Page: SharePoint Performance Best Practices: Limit SQL Server Memory Allocation

    Many times I have seen developers complaining about their SharePoint development environment performance. Since they have SharePoint standalone installation on their development Virtual Machine they always complain their machine is too slow. This is not only the case with development environment...
    on21 Sep 2013

  • 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: RemoteFX vGPU Setup and Configuration Guide for Windows Server 2012

    Windows Server 2012 introduces some significant improvements to RemoteFX™. One feature – RemoteFX vGPU - already present in Windows Server 2008 R2 is the ability to use a physical graphic adapter (GPU) in the Hyper-V host to accelerate the host-side rendering of display content. This guide describes...
    on20 Sep 2013

  • Wiki Page: Windows Server Backup Does not Support Backing Up Shared Folders or Mapped Network Drives

    Backing up of a network location (shared folders) or mapped drives is not supported in Windows Server Backup.
    on20 Sep 2013

  • Wiki Page: How to Open the Certificates Console in Windows 8 and Windows Server 2012

    Applies to: Windows 8, Windows Server 2012 To open the Certificates console for a user, service, or computer: From the Desktop, click the Windows Explorer icon on the Taskbar . In the address bar type mmc and press ENTER. When User Account Control (UAC) appears, confirm that it is performing...
    on19 Sep 2013

  • Wiki Page: Using TRY_CONVERT in SQL Server 2012

    Using TRY_CONVERT in SQL Server 2012 TRY_CONVERT returns the value as the specified data_type; if an error occurs, null is returned. However if you request a conversion that is explicitly not permitted, then TRY_CONVERT fails with an error. TRY_CONVERT conversion function is supported in SQL...
    on17 Sep 2013

  • Wiki Page: How to convert Unicode Data to ASCII and back in SQL server

    Product Targeted MS SQL Server 2012 Summary In SQL server, few specific data handling scenarios require Unicode source data to be moved to non-Unicode destination format like ASCII format. During data conversion, it can be observed that the Unicode characters getting converted to ‘?...
    on17 Sep 2013

  • Wiki Page: Perform Scalar Aggregates and Still get the Benefit of Batch Processing

    Scalar aggregates, (aggregates without a GROUP BY clause, like SELECT COUNT(*) from T ) are simple, but ironically they don't work with the CPU-saving batch mode of query execution with columnstore indexes in SQL Server 2012 RTM. Rest assured we're working already to make them run in batch...
    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

  • Wiki Page: MVC 4.5 Areas and SQL Server 2012 Schemas Dichotomy

    Using Areas in MVC 4.5 can be hazardous to your health if you are starting out. My original Idea for a model in SQL 2012 was to create some schemas. In each schema name I had worked out a way to separate out some important business functionality in discrete business units like so: Finances, Inventory...
    on17 Sep 2013

  • Wiki Page: Generate a Report for installed Hotfix for Bulk Servers using PowerShell

    Function Get -ComInfo { param( ## Computers $computers ) "#" *80 "Server HotFix Report" "Generated $(get-date)" "Generated from $(gc env:computername)" "#" *80 Get -HotFix -ComputerName $computers } ...
    on16 Sep 2013
Page 1 of 3 (61 items) 123
Can't find it? Write it!

Post an Article