The Curious Engineer

All blogs / Databases

SQL Server Customer Advisory Team

learn.microsoft.com/en-us/archive/blogs/sqlcat

DatabasesPerformance / optimizationDistributed systems / cloudMicrosoft blogsMSDN archive

’05’10’15’20’25
Posts
238 from 29 Aug 2005 to 5 Nov 2018
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqlcat/feed.xml

2018 8

  1. SQLCAT at PASS Summit 2018
  2. Real-time performance monitoring for Azure SQL Database Managed Instance
  3. Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose)
  4. DataCAT team at Data Platform Summit 2018
  5. Turbo boost data loads from Spark using SQL Spark connector
  6. CPU and Memory Allocation on Azure SQL Database Managed Instance
  7. Azure SQL DB Managed Instance - sp_readmierrorlog
  8. SQL Server VLDB in Azure: DBA Tasks Made Simple

2017 20

  1. Recent Updates to setting up SQL Server Availability Groups in Azure VM with AAD Domain Services
  2. SQLCAT @PASS Summit 2017
  3. Top Questions from New Users of Azure SQL Database
  4. Using SQL Service Broker for asynchronous external script (R / Python) execution in OLTP systems
  5. Performance implications of using multi-Statement TVFs with optional parameters
  6. Secure your on-premises network outbound connection to Azure SQL Database by locking down target IP addresses
  7. Unattended install and configuration for SQL Server 2017 on Linux
  8. Enterprise Data Pipelines using Azure PaaS Services – An Introduction
  9. Instant Log Initialization for SQL Server in Azure
  10. Common ISV application patterns using Azure SQL Data Warehouse
  11. Collecting performance data with PSSDIAG for SQL Server on Linux
  12. How the SQLCAT Customer Lab is Monitoring SQL on Linux
  13. Performance impact of memory grants on data loads into Columnstore tables
  14. Azure SQL Data Warehouse loading patterns and strategies
  15. Build a recommendation system with the support for graph data in SQL Server 2017 and Azure SQL DB
  16. SQLCAT at SQLBits 2017
  17. Backing up a VLDB to Azure Blob Storage
  18. SQL Server Availability Groups in Azure VM setup with AAD Domain Services
  19. Migration from SQL Server to Azure SQL Database Using Transactional Replication
  20. How to Check Database Availability from the Application Tier

2016 34

  1. Azure SQL DW: Moving to a different region with restore from backup option
  2. Improve query performance on memory optimized tables with Temporal using new index creation enhancement in SP1
  3. Oops Recovery with Temporal Tables
  4. How bwin is using SQL Server 2016 In-Memory OLTP to achieve unprecedented performance and scale
  5. Migrating from SQL Server to Azure SQL Database using Bacpac Files
  6. Do it right! Deploying SQL Server R Services on computers without Internet access
  7. SQLSweet16!, Episode 10: "I can eat glass …", but can I load it into a database?
  8. SQLSweet16!, Episode 9: Scripting Always Encrypted operations
  9. SQLSweet16!, Episode 8: How SQL Server 2016 Cumulative Update 2 (CU2) can improve performance of highly concurrent workloads
  10. SQLCAT at Microsoft Ignite 2016
  11. Determining Database Size in Azure SQL Database V12
  12. Using SQL Always Encrypted with Azure Web App Service
  13. Real-World Azure SQL DB: Unexpected Database Maximum Size Limit
  14. SQLSweet16!, Episode 7: Install Option for Instant File Initialization
  15. Migrating data to Azure SQL Data Warehouse in practice
  16. SQLSweet16!, Episode 6: DBCC CHECKDB with MAXDOP
  17. SQLSweet16!, Episode 5: TRUNCATE Selected Partitions
  18. Using Table Valued Parameters with Always Encrypted in SQL Server 2016 and Azure SQL Database
  19. Changes in SQL Server 2016 Checkpoint Behavior
  20. Installing SQL Server 2016 RTM? You must do this!
  21. Real World Parallel INSERT...SELECT: What else you need to know!
  22. Transaction dependency limits with memory optimized tables – Error 41839
  23. SQLSweet16!, Episode 3: Parallel INSERT … SELECT
  24. SQLSweet16!, Episode 2: Availability Groups Automatic Seeding
  25. PolyBase Setup Errors and Possible Solutions
  26. SQLSweet16!, Episode 1: Backup Compression for TDE-enabled Databases
  27. Early Customer Experiences with SQL Server R Services
  28. Should you upgrade to SQL Server 2016? Yes. Today. Now!
  29. Checkpoint process for memory-optimized tables in SQL 2016 and implications on the log
  30. SQLCAT @ SQL Nexus conference
  31. Considerations around validation errors 41305 and 41325 on memory optimized tables with foreign keys
  32. SQL Server 2016 SSIS Data Flow Buffer Auto Sizing capability benefits data loading on Clustered Columnstore tables
  33. Assigning surrogate key to dimension tables in SQL DW and APS
  34. Soften the RBAR impact with Native Compiled UDFs in SQL Server 2016

2015 9

  1. SQLCAT @PASS Summit 2015
  2. SQL 2016: Columnstore row group Merge policy and index maintenance improvements
  3. Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service
  4. SQL 2014 Clustered Columnstore index rebuild and maintenance considerations
  5. SQL Server 2016 CTP2
  6. Azure SQL Database Security Features
  7. Simplifying creation of SQL Credentials with Shared Access Signature ( SAS ) tokens on Azure Storage with Powershell
  8. Data Loading performance considerations with Clustered Columnstore indexes
  9. Large SQL Server database backup on an Azure VM and archiving

2014 6

  1. Extending AlwaysOn Availability Group to Remote Azure Datacenter (PowerShell)
  2. Windows Azure PowerShell Copy Blob Script
  3. AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments
  4. AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.
  5. AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios
  6. Scaling-out SQL Server disks and data files on Windows Azure Virtual Machines…a real-world example

2013 22

  1. Be aware of the difference in isolation levels if porting an application from Windows Azure SQL DB to SQL Server in Windows Azure Virtual Machine
  2. Automating HDInsight cluster creation with PowerShell
  3. SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns
  4. SQL Server 2014 In-Memory OLTP discussions at PASS Summit 2013
  5. Forcing NUMA Node affinity for Analysis Services Tabular databases
  6. Reporting Services Performance and Optimization
  7. SQLCAT.Com - eBook Downloads
  8. AzureCAT / SQLCAT at PASS Summit 2013
  9. Maximizing Throughput with TVP
  10. Report Server Catalog Best Practices
  11. Top 10 SQL Server Integration Services Best Practices
  12. Top 10 Best Practices for Building a Large Scale Relational Data Warehouse
  13. Diagnosing Transaction Log Performance Issues and Limits of the Log Manager
  14. When To Break Down Complex Queries
  15. SQL Server Self-Service Kit : Provisioning SQL Server as a Service
  16. SQLCAT.com consolidated index of Whitepapers
  17. The Future of SQLCAT.COM
  18. SQL Server In-Memory OLTP Internals Overview for CTP1
  19. Performance Guidance for SQL Server in Windows Azure Virtual Machines
  20. Access Azure Blob Stores from HDInsight
  21. Self-Service BI Works!
  22. Hurricane Sandy Mash-Up: Hive, SQL Server, PowerPivot & Power View

2012 6

  1. New version of Partition Management Utility supports SQL2012, ColumnStore Indexes
  2. Review a working option to setup a SQL Server 2012 BI solution using Azure’s IaaS VMs
  3. AlwaysOn Availability Groups Generate Network Traffic with No User Activity
  4. Always On Availability Group: Connection to readable secondary fails when login SIDs are different or missing
  5. Tuning Spatial Point Data Queries in SQL Server 2012
  6. Technical Reference Guides for Designing Mission-Critical Solutions using SQL Server are available

2011 21

  1. A Computed Column Defined with a User-Defined Function Might Impact Query Performance
  2. Writing New Hash Functions for SQL Server
  3. Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot
  4. SQLPASS 2011 SQLCAT Track
  5. Maximizing SQL Server Throughput with RSS Tuning
  6. “QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query
  7. SSAS Maestros August 2011 Update
  8. Unintended Consequences of Scalar-Valued User Defined Functions
  9. Why can't I attach a database to SQL Server 2008 R2?
  10. Unexpected Consequences of Multiple Result Sets
  11. SQL Server Migration Assistant (SSMA) v5.0 just released!
  12. Optimize Recursive CTE Query
  13. 32- and 64-Bit Connectivity from the Same Machine
  14. Linked Servers to SQL Azure
  15. Comparing Different Results with RCSI & Read Committed
  16. Why the obsession with random I/O within the context of SSAS?
  17. Concurrency Series: My application was running fine yesterday but why is it blocking today?
  18. Concurrency Series: Minimizing blocking between updaters
  19. Concurrency Series: Why do I get blocked when no one has locked the row(s) being queried?
  20. Concurrency Series: Why do I get blocking when I use Read Uncommitted isolation level or use NOLOCK hint?
  21. Concurrency Series: Basics of Transaction Isolation Levels

2010 19

  1. Watch out those prepared SQL statements
  2. Transaction Log size does not match the size of the data being loaded.
  3. How to tell which version of SQL Server data access driver is used by an application client
  4. Optimizing CREATE SET in Cube Calculation Scripts
  5. New Release of SQL Server Migration Assistant (SSMA) includes migration from MySQL and to SQL Azure
  6. Loading data to SQL Azure the fast way
  7. Identifying query compile/runtime parameter values using XML SHOWPLAN output.
  8. Win a signed PowerPivot Architecture Technical Diagram at TechEd NA 2010!
  9. SQL Azure Customer Best Practices
  10. Now that SQL Server 2008 R2 has RTM'ed...
  11. Resolving DTC Related Waits and Tuning Scalability of DTC
  12. Character data type conversion when using SQL Server JDBC drivers
  13. Moving the Transaction log file of the Mirror Database
  14. Using SQL Agent Job Categories to Automate SQL Agent Job Enabling with Database Mirroring
  15. How to Enable RCSI for a Database with Database Mirroring
  16. Enabling Partition Level Locking in SQL Server 2008
  17. SQL Server 2008 R2 UNICODE Compression – what happens in the background?
  18. Performance tips of using XML data in SQL Server
  19. Full Text Indexing Terabytes of Files with SQL Server and Cloud Storage

2009 21

  1. Whitepaper About Star Join Optimizations
  2. Monitoring free space in tempdb transaction log
  3. Performance Comparison between Data Type Conversion Techniques in SSIS 2008
  4. PowerPivot for SharePoint Installation Guides DRAFT
  5. Are you going to SQL PASS Nov. 3rd- Nov. 5th?
  6. Looking deeper into SQL Server using Minidumps
  7. Using HierarchyID in SQL Server
  8. Gemini - Self Service BI!
  9. Multi user SSAS writebacks may result to blocks on similar functions and new connections.
  10. Assigning surrogate keys to early arriving facts using Integration Services
  11. Proper partitioning can improve dramatically the writeback process when dealing with large data sets
  12. SQL Resources for Compliance
  13. Using ProcessingGroup Dimension property option ByTable vs. ByAttribute may error with string keys
  14. Useful links for upgrading to SQL Server 2008
  15. Remember to move DTS2000 packages when upgrading msdb from 2005 to 2008
  16. Analysis Services Partition Size
  17. SQL Server 2008’s Oracle destination fast load option may fail if certain Oracle system views are missing
  18. Using BIDS 2008 to validate Analysis Services 2005 cubes
  19. New Version of Partition Management Utility Available
  20. The Data Loading Performance Guide - Now available from MSDN
  21. Minimize downtime with DB Mirroring

2008 28

  1. Ultimate guide to upgrading to SQL Server 2008
  2. SQL Server 2008 Analysis Services Performance Guide now available
  3. Best Practices for Integrated Full Text Search (iFTS) in SQL 2008
  4. 12,000 Concurrent Siebel CRM 8.0 Users On SQL Server 2008
  5. Reporting Services Scale-Out Deployment Best Practices
  6. Reintroducing sqlcat.com
  7. Table variable vs. temp table and estimated vs. actual query plan
  8. Latest Publications: Top 10 SQL Server Integration Services Best Practices and "Money" Technical Notes Published
  9. SQL PASS 2008 Just may be the best PASS Conference yet
  10. Scaling Heavy Network Traffic with Windows
  11. Microsoft SQL Server Database Snapshots and Synonyms
  12. New Best Practices Articles Published - Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned
  13. New Best Practices Articles Published - Scaling Up Reporting Services 2008 vs. Reporting Services 2005: Lessons Learned
  14. SQL Server Scale Out
  15. What you should know if you are using Logical IOs to measure query plan quality
  16. Interesting observation with table > 1TB
  17. Backup More Than 1GB per Second Using SQL2008 Backup Compression
  18. SSIS 2008 - world record ETL performance
  19. Now is time to try SQL 2008
  20. SQLCAT Toolbox
  21. Introducing SQLCAT.com
  22. New Partition Management Tool Available on Codeplex
  23. FoxPro to SQL Server migration experience
  24. New Best Practices Whitepaper published: "Best Practices for Migrating Non-Unicode Data Types to Unicode"
  25. SQL Server 2005 Best Practices Analyzer (January 2008) -- Now Available!
  26. Querying Dimension Members In Analysis Services
  27. DB Autoshrink option may introduce high fragmentation
  28. New Best Practices Whitepaper published: "Database Mirroring and Log Shipping Working Together"

2007 21

  1. New Best Practices Articles Published - Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
  2. New Best Practices Whitepaper Published: The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode
  3. Using ByAttribute or ByTable Processing Group Property with Analysis Services 2005
  4. SSAS small/big query interaction
  5. Precision Considerations for Analysis Services Users Whitepaper now available
  6. Process only one partition so you can browse the cube
  7. Using unformatted cell values it may improve query performance
  8. Create a default measure in AS2005 cubes
  9. SQLCAT tracks at 2007 SQL PASS
  10. New Best Practices Article
  11. SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
  12. Renaming Olap Databases Issues within Analysis Services
  13. Performance Analysis Tool - DMVStats
  14. Distributed Partitioned Views / Federated Databases: Lessons Learned
  15. Inconsistencies when using Drillthrough MDX with Perspectives
  16. Four new best practices articles are available
  17. New Best Practices Articles are available (May 2007)
  18. Querying a Database Snapshot
  19. SQL Server 2005 Transactional Replication: Benefit of using SubscriptionStreams for low bandwidth, high latency environments
  20. How to warm up the Analysis Services data cache using Create Cache statement?
  21. Previously committed rows might be missed if NOLOCK hint is used

2006 11

  1. SQL Server Best Practices Website
  2. Best SQL Server 2005 MDX Tips and Tricks - Part 1
  3. OLTP Blueprint - A Performance Profile of OLTP applications
  4. Load 1TB in less than 1 hour
  5. SQL Server Sequence Number
  6. Managing Schema Changes (Part 2)
  7. 2. Application Patterns and database performance: Academically correct object modeling.
  8. Managing Schema Changes (Part 1)
  9. Partition Elimination in SQL Server 2005
  10. Application Patterns and database performance: Complex Screens
  11. How can SQL Server 2005 help me evaluate and manage indexes?

2005 12

  1. Achieving Selective Uniqueness in SQL Server Tables
  2. How can SQL Server 2005 help me evaluate and manage indexes?
  3. Partitioned Tables, Parallelism & Performance considerations
  4. SQL Server 2005 Configuration Blog #2.doc
  5. Deploying SQL Server 2005 with SAN #3
  6. How can SQL Server 2005 OnLine Piecemeal Restore improve availability?
  7. Deploying SQL Server 2005 with SAN #1
  8. Obtaining Statement-Level Query Plans
  9. Using Hashing to Obscure Sensitive Data
  10. How do you measure CPU pressure?
  11. Application Patterns causing poor performance
  12. New exciting BLOG coming from SQL Server Customer Advisory Team