UPDATE

• January 2014 Cumulative Update for SQL Server 2008 SP3

  http://sqlblog.com/blogs/aaron_bertrand/archive/2014/01/20/january-2014-cumulative-update-for-sql-server-2008-sp3.aspx

     

  • Build # 10.00.5850
  • KB Article: KB #2923520
  • 3 fixes
  • Relevant for builds 10.00.5500 -> 10.00.5849
  • NOT for SQL Server 2008 R2 (10.50.xxxx)

     

• SQL Server 2012 Service Pack 1 Cumulative Update #8 is available!        

  http://sqlblog.com/blogs/aaron_bertrand/archive/2014/01/20/sql-server-2012-service-pack-1-cumulative-update-8-is-available.aspx        

• KB Article: KB #2917531
• Build # is 11.0.3401
• Currently there are 32 fixes; the most interesting to me are:
  • KB #2892741 - FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012
  • KB #2888996 - FIX: Data purity corruption in sys.sysbinobjs table in master database when you log on to SQL Server 2008 R2 or SQL Server 2012 by using the SA account and then run DBCC CHECKDB
  • KB #2901714 - FIX: Server crashes when you import a Windows Azure SQL database to a local SQL Server 2012 database
  • KB #2918791 - FIX: The system function sys.fn_hadr_backup_is_preferred_replica does not work correctly after you have CU7 for SQL Server 2012 SP1 installed
  • KB #2923460 - FIX: The query deadlocks when the ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled in SQL Server 2012                

     

SQL

• SQL Server 2014 ? Buffer Pool Extension

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/20/sql-server-2014-buffer-pool-extension.aspx

     

• Throughput improvement through Delayed Durability on COMMIT TRAN from SQL Server 2014

  http://dataidol.com/tonyrogerson/2014/01/08/throughput-improvement-through-delayed-durability-on-commit-tran-from-sql-server-2014/

     

• Hekaton In-Memory Tables: HASH Indexes

  http://dataidol.com/tonyrogerson/2014/01/06/hekaton-in-memory-tables-hash-indexes/

     

• SQL Server 2012: Trace Flags

  http://troubleshootingsql.com/2014/01/20/sql-server-2012-trace-flags/

     

• 2013 in Review ? SQL Server

  http://www.pythian.com/blog/2013-in-review-sql-server/

• SQL SERVER ? How to remove leading zeros after a decimal point

  http://raresql.com/2014/01/20/sql-server-how-to-remove-leading-zeros-after-a-decimal-point/

     

• Schema-only Backups and Restores

  http://www.sqlsoldier.com/wp/sqlserver/schemaonlybackupsandrestores        

     

• Default Database Issues and Best Practices

  http://www.sql-server-performance.com/2014/default-database-best-practices/

     

• Transactions: Who, What and Where

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/20/transactions-who-what-and-where.aspx        

     

• Logging and Error Handling for SQL Stored Procedures

  http://www.sqlservercentral.com/articles/Error+Handling/105909/

     

• Database Health Monitor Beta 8.1 Released Today

  http://stevestedman.com/2014/01/database-health-monitor-beta-8-1-released-today/

     

• Transactional Replication ? Find the Publisher

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/20/transactional-replication-find-the-publisher.aspx

     

• Monitoring availability groups and availability replicas status information using T-SQL

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/20/monitoring-availability-groups-and-availability-replicas-status-information-using-t-sql.aspx

     

• Monitoring For Endless Index Defragmenting ? January 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/20/monitoring-for-endless-index-defragmenting-january-2014.aspx

     

• PowerShell ? Program List ? 32/64 Bit ? Local/Remote Machies

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/20/powershell-program-list-32-64-bit-local-remote-machies.aspx

     

     

LINKS

• LAST WEEKS TOP "READING" LINKS #67

  http://www.jasonstrate.com/2014/01/last-weeks-top-reading-links-67/

     

• Recommended reading from mrdenny for January 17, 2014

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-january-17-2014/

     

Other

• 1월 24일 Couchbase 5차 meetup!

  http://cafe.naver.com/couchbase/1111

     

• "Quick" NoSQL Comparison: Measuring performance and failover of Aerospike, Cassandra, Couchbase, and MongoDB

  http://www.slideshare.net/bengber/no-sql-presentation

     

• 게임 개발도 클라우드로…히어로엔진, 국내 진출 선언

  http://cafe.naver.com/cloudfrontier/6397

     

• Stackoverflow.com 의 아키텍처

  http://yisangwook.tumblr.com/post/73202754212/stackoverflow-com?fb_action_ids=754445587918851&fb_action_types=og.likes&fb_source=aggregation&fb_aggregation_id=288381481237582

  캬... 정말 존경스럽네요

SQL

• Parameterization and filtered indexes (part 1)

  http://sqlblog.com/blogs/hugo_kornelis/archive/2014/01/19/parameterization-and-filtered-indexes-part-1.aspx

• Hekaton with a twist: In-memory TVPs ? Part 3

  http://www.sqlperformance.com/2014/01/t-sql-queries/hekaton-twist-3

     

• SQL SERVER ? Identify Oldest Active Transaction with DBCC OPENTRAN

  http://www.sqlserver.co.uk/index.php/sql-server-identify-oldest-active-transaction-with-dbcc-opentran/

     

• sp_Blitz™ v32: Emailing, Serializable Locking, Simultaneous Agent Jobs, and More

  http://www.brentozar.com/archive/2014/01/sp_blitz-v32-emailing-serializable-locking-simultaneous-agent-jobs-and-more/

     

• Creating a SQL Server DBA's Library

  http://www.mssqltips.com/sqlservertip/3142/creating-a-sql-server-dbas-library/

     

• DBA: Guardian of the Data

  http://www.sqlsoldier.com/wp/sqlserver/dbaguardianofthedata

     

• Fun with Outer Joins

  http://www.sqlservercentral.com/articles/T-SQL/93039/

     

• Dacpac braindump ? What is a dacpac?

  http://www.sqlserver.co.uk/index.php/dacpac-braindump/        

• Unreasonable Defaults: Primary Key as Clustering Key

  http://use-the-index-luke.com/blog/2014-01/unreasonable-defaults-primary-key-clustering-key

     

• Reduce Time for SQL Server Index Rebuilds and Update Statistics

  http://www.mssqltips.com/sqlservertip/3100/reduce-time-for-sql-server-index-rebuilds-and-update-statistics/

     

• The Performance of the T-SQL Window Functions

  https://www.simple-talk.com/sql/t-sql-programming/the-performance-of-the-t-sql-window-functions/

     

• SQL Server Deadlocks by Example

  https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

     

• How to Query the StackExchange Databases

  http://www.brentozar.com/archive/2014/01/how-to-query-the-stackexchange-databases/

     

• Don't $%^&ing Delete Your SQL Server Cluster Resource

  http://joedantoni.wordpress.com/2014/01/17/dont-ing-delete-your-sql-server-cluster-resource/

     

• SQL SERVER ? How to retrieve the metadata of a stored procedure

  http://raresql.com/2014/01/18/sql-server-how-to-retrieve-the-metadata-of-a-stored-procedure/

     

LINKS

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

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

• Friday Followup For January 17, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/17/friday-followup-for-january-17-2014.aspx

• (SFTW) SQL Server Links 17/01/14

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/17/sftw-sql-server-links-17-01-14.aspx

     

Other

• MONGODB AND THE FINE ART OF DATA MODELLING

  http://vladmihalcea.wordpress.com/2014/01/17/mongodb-and-the-fine-art-of-data-modelling/

     

• 노땅 개발자가 가야할 길

  http://mimul.com/pebble/default/2014/01/17/1389943844913.html

SQL

• Storage Allocation and Management for Memory-Optimized Tables

  http://www.sqlserver.co.uk/index.php/storage-allocation-and-management-for-memory-optimized-tables/

• One Intel Processor Family to Avoid For SQL Server 2012/2014 - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/one-intel-processor-family-to-avoid-for-sql-server-20122014

     

• Webcast Follow-Up: Necessary Evils, Building Optimized CRUD Procedures

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/16/webcast-follow-up-necessary-evils-building-optimized-crud-procedures.aspx

     

• #0319 - SQL Server - CTE and UNION

  http://beyondrelational.com/modules/2/blogs/77/Posts/19802/0319-sql-server-cte-and-union.aspx

     

• What would you do?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/16/what-would-you-do.aspx

     

• #0318 - SQL Server - Performance Tuning - Use Temp tables instead of table variables when working with large data sets

  http://beyondrelational.com/modules/2/blogs/77/Posts/19801/0318-sql-server-performance-tuning-use-temp-tables-instead-of-table-variables-when-working-with-larg.aspx

• VIRTUALIZING SQL SERVER: 8 THINGS TO AVOID

  http://thomaslarock.com/2014/01/virtualizing-sql-server-8-things-avoid-2

     

• Careful Adding Indexes with AlwaysOn Availability Groups

  http://www.brentozar.com/archive/2014/01/careful-adding-indexes-with-alwayson-availability-groups/

• Scaling-out SQL Server disks and data files on Windows Azure Virtual Machines…a real-world example

  http://blogs.msdn.com/b/sqlcat/archive/2014/01/16/scaling-out-sql-server-disks-and-data-files-on-windows-azure-virtual-machines-a-real-world-example.aspx

     

• Default Trace?Performance Issues

  http://troubleshootingsql.com/2014/01/16/default-traceperformance-issues/

     

• How write the a SQL Server agent Job status to the Windows Application log

  http://www.sqlserver-dba.com/2014/01/question-does-sql-server-allow-a-sql-server-agent-job-to-write-the-job-status-to-the-windows-application-log-answer-writ.html

• SQL Server 2014 Backup Basics

  https://www.simple-talk.com/sql/backup-and-recovery/sql-server-2014-backup-basics/

     

• Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

  http://www.sqlservercentral.com/articles/T-SQL/103343/

     

• Generating Test Data in TSQL

  https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/

     

• [SQL Snacks Video] Introducing SQL Snacks! A healthy alternative to boring learning!

  http://thesqlpro.com/2014/01/16/sqlsnacks/

     

• [SQL Snacks Video] Tail Log Backup and Recovery Demo

  http://thesqlpro.com/2014/01/16/sql-snacks-video-tail-log-backup-and-recovery-demo/

     

• Working with Spatial Data Part I ? Geocoding Text-Based Spatial Data for Use In SSIS Packages

  http://www.sql-server-performance.com/2014/spatial-data-geocoding/

     

Other

• Analyzing WordPress MySQL queries with Query Analytics

  http://www.mysqlperformanceblog.com/2014/01/16/analyzing-wordpress-mysql-queries-query-analytics/

     

• Sharding, Scaling, Data Storage Methodologies, and More: Insights on Big Data

  http://java.dzone.com/articles/sharding-scaling-data-storage

SQL

• Cardinality Estimation for Multiple Predicates - Paul White

  http://www.sqlperformance.com/2014/01/sql-plan/cardinality-estimation-for-multiple-predicates

• Default Configuration of SQL Server (and query hints)

  http://blog.kejser.org/2014/01/15/default-configuration-of-sql-server-and-query-hints/

     

• A Little Bit More on Columnstore (SQL 2014) Internals

  http://joedantoni.wordpress.com/2014/01/15/a-little-bit-more-on-columnstore-sql-2014-internals/

     

• Fixing TempDB database problems when starting SQL using a minimum config

  http://itknowledgeexchange.techtarget.com/sql-server/fixing-tempdb-database-problems-when-starting-sql-using-a-minimum-config/

     

• Curious Partition Function Behaviour

  http://blog.kejser.org/2014/01/15/curious-partition-function-behaviour/

     

• Database in Source Control

  http://www.scarydba.com/2014/01/15/database-in-source-control/

     

• T-SQL Tuesday #50: Database Role Membership

  http://troubleshootingsql.com/2014/01/15/t-sql-tuesday-50-database-role-membership/

     

• T-SQL Tuesday #50: Automation for LazyDBAs!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/t-sql-tuesday-50-automation-for-lazydbas.aspx

     

• Stairway to Advanced T-SQL Level 1: The TOP Clause

  http://www.sqlservercentral.com/articles/Stairway+Series/104499/

     

• sp_SrvPermissions & sp_DBPermissions V4.0

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/15/sp-srvpermissions-amp-sp-dbpermissions-v4-0.aspx

     

• Avoid GUID clustered index write problem

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/15/avoid-guid-clustered-index-write-problem.aspx

     

• SSMS Trick: Edit Large Procedures with the Splitter Bar

  http://www.brentozar.com/archive/2014/01/ssms-trick-edit-large-procedures-with-the-splitter-bar/

     

• Open SSMS Query Results in Excel with a Single Click

  http://spaghettidba.com/2014/01/16/open-ssms-query-results-in-excel-with-a-single-click/

     

• SQL Server Management Perfected - The Times They Are A-Changin'

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/15/sql-server-management-perfected-times-they-are-a-changin.aspx

     

• Use Powershell to Send Email Notification for SQL Server Cluster Failover

  http://www.mssqltips.com/sqlservertip/3151/use-powershell-to-send-email-notification-for-sql-server-cluster-failover/

     

Other

• Vedis - An Embedded Implementation Of Redis Supporting Terabyte Sized Databases

  http://highscalability.com/blog/2014/1/15/vedis-an-embedded-implementation-of-redis-supporting-terabyt.html

     

• 국도 교통체계 개선에 인메모리 DB 적용…리얼타임테크 '카이로스 RDBMS'

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

SQL

• SQL Server Diagnostic Information Queries for January 2014

  http://sqlserverperformance.wordpress.com/2014/01/14/sql-server-diagnostic-information-queries-for-january-2014/

• How to throttle your Storage with Resource Governor in SQL Server 2014

  http://www.sqlpassion.at/archive/2014/01/14/how-to-throttle-your-storage-with-resource-governor-in-sql-server-2014

     

• HOW TO: RESTORE THE MASTER DATABASE IN SQL SERVER 2012

  http://thomaslarock.com/2014/01/restore-the-master-database-in-sql-server-2012

     

• Correlating SQL Server 2014 cardinality events and query plan

  http://www.sqlskills.com/blogs/bobb/correlating-sql-server-2014-cardinality-events-and-query-plan/

• Extending automation of SQL recoveries using Ola Hallengren's backup solution

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/extending-automation-of-sql-recoveries-using-ola-hallengren-s-backup-solution.aspx

     

• Top Support Solutions for Microsoft SQL Server

  http://blogs.technet.com/b/topsupportsolutions/archive/2013/11/06/top-support-solutions-for-microsoft-sql-server.aspx

     

• Delayed Durability

  http://www.sqlstash.com/2014/01/14/delayed-durability/

     

• Gatting started with Windows Azure PowerShell        

  http://miteshc.wordpress.com/2014/01/14/gatting-started-with-windows-azure-powershell-3/

     

• Operations team and sql server permissions

  http://www.sqlserver-dba.com/2014/01/operations-team-and-sql-server-permissions.html

     

• PowerShell ? Change SQL Server Login Password

  http://www.johnsansom.com/powershell-change-sql-server-login-password/

     

• Write-BlogPost

  http://sqlblog.com/blogs/rob_farley/archive/2014/01/14/write-blogpost.aspx

     

• T-SQL Tuesday #050: Automating Database Restores

  http://jasonbrimhall.info/2014/01/14/t-sql-tuesday-050-automating-database-restores

     

• T-SQL Tuesday #50: Automation, how much of it is the same?

  http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/t-sql-tuesday-50-automation/

     

• T-SQL Tuesday #50 ? Automating Your Installs

  http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/mssqlserveradmin/t-sql-tuesday-50-automating-your-installs/

     

• Automation? Think Causation, not Correlation

  http://sqlblog.com/blogs/merrill_aldrich/archive/2014/01/14/automation-think-causation-not-correlation.aspx

     

• Sometimes It's A Dirty Job ? #TSQL2sDAY #50

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/sometimes-it-s-a-dirty-job-tsql2sday-50.aspx

     

• SSIS & DQS: The Knowledgebase does not exist

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/ssis-amp-dqs-the-knowledgebase-does-not-exist.aspx

     

• "My Power BI" Sites

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/my-power-bi-sites.aspx

     

• Generate two-dimensional QR Code® bar codes in an SSRS report

  http://www.sqlservercentral.com/articles/QR+Code/105388/

     

Other

• nBase-ARC: Redis Cluster

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

• InnoDB file formats: Here is one pitfall to avoid

  http://www.mysqlperformanceblog.com/2014/01/14/innodb-file-formats-here-is-one-pitfall-to-avoid/

• EVERYDAY POSTGRES: SPECIFYING ALL YOUR INSERT COLUMNS

  http://www.chesnok.com/daily/2014/01/14/everyday-postgres-specifying-all-your-insert-columns

     

• Independent consultant: How to find work

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/independent-consultant-how-to-find-work.aspx

SQL

• What Does a Good Mentor Do for You?

  http://kevinekline.com/2014/01/13/what-does-a-good-mentor-do-for-you/

• SQL Server 2014 Columnstore Index Update Internals

  http://joedantoni.wordpress.com/2014/01/13/sql-server-2014-columnstore-index-update-internals/

     

• SQL Server 2014 ? Delayed Durability

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/sql-server-2014-delayed-durability.aspx

     

• SQL Server Backup and Recovery: Simple, Full and Bulk Recovery

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/sql-server-backup-and-recovery-simple-full-and-bulk-recovery.aspx

     

• T-SQL to check Data and Log Files are on same drive or not.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/t-sql-to-check-data-and-log-files-are-on-same-drive-or-not.aspx

     

• Guid vs Identity columns (Ints)

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/guid-vs-identity-columns-ints.aspx

     

• SQL Server ? Difference between @@CONNECTIONS and @@MAX_CONNECTIONS

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/sql-server-difference-between-connections-and-max-connections.aspx

     

• Using Powershell with SQL Server Clusters ? Getting Information

  http://www.seangallardy.com/2014/01/using-powershell-with-sql-server-clusters-getting-information

     

• My Favourite SSMS productivity tips

  http://mattsql.wordpress.com/2014/01/13/my-favourite-ssms-productivity-tips/

     

• SSAS ? Using the Euro or Pound currency Symbol in a measure Format String

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/ssas-using-the-euro-or-pound-currency-symbol-in-a-measure-format-string.aspx

     

• Understanding Peer-to-Peer Transactional Replication, Part 1

  http://www.sqlservercentral.com/articles/Replication/104652/

     

• Justifying the new Mac Pro

  http://www.sqlperformance.com/2014/01/system-configuration/justifying-the-new-mac-pro

• Monitor SQL Server Disk Space Using PowerShell

  http://www.mssqltips.com/sqlservertip/3109/monitor-sql-server-disk-space-using-powershell/

LINKS

• Last Weeks Top "Reading" Links #66

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/last-weeks-top-reading-links-66.aspx

     

Other

• Video: Name Resolution and Port Queries

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/video-name-resolution-and-port-queries.aspx

     

• Webinars: Common (but deadly) MySQL mistakes

  http://www.mysqlperformanceblog.com/2014/01/13/webinars-common-but-deadly-mysql-mistakes/

     

• Running Your Startup's Sign Up Form on AWS Elastic Beanstalk

  http://cloud.dzone.com/articles/running-your-startups-sign

SQL

• Top SQL Server blogs from MSSQLWIKI

  http://mssqlwiki.com/2014/01/11/top-sql-server-blogs-from-mssqlwiki/

  캬.. 엄청난 아티클들... 내공이 보여~~

     

• In-memory OLTP ? read_set, write_set, and scan_set

  http://www.sqlskills.com/blogs/bobb/in-memory-oltp-read_set-write_set-and-scan_set/

     

• Clustered Indexes vs. Heaps

  http://blog.kejser.org/2014/01/12/clustered-indexes-vs-heaps/

     

• Dynamic Sorting

  http://www.brentozar.com/archive/2014/01/dynamic-sorting/

     

• First release of my own personal T-SQL Code Library on github

  http://sqlblog.com/blogs/jamie_thomson/archive/2014/01/12/first-release-of-my-own-personal-t-sql-code-library-on-github.aspx

     

• Who Owns SQL Backups?

  http://www.sqlsoldier.com/wp/sqlserver/whoownssqlbackups

     

• SQL SERVER 2012 ? Fix ? Error :11526 ? The metadata could not be determined because statement '%.*ls' in procedure '%.*ls' uses a temp table.

  http://raresql.com/2014/01/10/sql-server-2012-fix-error-11526-the-metadata-could-not-be-determined-because-statement-ls-in-procedure-ls-uses-a-temp-table/

     

• SQL Server 2012: Installing and configuring Distributed Replay

  http://www.pythian.com/blog/sql-server-2012-installing-and-configuring-distributed-replay/

     

• T-SQL ? Monitoring DiskSpace of Multiple Servers

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/10/t-sql-monitoring-diskspace-of-multiple-servers.aspx

     

• 2013 ? Review of Writing

  http://blogs.lessthandot.com/index.php/2014/01/sql-server-2013-onpnt/

     

• SQL Set Operators. Set? Really?

  http://sqlblog.com/blogs/dejan_sarka/archive/2014/01/10/sql-set-operators-set-really.aspx

     

• TempDB - setting the initial size

  http://www.sqlserver-dba.com/2014/01/tempdb-setting-the-initial-size.html

     

• A New Solution for Monitoring SQL Server

  http://blogs.lessthandot.com/index.php/2013/12/a-new-solution-for-monitoring/

     

• SQL Agent Monitoring ? Long Running Job Queries

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/10/sql-agent-monitoring-long-running-job-queries.aspx

     

• Adding or removing the IDENTITY property

  http://sqlscope.wordpress.com/2014/01/10/adding-or-removing-the-identity-property/

     

• Resources to Study for Exam 70-461

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/12/resources-to-study-for-exam-70-461.aspx

     

• Meteorite Findings Analysis with PowerBI

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/12/meteorite-findings-analysis-with-powerbi.aspx

     

• How to Install a Clustered SQL Server 2012 Instance ? Step-by-step ? Part 4

  http://www.pythian.com/blog/how-to-install-a-clustered-sql-server-2012-instance-step-by-step-part-4/

     

• Comparing Tables In Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/11/comparing-tables-in-power-query.aspx

     

• SSRS ? Identify a scheduled SSRS Report

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/10/ssrs-identify-a-scheduled-ssrs-report.aspx

     

• SQL Server Backup and Recovery: Instant File Initialization

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/09/sql-server-backup-and-recovery-instant-file-initialization.aspx

     

• The PoSh DBA - Reading and Filtering Errors

  https://www.simple-talk.com/sql/database-administration/the-posh-dba---reading-and-filtering-errors/

     

     

LINKS

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

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

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

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

     

• (SFTW) SQL Server Links 10/01/14

  http://www.johnsansom.com/sftw-sql-server-links-100114/

     

Other

• 5 WAYS TO VERIFY WHAT YOUR BIG DATA IS TELLING YOU

  http://thomaslarock.com/2014/01/5-ways-to-verify-what-your-big-data-is-telling-you/        

SQL

• Creating a DBA's Library

  http://www.mssqltips.com/sqlservertip/3142/creating-a-dbas-library/

• SQL Server DMVs that Lie

  http://www.brentozar.com/archive/2014/01/sql-server-dmvs-that-lie/

     

• SQL Server 2014 Backup Basics

  https://www.simple-talk.com/sql/backup-and-recovery/sql-server-2014-backup-basics/

     

• SQL Server 2014 CTP2 ? Memory Optimization Advisor

  http://www.pythian.com/blog/sql-server-2014-ctp2-memory-optimization-advisor/

     

• SQL Server 2014 memory-optimized table variables ? metadata and garbage collection

  http://www.sqlskills.com/blogs/bobb/sql-server-2014-memory-optimized-table-variables-metadata-and-garbage-collection/

     

• Finding a Deadlocked SQL Server Agent Job Name

  http://www.sqlskills.com/blogs/joe/finding-a-deadlocked-sql-server-agent-job-name

     

• Why Are You Still Using SQL Server 2005?

  http://www.brentozar.com/archive/2014/01/why-are-you-still-using-sql-server-2005/

     

• Why Transaction Log Auto Growths are degrading your performance

  http://www.sqlpassion.at/archive/2014/01/07/why-transaction-log-auto-growths-are-degrading-your-performance

     

• Transactions: What are they?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/08/transactions-what-are-they.aspx

     

• Cleaning up the Buffer Pool

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/08/cleaning-up-the-buffer-pool.aspx

     

• 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

     

• Relational database or graph database? Why not have both?

  http://www.sqlservercentral.com/articles/NoSQL/105585/

     

• Hidden Formatting Troubles with STR() (SQL Spackle)

  http://www.sqlservercentral.com/articles/T-SQL/71565/

     

• Using SQL Metadata to Create NULL Handling SSIS Expressions

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/01/using-sql-metadata-to-create-null-handling-ssis-expressions.aspx

     

• Apply SP1 to SQL Server 2012 on active/active Windows Server 2012 cluster.

  http://mattsql.wordpress.com/2014/01/08/apply-sp1-to-sql-server-2012-on-activeactive-windows-server-2012-cluster/

     

• Things I Learned in 2013

  http://www.dbnewsfeed.com/2014/01/02/things-i-learned-in-2013

     

Other

• [OpenStack Class] 제3강 클라우드의 핵심! 하이퍼바이저

  http://naleejang.tistory.com/91

     

• How to recover table structure from .frm files with MySQL Utilities

  http://www.mysqlperformanceblog.com/2014/01/02/recover-table-structure-frm-files-mysql-utilities/

     

• [왜 클로저(Clojure)인가?] 4. 단순한 코드와 복잡한 코드

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

SQL

• Indexed Views and Statistics - Paul White

  http://www.sqlperformance.com/2014/01/sql-plan/indexed-views-and-statistics

• SQL Server 2014 In Memory OLTP: Memory-Optimized Table Types and Table Variables

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/01/07/sql-server-2014-in-memory-oltp-memory-optimized-table-types-and-table-variables.aspx

• SQL Server 2014 In-Memory OLTP (Hekaton) Limitations

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/07/sql-server-2014-in-memory-oltp-hekaton-limitations.aspx

     

• How SQL Server 2014 improves Online Operations that aren't Online Operations

  http://www.sqlpassion.at/archive/2014/01/02/how-sql-server-2014-improves-online-operations-that-arent-online-operations

     

• Determing BUCKET_COUNT for Hash indexes for Memory-Optimized tables in SQL Server

  http://www.mssqltips.com/sqlservertip/3104/determing-bucketcount-for-hash-indexes-for-memoryoptimized-tables-in-sql-server/

     

• Unwinding Table Spools

  http://aboutsqlserver.com/2014/01/07/unwinding-table-spools/

     

• What's the Best Path to Becoming a DBA?

  http://www.johnsansom.com/whats-the-best-path-to-becoming-a-dba/

     

• Understanding SQL Server Query Optimization ? Part 4

  http://www.sql-server-performance.com/2014/understanding-sql-server-query-optimization-4/

     

• Clustered vs. Nonclustered Index Internal Structures (video)

  http://voluntarydba.com/post/2014/01/07/Clustered-vs-Nonclustered-Index-Internal-Structures.aspx

     

• SQL Schedulers disabled

  http://www.sqlserver-dba.com/2014/01/sql-schedulers-disabled.html

• How to receive Deadlock information automatically via email

  http://www.sqlservercentral.com/articles/deadlock/71374/

     

• PowerShell Data Basics: XML

  https://www.simple-talk.com/sysadmin/powershell/powershell-data-basics-xml/

     

• Aggregating By Local Groups In Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/03/aggregating-by-local-groups-in-power-query.aspx

     

• Getting started with Windows Azure PowerShell

  http://miteshc.wordpress.com/2014/01/07/gatting-started-with-windows-azure-powershell-2/

     

• SSIS: Understanding BufferTempStoragePath

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/07/ssis-understanding-buffertempstoragepath.aspx

     

• An AlwaysOn Bug with Service Broker Transmission Queue

  http://www.sqlservercentral.com/articles/Service+Broker/105446/

     

• Transfer files from Linux to Windows or vice versa using SSIS

  http://www.mssqltips.com/sqlservertip/3068/transfer-files-from-linux-to-windows-or-vice-versa-using-ssis/

     

Other

• Some More MySQL Tuning

  http://java.dzone.com/articles/some-more-mysql-tuning

• Increasing slow query performance with the parallel query execution

  http://www.mysqlperformanceblog.com/2014/01/07/increasing-slow-query-performance-with-parallel-query-execution/

• Learning postgreSql: serialization failures with SERIALIZABLE

  http://sqlblog.com/blogs/alexander_kuznetsov/archive/2014/01/06/learning-postgresql-serialization-failures-with-serializable.aspx

     

Links

• http://www.johnsansom.com/sftw-sql-server-links-030114/        

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

신년 잘 보내셨나요~ 리플래쉬 휴가와 신년이 겹쳐서 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