2013.08.30

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