If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Review:<br /> Visual Studio LightSwitch p. 35<br /> SQL Server<br /> New Features<br /> p. 12<br /> Running<br /> SQL Server<br /> in a Microsoft<br /> Private Cloud<br /> p. 21<br /> MARCH 2012<br /> Parallelism<br /> in SQL Server<br /> Query Tuning p. 17<br /> >SQL Server 2012<br /> Improve Data<br /> Warehouse Query<br /> Performance with<br /> Columnstore<br /> Indexes p. 25<br /> Setting Up<br /> SQL Server Parallel<br /> Data Warehouse<br /> Clients p. 30Review: Visual Studio LightSwitch p. 35<br /> OTF<br /> Features<br /> Running<br /> SQL Server<br /> in a Microsoft<br /> Private Cloud<br /> Your<br /> Database<br /> Authority<br /> Parallelism<br /> in SQL Serv<br /> uery Tuni<br /> >SQL Se<br /> Improve D<br /> ehouse Query<br /> ormance with<br /> Columnstore<br /> Indexes P. 25<br /> Setting Up<b<a title="March 2012 page 1" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=1"> Review: Visual Studio LightSwitch p. 35 </a> <a title="March 2012 page 2" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=2"> Microsoft BUILT FOR THE FUTURE. READY NOW. Mic</a> <a title="March 2012 page 3" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=3"> WWW.SQLMAG.COM Contents </a> <a title="March 2012 page 4" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=4"> Data Cleansing Tools for SQL Server rrrrr^n J E</a> <a title="March 2012 page 5" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=5"> Contents </a> <a title="March 2012 page 6" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=6"> EDITORIAL Michael Otey (motey@sq</a> <a title="March 2012 page 7" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=7"> Nothing hunts down SQL Server performance issue</a> <a title="March 2012 page 8" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=8"> Join your colleagues from around the world as Mi</a> <a title="March 2012 page 9" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=9"> READER TO READER Incremental Index Maintenance</a> <a title="March 2012 page 10" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=10"> READER TO READER LISTING 2: Sample Call to the u</a> <a title="March 2012 page 11" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=11"> Increase Fan-Out to Reduce Index Depth O </a> <a title="March 2012 page 12" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=12"> SQL SERVER QUESTIONS ANSWERED GO INSERT INTO t</a> <a title="March 2012 page 13" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=13"> TOOL TIME Scripted PowerShell Automated Depl</a> <a title="March 2012 page 14" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=14"> COVER STORY Welcome to SQL Server The ne</a> <a title="March 2012 page 15" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=15"> SQL SERVER 2012 COVER STORY COVER STORY in a S</a> <a title="March 2012 page 16" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=16"> COVER STORY SQL SERVER 2012 The OVER claus</a> <a title="March 2012 page 17" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=17"> SSAS, SSIS, and SSRS projects. If you navigate to</a> <a title="March 2012 page 18" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=18"> COVER STORY SQL SERVER 2012 To make sure yo</a> <a title="March 2012 page 19" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=19"> Parallelism in SQL Server Query Tuning Two tools</a> <a title="March 2012 page 20" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=20"> FEATURE PARALLELISM IN SQL SERVER generated a </a> <a title="March 2012 page 21" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=21"> mimic the target environment as much as possible.</a> <a title="March 2012 page 22" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=22"> FEATURE PARALLELISM IN SQL SERVER You can </a> <a title="March 2012 page 23" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=23"> SQL Server in a Microsoft Private Cloud Answers t</a> <a title="March 2012 page 24" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=24"> FEATURE MICROSOFT PRIVATE CLOUD Live Migra</a> <a title="March 2012 page 25" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=25"> How to Optimize SQL Server for Microsoft Private </a> <a title="March 2012 page 26" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=26"> FEATURE MICROSOFT PRIVATE CLOUD </a> <a title="March 2012 page 27" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=27"> FEATURE Improve the Performance of Data Wareho</a> <a title="March 2012 page 28" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=28"> FEATURE COLUMNSTORE INDEXES into segments. SQL</a> <a title="March 2012 page 29" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=29"> the following data types can't be used in a colum</a> <a title="March 2012 page 30" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=30"> FEATURE COLUMNSTORE INDEXES LISTING 2: Code Tha</a> <a title="March 2012 page 31" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=31"> Thursday, March 22, 2012 Paul Sheriff Usi</a> <a title="March 2012 page 32" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=32"> FEATURE Richard Waym</a> <a title="March 2012 page 33" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=33"> files are NexusSetup32.msi and NexusSetup64.msi f</a> <a title="March 2012 page 34" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=34"> FEATURE SQL SERVER PDW check box because all p</a> <a title="March 2012 page 35" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=35"> If anything is in a trouble or error state, </a> <a title="March 2012 page 36" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=36"> FEATURE SQL SERVER PDW need to enter your user</a> <a title="March 2012 page 37" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=37"> Visual Studio LightSwitch Microsoft Visual Stu</a> <a title="March 2012 page 38" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=38"> PRODUCT REVIEW VISUAL STUDIO LIGHTSWITCH </a> <a title="March 2012 page 39" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=39"> Leverage SANs for Better Manageability D</a> <a title="March 2012 page 40" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=40"> Paul Thurrott... ... he's not in Microsoft's po</a> <a title="March 2012 page 41" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=41"> DATABASE ADMINISTRATION MobiForms Adds iOS Suppor</a> <a title="March 2012 page 42" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=42"> The ACKPage B New Features in SQL Server Data </a> <a title="March 2012 page 43" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=43"> The Complete Performance Solution for Microsoft </a> <a title="March 2012 page 44" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=44"> ??TUE WE DISAGREE ^epreferinstantgratificationl</a> <a title="March 2012 page 45" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=45"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 46" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=46"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 47" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=47"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 48" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=48"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 49" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=49"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 50" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=50"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 51" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=51"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 52" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=52"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 53" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=53"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 54" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=54"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 55" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=55"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 56" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=56"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 57" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=57"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 58" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=58"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 59" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=59"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 60" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=60"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 61" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=61"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 62" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=62"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 63" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=63"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 64" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=64"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 65" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=65"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 66" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=66"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 67" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=67"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 68" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=68"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 69" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=69"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 70" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=70"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 71" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=71"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:56 PM P</a> <a title="March 2012 page 72" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=72"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:57 PM P</a> <a title="March 2012 page 73" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=73"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:57 PM P</a> <a title="March 2012 page 74" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=74"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:57 PM P</a> <a title="March 2012 page 75" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=75"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:57 PM P</a> <a title="March 2012 page 76" href="https://secure.viewer.zmags.com/publication/c4a0ff6f?page=76"> S12_Dev_Broch_32pgsv4:DC 12/13/11 4:57 PM P</a>