199회 SQLTag Daily Links

SQL

• (SFTW) SQL Server Links 30/08/13

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

     

• Duplicate Statistics

  http://mattsql.wordpress.com/2013/08/28/duplicate-statistics/

     

• Fixing a Bug: DBCC CHECKDB data purity checks are skipped for master and model - Glenn

  http://sqlserverperformance.wordpress.com/2013/08/29/fixing-a-bug-dbcc-checkdb-data-purity-checks-are-skipped-for-master-and-model/

• Returning The Contents Of Any Table In Any Excel Workbook In Sharepoint With Power Pivot And Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/29/returning-the-contents-of-any-table-in-any-excel-workbook-in-sharepoint-with-power-pivot-and-power-query.aspx

• The Database Decision Diagram

  http://www.brentozar.com/archive/2013/08/the-database-decision-diagram/
     

• The Evolution of the SQL Server DBA

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/08/29/the-evolution-of-the-sql-server-dba.aspx

     

• Quick tip: WMI alerts and SQL Server Agent permissions.

  http://mattsql.wordpress.com/2013/08/15/quick-tip-wmi-alerts-and-sql-server-agent-permissions/

     

• You Need Three Heads To Read This Post Properly

  http://thomaslarock.com/2013/08/need-three-heads-read-post-properly/

     

• Using DAX to create SSRS reports: The Basics

  https://www.simple-talk.com/sql/database-administration/using-dax-to-create-ssrs-reports-the-basics/

     

• SQL Server Stored Procedures and SET options

  http://www.sqlservercentral.com/articles/Stored+Procedures/101531/

     

• Database Administration as a Service

  http://www.sqlservercentral.com/redirect/articles/101602/

     

• Compare Big Data Platforms vs SQL Server

  http://www.mssqltips.com/sqlservertip/3038/compare-big-data-platforms-vs-sql-server/

     

Other

SQL

• Stored procedure debugging in SSDT and LocalDB

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/05/30/stored-procedure-debugging-in-ssdt-and-localdb.aspx

     

• SECURITY QUESTIONS: TRUNCATE TABLE PERMISSIONS

  http://www.jasonstrate.com/2013/05/security-questions-truncate-table-permissions/

• End of DBCC Command Month

  http://stevestedman.com/2013/05/end-of-dbcc-command-month/        

     

• SQL Database Corruption - What steps should I follow to prepare for database corruption?

  http://www.sqlserver-dba.com/2013/05/sql-database-corruption.html

     

• Bad DBA Job Detector Test [Video]

  http://www.brentozar.com/archive/2013/05/bad-dba-job-detector-test-video/

  DBA 여러 직무 잡에 대한 좋은 이슈들을 알려주네요^^ 영어라 압박이 ㅠㅠ        

     

• Super Fast Transactional Replication Repair        

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

• Show off your Solutions

  http://www.sqlservercentral.com/articles/SQLServerCentral/99555/

     

• Extending SQL Server DDL Triggers for more functionality: Part 1

  http://www.mssqltips.com/sqlservertip/2951/extending-sql-server-ddl-triggers-for-more-functionality-part-1/

• Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions

  http://www.mssqltips.com/sqlservertip/2964/encrypting-and-decrypting-sql-server-stored-procedures-views-and-userdefined-functions/

     

• SQL SERVER – Add Identity Column to Table Based on Order of Another Column

  http://blog.sqlauthority.com/2013/05/30/sql-server-add-identity-column-to-table-based-on-order-of-another-column/

• SQL Server Service won't start after changing service account - service-specific error %%-2146885628        

  http://sqlblog.com/blogs/greg_low/archive/2013/05/30/sql-server-service-won-t-start-after-changing-service-account-service-specific-error-2146885628.aspx

     

     

Other

• Migrate VMWare VMs to Windows Azure

  http://cloud.dzone.com/articles/migrate-vmware-vms-windows

     

• Replication in MySQL 5.6: GTIDs benefits and limitations – Part 2

  http://www.mysqlperformanceblog.com/2013/05/30/replication-in-mysql-5-6-gtids-benefits-and-limitations-part-2/

     

• [명령어] grep

  http://naleejang.tistory.com/70

SQL

• SECURITY QUESTIONS: AUTHENTICATION PERFORMANCE

  http://www.jasonstrate.com/2013/05/security-questions-authentication-performance

• Extra Bytes Per Row With AlwaysOn Availability Groups

  http://itknowledgeexchange.techtarget.com/sql-server/extra-bytes-per-row-with-alwayson-availability-groups/

     

• Troubleshooting SQL Server CPU Performance Issues

  http://www.sqlperformance.com/2013/05/io-subsystem/cpu-troubleshooting

     

• SMO vs Invoke-Sqlcmd in Azure

  http://www.scarydba.com/2013/05/28/smo-vs-invoke-sqlcmd-in-azure/

     

• Mix and Match Databases: Dealing with Data Types

  http://www.brentozar.com/archive/2013/05/mix-match-databases-dealing-data-types/

     

• SQL Server 2012 Integration Services - Using PowerShell to Configure Project Environments

  http://www.databasejournal.com/features/mssql/ssis-2012-using-powershell-to-configure-project-environments.html

     

• Increment a variable in the SET clause of an UPDATE statement [T-SQL]

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/05/28/increment-a-variable-in-the-set-clause-of-an-update-statement-t-sql.aspx

     

• Managing Slowly Changing Dimension with MERGE Statement in SQL Server

  http://www.databasejournal.com/features/mssql/managing-slowly-changing-dimension-with-merge-statement-in-sql-server.html

     

• Uploading Data to Windows Azure SQL Database

  https://www.simple-talk.com/cloud/cloud-data/uploading-data-to-windows-azure-sql-database/

     

     

Other