안녕하세요. 주디아줌마입니다^^

신년 잘 보내셨나요~ 리플래쉬 휴가와 신년이 겹쳐서 Daily Links를 많이 쉬게 되었네요^^ SQLTAG 회원님들~ 새해 복 많이 받으세요~

SQL

• SQL Server Diagnostic Information Queries for January 2014

  http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-january-2014

• Trace Flag 4199: Complex Risk Assessment Part I

  http://sql-sasquatch.blogspot.kr/2014/01/trace-flag-4199-complex-risk-assessment.html

     

• Trace Flag 4199: Complex Risk Assessment: Part II

  http://sql-sasquatch.blogspot.kr/2014/01/trace-flag-4199-complex-risk-assessment_6.html

     

• Reliably Dropping a Database in a T-SQL Script is Too Hard

  http://sqlblog.com/blogs/greg_low/archive/2014/01/06/reliably-dropping-a-database-in-a-t-sql-script-is-too-hard.aspx

• SQL Server Quickie #9 ? Clustered Indexes

  http://www.sqlpassion.at/archive/2014/01/06/sql-server-quickie-9-clustered-indexes

     

• SQL SERVER ? How to get the list of all triggers using sp_MSforeachtable

  http://raresql.com/2014/01/05/sql-server-how-to-get-the-list-of-all-triggers-using-sp_msforeachtable/

• Fraud Detection with the SQL Server Suite Part 5

  http://sqlblog.com/blogs/dejan_sarka/archive/2014/01/06/fraud-detection-with-the-sql-server-suite-part-5.aspx

     

• SQL Simplicity Methods

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/sql-simplicity-methods.aspx

     

• Transactions: Rolling back a transaction inside a stored procedure.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/transactions-rolling-back-a-transaction-inside-a-stored-procedure.aspx

     

• Day 11 ? Purging syspolicy

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/04/day-11-purging-syspolicy.aspx

     

• SQL Server ? Different ways to check Recovery Model of a database

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/sql-server-different-ways-to-check-recovery-model-of-a-database.aspx

     

• Clarity in T-SQL: Adjoining Socks

  http://www.midnightdba.com/Jen/2014/01/clarity-in-t-sql-adjoining-socks/

     

• Proactive Performance Management for the New Year

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/proactive-performance-management-for-the-new-year.aspx

     

• Organize Those Holiday Photos with PowerShell

  http://sqlblog.com/blogs/merrill_aldrich/archive/2014/01/05/organize-those-holiday-photos-with-powershell.aspx

     

• PowerShell ? Find OS architecture (32 bit or 64 bit) of local or remote machines Using Powershell

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/powershell-find-os-architecture-32-bit-or-64-bit-of-local-or-remote-machines-using-powershell.aspx

• Steps to recover access/reset SA Password to SQL Server Instance without downtime

  http://sqldbpool.com/2014/01/06/steps-to-recover-accessreset-sa-password-to-sql-server-instance-without-downtime/        

     

• SSAS Dynamic KPI from a table

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/ssas-dynamic-kpi-from-a-table.aspx

     

Other

• 대용량 세션을 위한 로드밸런서

  http://helloworld.naver.com/helloworld/textyle/605418

SQL

• Script to get articles detail - SQL Server Replication

  http://beyondrelational.com/modules/2/blogs/88/Posts/19770/script-to-get-articles-detail-sql-server-replication.aspx

• Using DQS with SQL Server AlwaysOn AG

  http://blogs.msdn.com/b/blogdoezequiel/archive/2013/12/23/using-dqs-with-sql-server-alwayson-ag.aspx

     

• How to Cache Stored Procedure Results

  http://www.brentozar.com/archive/2013/12/how-to-cache-stored-procedure-results/

     

• 12 Days of Christmas 2013 Day 2

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/26/12-days-of-christmas-2013-day-2.aspx

     

• Entity Data Modeling with Visual Studio

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/26/entity-data-modeling-with-visual-studio.aspx

     

• #0313 - SQL Server - sp_help returns double the field length for Unicode characters

  http://beyondrelational.com/modules/2/blogs/77/Posts/19761/0313-sql-server-sphelp-returns-double-the-field-length-for-unicode-characters.aspx

• SQL Server could not spawn FRunCommunicationsManager thread

  http://www.mssqltips.com/sqlservertip/3114/sql-server-could-not-spawn-fruncommunicationsmanager-thread/

     

• LAST WEEKS TOP "READING" LINKS #63

  http://www.jasonstrate.com/2013/12/last-weeks-top-reading-links-63/

     

Other

• 2 cases for MySQL server overload

  http://www.mysqlperformanceblog.com/2013/12/26/two-cases-mysql-server-overload/

     

• TDD에 관한 비용적인 관점

  http://mimul.com/pebble/default/2013/12/26/1388037319240.html

     

• [MOOC추천] Statistical Learning (스탠포드대학)

  http://zeronova.kr/2013/12/26/mooc-statistical-learning/

SQL

• Understanding SQL Server Memory-Optimized Tables Hash Indexes

  http://www.mssqltips.com/sqlservertip/3099/understanding-sql-server-memoryoptimized-tables-hash-indexes/

• Always Waiting, Waiting Waiting

  http://jasonbrimhall.info/2013/12/23/always-waiting-waiting-waiting

     

• Automate Your ETL Infrastructure with SSIS and PowerShell

  http://sqlblog.com/blogs/sergio_govoni/archive/2013/12/25/automate-your-etl-infrastructure-with-ssis-and-powershell.aspx

     

• Does Santa Understand SQL Server Profiler and Extended Events?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/24/does-santa-understand-sql-server-profiler-and-extended-events.aspx

     

• Parameterized Queries

  http://www.databasejournal.com/features/mssql/article.php/3834501/Parameterized-Queries.htm

     

• How to Compare Rows within Partitioned Sets to Find Overlapping Dates

  http://www.sqlservercentral.com/articles/CTE/71169/

     

• Meet Doug Lane (Video)

  http://www.brentozar.com/archive/2013/12/meet-doug-lane-video/

     

• SQL SERVER ? How to recover the accidentally renamed object name

  http://raresql.com/2013/12/24/sql-server-how-to-recover-the-accidentally-renamed-object-name/

     

• Creating Inferred Dimension Members with SSIS

  http://www.sqlservercentral.com/articles/Data+Warehouse/71233/

     

• Reporting Services Performance and Optimization

  http://blogs.msdn.com/b/sqlcat/archive/2013/10/30/reporting-services-performance-and-optimization.aspx

     

Other

• 로아컨설팅이 선정한 2014년 ICT 이슈 톱 10

  http://www.techsuda.com/archives/2825

     

• Renaming database schema in MySQL

  http://www.mysqlperformanceblog.com/2013/12/24/renaming-database-schema-mysql/

     

• [OpenStack Class] 제2강 컴퓨트 서비스와 스토리지 서비스

  http://naleejang.tistory.com/90

SQL

• Q: Can High MaxDOP make a query SLOWER?

  http://www.brentozar.com/archive/2013/12/q-can-high-maxdop-make-a-query-slower/

• Issues Encountered when Upgrading SQL Server 2012 Service Pack 1 with a Cumulative Update

  http://www.mssqltips.com/sqlservertip/3125/issues-encountered-when-upgrading-sql-server-2012-service-pack-1-with-a-cumulative-update/

     

• Power Query load settings

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/23/power-query-load-settings.aspx

     

• SSMS Shortcuts and more

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/23/ssms-shortcuts-and-more.aspx

     

• The DBAdmin ToolKit

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/23/the-dbadmin-toolkit.aspx

     

• SSIS For Loop Skip Files

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/23/ssis-for-loop-skip-files.aspx

     

• SQL Server 2012 공유 기능을 추가하여 Prepare image 생성

  http://laigo.kr/747

     

Other

• MySQL 5.7.3 milestone release fixes some of my pet peeves

  http://www.mysqlperformanceblog.com/2013/12/23/mysql-5-7-3-milestone-release-fixes-pet-peeves/

SQL

• SQL Server 2014 CTP 2 : Native Backup Encryption

  http://www.pythian.com/blog/sql-server-2014-ctp-2-native-backup-encryption/

     

• Tracking execution stats of SQL Server 2014 natively-compiled sprocs

  http://www.sqlskills.com/blogs/bobb/tracking-execution-stats-of-sql-server-2014-natively-compiled-sprocs/

• Memory Optimized Indexes | Hash vs Range Indexes

  http://sqlwithmanoj.wordpress.com/2013/12/20/memory-optimized-indexes-hash-vs-range-indexes/

     

• New SQL Server 2014 Dynamic Management Views

  http://www.mssqltips.com/sqlservertip/3111/new-sql-server-2014-dynamic-management-views/

     

• SQLskills holiday gift to you: all 2012 Insider videos

  http://www.sqlskills.com/blogs/paul/sqlskills-holiday-gift-to-you-all-2012-insider-videos

  와우~~^___^

     

• DMV : sys.dm_exec_connections

  http://sqljunkieshare.com/2013/12/22/dmv-sys-dm_exec_connections/

     

• Optimizing SQL Server Performance: Using Your Counters ? Part 2

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/20/optimizing-sql-server-performance-using-your-counters-part-2.aspx

     

• Non-Join Cross-Table Predicate Correlation Changes

  http://www.sqlskills.com/blogs/joe/non-join-cross-table-predicate-correlation-changes

     

• Database Administration Questions

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/21/database-administration-questions.aspx

     

• Identify datatype of variable/column value using SQL_VARIANT_PROPERTY function

  http://beyondrelational.com/modules/2/blogs/70/posts/19764/identify-datatype-of-variablecolumn-value-using-sqlvariantproperty-function.aspx

     

• Tracking execution stats of SQL Server 2014 natively-compiled sprocs

  http://www.sqlskills.com/blogs/bobb/tracking-execution-stats-of-sql-server-2014-natively-compiled-sprocs/

     

• Repairing a Broken Log Shipping Plan From a Differential Backup

  http://www.sqlservercentral.com/articles/differential/93482/

     

• Connections vs Sessions vs Requests : SQL Server ? Dynamic management views

  http://sqljunkieshare.com/2013/12/22/connections-vs-sessions-vs-requests-sql-server-dynamic-management-views/

• VMWare vCPU dispatch overload without high perfmon %Processor Time or ESX %RDY...

  http://sql-sasquatch.blogspot.kr/2013/12/vmware-vcpu-dispatch-overload-without.html

     

• SQL SERVER ? Fix ? Error ? 10920 ? Cannot %S_MSG user-defined function '%.*ls'. It is being used as a resource governor classifier.

  http://raresql.com/2013/12/22/sql-server-fix-error-10920-cannot-s_msg-user-defined-function-ls-it-is-being-used-as-a-resource-governor-classifier/

     

• Creating a Table Warehouse to Retain Historical Data for a SQL Server Table

  http://www.mssqltips.com/sqlservertip/3123/creating-a-table-warehouse-to-retain-historical-data-for-a-sql-server-table/

LINKS

• Log Buffer #351, A Carnival of the Vanities for DBAs

  http://www.pythian.com/blog/log-buffer-351-a-carnival-of-the-vanities-for-dbas/

• (SFTW) SQL Server Links 20/12/13

  http://www.johnsansom.com/sql-server-links-201213/

     

Other

• 데이터가 21세기 원유라구요? 그렇다면 제일 먼저 생각해야 할 것은 …

  http://kimws.wordpress.com/2013/12/21/%EB%8D%B0%EC%9D%B4%ED%84%B0%EA%B0%80-21%EC%84%B8%EA%B8%B0-%EC%9B%90%EC%9C%A0%EB%9D%BC%EA%B5%AC%EC%9A%94-%EA%B7%B8%EB%A0%87%EB%8B%A4%EB%A9%B4-%EC%A0%9C%EC%9D%BC-%EB%A8%BC%EC%A0%80-%EC%83%9D%EA%B0%81/

SQL

• A First Look at the New SQL Server Cardinality Estimator

  http://www.sqlperformance.com/2013/12/t-sql-queries/a-first-look-at-the-new-sql-server-cardinality-estimator

     

  XTP (eXtreme Transaction Processing) with Hekaton Tables & Stored Procedures

• http://sqlwithmanoj.wordpress.com/2013/12/19/xtp-extreme-transaction-processing-with-hekaton-tables-stored-procedures/

     

• Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers

  http://www.mssqltips.com/sqlservertip/3139/improve-sql-server-efficiency-by-switching-to-instead-of-triggers/

     

• More on Exponential Backoff

  http://www.sqlskills.com/blogs/joe/more-on-exponential-backoff

     

• How Would You Change Windows Azure SQL Database?

  http://www.brentozar.com/archive/2013/12/how-would-you-change-windows-azure-sql-database/

     

• How to Set Up Managed Backups in SQL Server 2014

  http://www.scarydba.com/2013/12/19/how-to-set-up-managed-backups-in-sql-server-2014/

     

• Automation: Changing SQL Service Startup Parameters using T-SQL

  http://www.sqlservercentral.com/articles/Automation/105511/

     

• Step-by-step installation of a SQL Server 2012 Clustered Instance ? Part 3

  http://www.pythian.com/blog/step-by-step-installation-of-a-sql-server-2012-clustered-instance-part-3/

     

• Transactions: Rolling back part of a transaction.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/19/transactions-rolling-back-part-of-a-transaction.aspx

     

• BASIC OF SSIS

  http://beyondrelational.com/modules/2/blogs/1045/posts/19768/basic-of-ssis.aspx

     

• SSIS PACKAGE EXECUTION IN SQL SERVER

  http://beyondrelational.com/modules/2/blogs/1045/posts/19767/ssis-package-execution-in-sql-server.aspx

     

• Virtual Cube in SSAS

  http://beyondrelational.com/modules/2/blogs/1045/posts/19766/virtual-cube-in-ssas.aspx

     

• In memory computing of hadoop is a big breakthrough

  http://beyondrelational.com/modules/2/blogs/925/posts/19765/in-memory-computing-of-hadoop-is-a-big-breakthrough.aspx

     

• Schema Compare or Publish [SSDT]

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/12/19/schema-compare-or-publish-ssdt.aspx

     

Other

• Learning PostgreSql: Fun with REPEATABLE READ

  http://sqlblog.com/blogs/alexander_kuznetsov/archive/2013/12/19/learning-postgresql-fun-with-repeatable-read.aspx

     

• 비트코인, 라이트코인의 거래와 채굴 - 가상 화폐 체험과 전망

  http://bryans.tistory.com/169

     

• 윈도우XP 지원 종료, '100일 앞으로'

  http://www.techsuda.com/archives/2800

SQL

• 5 THINGS EVERY DBA NEEDS TO SAY TO A DEVELOPER

  http://thomaslarock.com/2013/12/5-things-every-dba-needs-say-developer/

     

• Auto-Scaling SQL Server AlwaysOn Availability Groups with Virtualization

  http://www.brentozar.com/archive/2013/12/auto-scaling-sql-server-alwayson-availability-groups-with-virtualization/

     

• In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP2

  http://www.pythian.com/blog/in-memory-oltp-engine-hekaton-in-sql-server-2014-ctp2/

     

• How to Use Microsoft's AMR Tool

  http://www.databasejournal.com/features/mssql/how-to-use-microsofts-amr-tool.html

     

• Performance Comparison - Storing XML data in-row versus out-of-row

  http://www.mssqltips.com/sqlservertip/3134/performance-comparison--storing-xml-data-inrow-versus-outofrow/

     

• Encryption and Compression

  http://itknowledgeexchange.techtarget.com/sql-server/encryption-and-compression/

     

• Stairway to SQL Server Replication - Level 5: Transactional Replication & How it works

  http://www.sqlservercentral.com/articles/Stairway+Series/Transactional+Replication+%E2%80%93+How+it+works/72277/

     

• SQL Server monitoring and optimization ? (Part 1)

  http://www.sswug.org/articles/memberarticle.aspx?id=71775

     

• Parameterization ? A quick note on a CSS SQL article

  http://www.midnightdba.com/Jen/2013/12/parameterization-a-quick-note-on-a-css-sql-article/

     

• Calculating the Median Value within a Partitioned Set Using T-SQL

  https://www.simple-talk.com/sql/t-sql-programming/calculating-the-median-value-within-a-partitioned-set-using-t-sql/

     

• SQL SERVER ? How to Survive on Free Tools for Month ? ApexSQL Complete ? A Free SQL Assistant

  http://blog.sqlauthority.com/2013/12/18/sql-server-how-to-survive-on-free-tools-for-month-apexsql-complete-a-free-sql-assistant/

     

• Active Directory and SQL Server Questions Answered

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/18/active-directory-and-sql-server-questions-answered.aspx

     

Other

2013년도 얼마 남지 않았네요.^^ SQLTAG 회원분들도 홧팅하세요~

SQL

• RECOMPILE Hints and Execution Plan Caching

  http://www.brentozar.com/archive/2013/12/recompile-hints-and-execution-plan-caching/

• A couple of small issues with Hekat/on samples

  http://www.sqlperformance.com/2013/12/system-configuration/hekaton-sample-issues

     

• SQL Server Storage Engine: Heap Tables

  http://aboutsqlserver.com/2013/12/17/sql-server-storage-engine-heap-tables/

     

• Removing the Linked Server 2 hop Limitation

  http://www.sqlservercentral.com/articles/Authentication/104979/

     

• Introducing Managed Backups in SQL Server 2014

  http://www.scarydba.com/2013/12/17/introducing-managed-backups-in-sql-server-2014/

• 'Tis the Season to...Resolve SQL Server Deadlocks with Extended Events

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/17/39-tis-the-season-to-resolve-sql-server-deadlocks-with-extended-events.aspx

     

• Transactions: Rolling back a transaction

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/17/transactions-rolling-back-a-transaction.aspx

     

• Step-by-step installation of a SQL Server 2012 Clustered Instance ? Part 2

  http://www.pythian.com/blog/step-by-step-installation-of-a-sql-server-2012-clustered-instance-part-2/

     

• Power Query now imports relationships #powerquery #powerpivot

  http://sqlblog.com/blogs/marco_russo/archive/2013/12/17/power-query-now-imports-relationships-powerquery-powerpivot.aspx

     

• SQL Server Analysis Services and MDX Ordering and Sorting

  http://www.mssqltips.com/sqlservertip/3129/sql-server-analysis-services-and-mdx-ordering-and-sorting/

     

Other

• Is SQL the New NoNoSQL?

  http://java.dzone.com/articles/sql-new-nonosql

UPDATE

• SQL Server 2012 RTM Cumulative Update 11

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/12/16/sql-server-2012-rtm-cumulative-update-11.aspx

• CU#11 KB Article: http://support.microsoft.com/kb/2908007
• Understanding Incremental Servicing Model for SQL Server
• SQL Server Support Information: http://support.microsoft.com/ph/2855
• Previous SQL Server 2012 Service Releases: http://support.microsoft.com/kb/2692828

SQL

• Implementing Auditing in SQL Server

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/16/implementing-auditing-in-sql-server.aspx

• SQL SERVER ? How to get only the numbers after the decimal?

  http://raresql.com/2013/12/16/sql-server-how-to-get-only-the-numbers-after-the-decimal/

• Nine T-SQL best practices

  http://searchsqlserver.techtarget.com/tip/Nine-T-SQL-best-practices

     

• Import UTF-8 Unicode Special Characters with SQL Server Integration Services

  http://www.mssqltips.com/sqlservertip/3119/import-utf8-unicode-special-characters-with-sql-server-integration-services/

     

• Semi-Additive Measures, Unary Operators, Custom Rollups And The Calculate() Statement

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/16/semi-additive-measures-unary-operators-custom-rollups-and-the-calculate-statement.aspx

     

LINKS

• Last Weeks Top "Reading" Links #62

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/16/last-weeks-top-reading-links-62.aspx

Other

• Understanding the Limitations of MongoDB

  http://java.dzone.com/articles/understanding-limitations

     

• 비트코인의 개념과 실제

  http://bryans.tistory.com/167

SQL

• SQL Server 2012 Diagnostic Information Queries (December 2013)

  http://www.sqlskills.com/blogs/glenn/sql-server-2012-diagnostic-information-queries-december-2013/

• In-memory table DML statistics

  http://sqlscope.wordpress.com/2013/12/14/in-memory-table-dml-statistics/

• SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/12/10/sql-server-2014-hybrid-cloud-scenarios-migrating-on-premises-sql-server-to-windows-azure-virtual-machines.aspx

• New In-Memory OLTP Sample for SQL Server 2014 CTP2        

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/11/11/new-in-memory-oltp-sample-for-sql-server-2014-ctp2.aspx        

     

• SQL Server 2014 In-Memory OLTP: Memory Management for Memory-Optimized Tables

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/11/14/sql-server-2014-in-memory-oltp-memory-management-for-memory-optimized-tables.aspx

     

• Boosting Transaction Performance in Windows Azure Virtual Machines with In-Memory OLTP

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/11/25/boosting-transaction-performance-in-windows-azure-virtual-machines-with-in-memory-oltp.aspx

     

• SQL Server 2014 In-Memory OLTP Architecture and Data Storage

  http://www.mssqltips.com/sqlservertip/3106/sql-server-2014-inmemory-oltp-architecture-and-data-storage/

• Understanding SQL Server Query Optimization ? Part 3

  http://www.sql-server-performance.com/2013/sql-server-query-optimization-part-3/

     

• Beware the ß

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/12/13/beware-the.aspx

     

• Understanding Triggers

  http://www.sswug.org/articles/memberarticle.aspx?id=71111

     

• Microsoft SQL Server Data Tools Update

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/11/13/microsoft-sql-server-data-tools-update.aspx

     

• Ways to View Content Published to a Power BI Site

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/15/ways-to-view-content-published-to-a-power-bi-site.aspx

• #0310 - SQL Server - CONCAT_NULL_YIELDS_NULL property

  http://beyondrelational.com/modules/2/blogs/77/Posts/19733/0310-sql-server-concatnullyieldsnull-property.aspx

     

• XQuery Labs 69-Writing a Recursive query that walks through an XML Hierarchy

  http://beyondrelational.com/modules/2/blogs/28/Posts/19734/xquery-labs-69-writing-a-recursive-query-that-walks-through-an-xml-hierarchy.aspx

     

• Evolving your SQL Server Data Warehouse to the Next Generation, High Performance Solution, the SQL Server Parallel Data Warehouse (PDW)

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/11/20/evolving-your-sql-server-data-warehouse-to-the-next-generation-high-performance-solution-the-sql-parallel-data-warehouse-pdw.aspx

     

• How Does SQL Server Parallel Data Warehouse (PDW) Deliver the Performance that it Does?

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/11/15/how-does-sql-server-parallel-data-warehouse-pdw-deliver-the-performance-that-it-does.aspx

     

• Possible ways to secure SSIS Packages

  http://www.sswug.org/articles/memberarticle.aspx?id=70898

     

• The Modern Data Warehouse

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/11/21/the-modern-data-warehouse.aspx

     

• Adam Machanic talks SQL Saturday

  http://searchsqlserver.techtarget.com/video/Adam-Machanic-talks-SQL-Saturday

     

• DAX Query - Part 2

  http://www.sqlservercentral.com/articles/DAX/97522/

     

• Format your #dax code with DAX Formatter

  http://sqlblog.com/blogs/marco_russo/archive/2013/12/13/format-your-dax-code-with-dax-formatter.aspx

     

• Enabling High Performance Power Plan via PowerShell

  http://www.sqlsoldier.com/wp/sqlserver/enabling-high-performance-power-plan-via-powershell

     

• Log Buffer #350, A Carnival of the Vanities for DBAs

  http://www.pythian.com/blog/log-buffer-350-a-carnival-of-the-vanities-for-dbas/

     

• (SFTW) SQL Server Links 13/12/13

  http://www.johnsansom.com/sql-server-links-131213/

     

Other

• How could Database realize real-time computation of Big Data

  http://beyondrelational.com/modules/2/blogs/925/posts/19750/how-could-database-realize-real-time-computation-of-big-data.aspx