2018–2019
1,311 posts
2019 1,264
December 2019
- Released: Public Preview for Management Pack for SQL Server Reporting Services and Analysis Services
- Released: SQL Server Management Pack (7.0.20.0)
- Introducing Replication and Change Data Capture (CDC) for SQL Server 2017 on Linux with CU18
- Internals of TDE Encryption scan
- Early technical preview of JDBC Driver 8.1.1 for SQL Server released
- Cumulative Update #18 for SQL Server 2017 RTM
- Cumulative Update #11 for SQL Server 2016 SP2
- Microsoft Drivers 5.7.1 Preview for PHP for SQL Server Released
November 2019
- Released: Public Preview for SQL Server Management Pack (2012-2019)
- Released: General Availability of Microsoft.Data.SqlClient 1.1
- Released: SQL Assessment API (GA)
- SQL Server 2019 Standard Edition
- Released: Microsoft.Data.SqlClient 1.1 Preview 2
- Servicing Update for SQL Server 2019 RTM (GDR)
October 2019
- Bulk Register with SQL VM Resource Provider
- SQL Server 2019 Intelligent Performance -Worker Migration
- Early technical preview of JDBC Driver 8.1.0 for SQL Server released
- Optimize OLTP Performance with SQL Server on Azure VM
- Released: Update to Microsoft OLE DB Driver 18 for SQL Server
- Cumulative Update #17 for SQL Server 2017 RTM
- Cumulative Update #10 for SQL Server 2016 SP2
- ODBC Driver 17.4.2 for SQL Server Released
- Released: Microsoft.Data.SqlClient 1.1 Preview 1
- Announcing Performance Optimized Storage Configuration for SQL Server on Azure VMs with SQL VM RP
September 2019
- Cumulative Update #9 for SQL Server 2016 SP2
- Released: SQL Assessment API (Public Preview 2)
- Released: Public Preview Azure SQL Database Managed Instance Management Pack
- Non-Root SQL Server 2019 Containers
- Microsoft Drivers 5.7.0 Preview for PHP for SQL Server Released
August 2019
- Released: General Availability of Microsoft.Data.SqlClient 1.0
- SQL Server CPU usage available in sys.dm_os_ring_buffers DMV starting SQL Server 2019 RC on Linux
- TOP 5 Benefits of Azure Dedicated Hosts for SQL Server Workloads on Azure VMs
- Behind the Scenes on OPTIMIZE_FOR_SEQUENTIAL_KEY
- Released: Third Public Preview of Microsoft.Data.SqlClient
- Using Query Store with least privileges instead of db_owner to achieve Separation of Duties
- Hotfix: JDBC Driver 7.4.1 for SQL Server Released
- Introducing Distributed transaction functionality on SQL Server 2017 on Linux starting with CU16
- Cumulative Update #16 for SQL Server 2017 RTM
- JDBC Driver 7.4 for SQL Server Released
- ODBC Driver 17.4 for SQL Server Released
July 2019
- Cumulative Update #8 for SQL Server 2016 SP2
- Introducing SQL Assessment API (Public Preview)
- Cumulative Update #4 for SQL Server 2014 SP3
- Cumulative Update #18 for SQL Server 2014 SP2
- SQL Server 2017 RTM CU15 + GDR Released
- SQL Server 2017 RTM GDR Released
- SQL Server 2016 SP2 CU7 + GDR Released
- SQL Server 2016 SP2 GDR Released
- SQL Server 2016 SP1 CU15 + GDR Released
- SQL Server 2016 SP1 GDR Released
- SQL Server 2014 SP3 CU3 + GDR Released
- SQL Server 2014 SP3 GDR Released
- SQL Server 2014 SP2 CU17 + GDR Released
- SQL Server 2014 SP2 GDR Released
- Understanding SQL Server 2008 and 2008 R2 end-of-support options
- Released: Second Public Preview of Microsoft.Data.SqlClient
- Benefit from Resource Provider registration when self-installing SQL Server on Azure Virtual Machine
- Introducing UTF-8 support for SQL Server
- Released: SSRS and SSAS 2008-2016 Management Packs (7.0.17.0)
June 2019
- Public Preview of Shortest Path on SQL Server 2019
- Early technical preview of JDBC 7.3.1 for SQL Server released
- Released: Public Preview for SSRS and SSAS 2008-2016 Management Packs (7.0.16.0)
May 2019
- Cumulative Update #15 for SQL Server 2017 RTM
- Cumulative Update #7 for SQL Server 2016 SP2
- Released: Update to Microsoft OLE DB Driver 18 for SQL Server
- Cumulative Update #15 for SQL Server 2016 SP1
- SQL Server 2017 RTM CU14 + GDR Released
- SQL Server 2017 RTM GDR Released
April 2019
- Released: Version-agnostic Management Pack for SQL Server (7.0.15.0)
- Hotfix Release: JDBC Driver 7.2.2 for SQL Server
- Cumulative Update #3 for SQL Server 2014 SP3
- Cumulative Update #17 for SQL Server 2014 SP2
- What if the Actual Execution Plan was always available for any query?
- Using xEvents to capture an Actual Execution Plan
March 2019
- Released: System Center Management Packs for SQL Server 2008-2016 (7.0.15.0)
- Welcome to the New SQL Server Blog!
- Hofix Release: Drivers 5.6.1 for PHP for SQL Server
- Security Update: Microsoft PHP Drivers 4.3.1 for SQL Server
- Early technical preview of JDBC 7.3.0 for SQL Server released
- Cumulative Update #14 for SQL Server 2017 RTM
- Cumulative Update #6 for SQL Server 2016 SP2
- Cumulative Update #14 for SQL Server 2016 SP1
- Cumulative Update #2 for SQL Server 2014 SP3
- Cumulative Update #16 for SQL Server 2014 SP2
- Announcing the JDBC Driver 7.2 RTW!
- Cumulative Update #13 for SQL Server 2016 SP1
- Cumulative Update #5 for SQL Server 2016 SP2
- Released: SSRS2017+ Management Pack with Power BI Reporting Server Support (7.0.12.0)
- Let’s talk about trace flags
- Early technical preview of JDBC 7.1.4 for SQL Server released
- Replica Failover within the Secondary Availability Group in a Distributed Availability Group
- Cumulative Update #13 for SQL Server 2017 RTM
- Cumulative Update #15 for SQL Server 2014 SP2
- Cumulative Update #1 for SQL Server 2014 SP3
- Microsoft Drivers 5.5.0 Preview for PHP for SQL Server Released!
- Early technical preview of JDBC 7.1.3 for SQL Server released
- SQL Server 2017 on Linux: Support for third-party AD providers
- Failover Detection Utility - Availability Group Failover Analysis Made Easy
- Cumulative Update #4 for SQL Server 2016 SP2
- Cumulative Update #12 for SQL Server 2016 SP1
- Released: Public Preview for SSRS 2017+ Management Pack with Power BI Reporting Server Support
- Early technical preview of JDBC 7.1.2 for SQL Server released
- SQL Server 2014 Service Pack 3 is now Available!!!
- SQL Server IaaS Extension Query Service for SQL Server on Azure VM
- String or Binary data would be truncated: replacing the infamous error 8152
- Cumulative Update #12 for SQL Server 2017 RTM
- SQL Server 2019 CTP 2.0 New Features – Columnstore support for sp_estimate_data_compression_savings
- SQL Server 2019 CTP 2.0 New Features – Introducing the Page Cracker (AKA sys.dm_db_page_info)!
- Cumulative Update #14 for SQL Server 2014 SP2
- Announcing Updates to the Modern Servicing Model for SQL Server
- Released: SSAS and SSRS 2017+ Management Packs (7.0.10.0)
- Early technical preview of JDBC 7.1.1 for SQL Server released
- Public Preview of Graph Edge Constraints on SQL Server 2019
- SQL Server 2019 Preview
- Storage Configuration Guidelines for SQL Server on Azure VM
- Microsoft Drivers 5.4.0 Preview for PHP for SQL Server Released!
- ODBC Driver 17.3 (Preview) for SQL Server Released
- Cumulative Update #11 for SQL Server 2017 RTM
- Cumulative Update #3 for SQL Server 2016 SP2
- Developer’s Choice: Hinting Query Execution model
- Cumulative Update #11 for SQL Server 2016 SP1
- Cumulative Update #11 for SQL Server 2016 SP1
- Released: Public Preview 2 for Version Agnostic SQL Server MP (2012-2017)
- SQL Server on Linux: ADAuth issues 3: Could not obtain information about Windows NT group/user ‘CONTOSO\user’
- SQL Server on Linux: ADAuth issues 2: Common AD Login Issues
- SQL Server on Linux: ADAuth issues 1: Issues with joining a VM to a domain
- Early technical preview of JDBC 7.1.0 for SQL Server released
- Installing SQL Server 2017 for Linux on Ubuntu 18.04 LTS
- Cumulative Update #10 for SQL Server 2017 RTM
- Cumulative Update #13 for SQL Server 2014 SP2
- Create linked server to readable secondary replica in Managed Instance Business Critical service tier
- Issue with security update for the Remote Code Execution vulnerability in SQL Server 2016 SP1 (GDR): August 14, 2018
- Build Intelligent Web App with Machine Learning Service
- Resolved: Issue with security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 (CU): August 14, 2018
- Issue with security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 (CU): August 14, 2018
- How to operationalize TensorFlow models in Microsoft Machine Learning Server
- Announcing the JDBC Driver 7.0 RTW!
- Dockerizing R and Python Web Services
- SQL Server Availability Groups – Enhanced Database Level Failover
- Microsoft Drivers 5.3.0 for PHP for SQL Server Released!
- Behavior Change for VSS Backups on VMs with Basic Availability Groups
- Cumulative Update #9 for SQL Server 2017 RTM
- Cumulative Update #10 for SQL Server 2016 SP1
- Cumulative Update #2 for SQL Server 2016 SP2
- ODBC Driver 17.2 for SQL Server Released
- Run R and Python Remotely in SQL Server from Jupyter Notebooks or any IDE
- Released: Public Preview for Version Agnostic SQL Server MP (2012-2017)
- Released: Update to Microsoft OLE DB Driver for SQL Server
- Predicate Pushdown and why should I care?
- Using custom types as arrays in T-SQL
- Released: Public Preview for SSAS and SSRS 2017+ Management Packs (7.0.8.0)
- Released: System Center Management Pack for SQL Server, AS, RS (7.0.7.0)
- Early technical preview of JDBC 6.5.4 for SQL Server released
- TEMPDB - Files and Trace Flags and Updates, Oh My!
- Optimizing Replication Agent profile parameters for better performance
- Cumulative Update #8 for SQL Server 2017 RTM
- Cumulative Update #12 for SQL Server 2014 SP2
- How we are fixing our installer for Microsoft R Open on Linux
- Released: Public Preview for SQL Server Management Packs Update (7.0.5.0) and SSRS Management Pack Update (7.0.6.0)
- Early technical preview of JDBC 6.5.3 for SQL Server released
- Clustered Columnstore Index: Massively Parallel Trickle Insert
- SQL Server 2016/2017: Availability group secondary replica redo model and performance
- Microsoft Drivers 5.2.1 Preview for PHP for SQL Server Released!
- Build Your Own Image Similarity Model
- Cumulative Update #1 for SQL Server 2016 SP2
- Cumulative Update #9 for SQL Server 2016 SP1
- How to operationalize Keras models in Microsoft Machine Learning Server
- Cumulative Update #7 for SQL Server 2017 RTM
- Basics of R and Python Execution in SQL Server
- Build Your Own Text Classification Model
- Getting Started with Machine Learning Services in SQL Server
- Early technical preview of JDBC 6.5.2 for SQL Server released
- Replication Enhancement – Improved Distribution Database Cleanup
- On-Prem or On the Cloud
- SQL Server 2016 Service Pack 2 (SP2) released !!!
- Replication Enhancement – Distribution Database in Availability Group
- Cumulative Update #6 for SQL Server 2017 RTM
- Released: Microsoft Azure SQL Database Management Pack (7.0.4.0)
- Released: System Center Management Packs for SQL Server 2008-2016 (7.0.4.0)
- Calling Http endpoints in T-SQL using CURL extension
- Early technical preview of JDBC 6.5.1 for SQL Server released
- Monitoring performance of natively compiled stored procedures - database-scoped configuration options
- ODBC Driver 17.1 for SQL Server Released
- Released: Microsoft OLE DB Driver for SQL Server
- Released: Microsoft OLE DB Driver for SQL Server
- Released: Microsoft OLE DB Driver for SQL Server
- Released: Microsoft OLE DB Driver for SQL Server
- Microsoft Drivers 5.2.0 for PHP for SQL Server Released!
- Cumulative Update #5 for SQL Server 2017 RTM
- Cumulative Update #11 for SQL Server 2014 SP2
- Cumulative Update #8 for SQL Server 2016 SP1
- Early technical preview of JDBC 6.5.0 for SQL Server released
- Released: Public Preview for SQL Server Management Packs Update (7.0.3.0)
- Announcing the JDBC Driver 6.4 RTW!
- Configuring Microsoft Machine Learning Server 9.3 to Operationalize Analytics using ARM Templates
- SQL Server Replication Enhancement – Dynamic Reloading of Agent Profile Parameters
- Finding which TLS version is in use for client connections
- Cumulative Update #4 for SQL Server 2017 RTM
- More Showplan enhancements – UDFs
- More Showplan enhancements – Row Goal
- ODBC Driver 17 for SQL Server Released
- New Windows container images of SQL Server 2017 on Windows Server 1709!
- Analyze Synchronous Commit Impact on High Commit Rate Workloads
- Public Preview: Azure SQL Database - Managed Instance Management Pack
- Released: System Center Management Packs for SQL Server 2008-2016 (7.0.2.0)
- JSON in SQL Server - Use cases
- Simplify REST API development for modern Single-page apps with SQL Server
- Simplify data access using de-normalized models
- Cumulative Update #10 for SQL Server 2014 SP2
- Cumulative Update #7 for SQL Server 2016 SP1
- Cumulative Update #3 for SQL Server 2017 RTM
- Database scoped optimizing for ad hoc workloads
- Injecting JSON objects into existing JSON text with JSON_MODIFY function
- Transitive closure clustering with CLR and JSON
- Storing JSON documents in SQL Database
- Cumulative Update #9 for SQL Server 2014 SP2
- Building SQL REST API back-end for Angular apps
- How to use Tableau with SQL Server Machine Learning Services with R and Python
- Getting Started with Python Web Services using Machine Learning Server
- Centennial apps/desktop bridge, SQL Server and error "The data area passed to a system call is too small."
- New in SSMS - Always On Availability Group Latency Reports
- Upgrade your SQL Server to scale before adding new hardware
- Cumulative Update #2 for SQL Server 2017 RTM
- ASP.NET Session State with SQL Server In-Memory OLTP
- How we made backups faster with SQL Server 2017
- Released: Microsoft Kerberos Configuration Manager for SQL Server 4.1
- Cumulative Update #9 for SQL Server 2016 RTM
- Cumulative Update #6 for SQL Server 2016 SP1
- Configuring Microsoft Machine Learning Server to Operationalize Analytics using ARM Templates
- Perfect statistics histogram in just few steps
- New GitHub location for AdventureWorks
- Released: SQL Server 2017+ and Replication Management Packs (7.0.0.0)
- JSON vs CLR UDT - performance comparison
- In-Memory OLTP Indexes - Part 2: Performance Troubleshooting Guide.
- Released: System Center Management Pack for SQL Server (7.0.0.0)
- JSON parsing is faster than Spatial equivalent
- JSON parsing 10x faster than XML parsing
- Making parallelism waits actionable
- New Showplan enhancements
- In-Memory OLTP Indexes - Part 1: Recommendations.
- In-Memory OLTP Updated Overview and Case Studies
- Sentiment analysis with Python in SQL Server Machine Learning Services
- Cumulative Update #1 for SQL Server 2017 RTM
- Cumulative Update #8 for SQL Server 2014 SP2
- 1 Million predictions/sec with Machine Learning Server web service
- Amazon's AWS Lambda and Alexa Skill with Microsoft Machine Learning Server Operationalization
- Host chat-bots with Microsoft Machine Learning Server Operationalization
- Released: Public Preview for SQL Server 2017+ and Replication Management Pack (RC)
- Enterprise-friendly Java client for Microsoft Machine Learning Server
- Released: Public Preview for SQL Server Management Packs Update (6.7.34.0)
- Consuming O16N Web Services from Azure Functions
- Announcing the Modern Servicing Model for SQL Server
- Backup Compression for TDE-enabled Databases: Important fixes in SQL 2016 SP1 CU4 and SQL 2016 RTM CU7
- Simplifying The Use of Azure Data Science Virtual Machine with R
- Choosing the right server memory for restore and recovery of memory-optimized databases
- Importing data with Microsoft R Server
- Encrypting Communication between Web Node and Compute Node in Linux
- OLE DB Supportability Guidelines
- Persisting statistics sampling rate
- New in SSMS: Searching in Showplan
- New in SSMS: Performance Dashboard built-in
- Using Microsoft R Server Operationalization on HDInsight
- Correlating xEvents with DMVs
- SQL Server 2016, Minimal logging and Impact of the Batchsize in bulk load operations
- Machine Learning Services in SQL Server 2017
- Using R to generate API Client from Swagger
- Demo: Identify and fix plan change regression in SQL Server 2017 RC1
- Monitoring automatic tuning actions using XEvents
- Managing Loan Credit Risk using Microsoft R Server
- Understanding Server Traffic logs and detecting Denial of Service Attacks
- Set up an auto-scale environment to operationalize your R analytics, with just ONE CLICK
- Loan Chargeoff Prediction Solution Templates are Live in Cortana Intelligence Solutions Gallery
- End to End Loan ChargeOff Prediction Built Using Azure HDInsight Spark Clusters and SQL Server 2016 R Service
- Indirect Checkpoint and tempdb – the good, the bad and the non-yielding scheduler
- Microsoft R Server 9.1 released on Azure HDInsight
- Columnstore Index: How do I find tables that can benefit from Clustered Columnstore Index
- What is plan regression in SQL Server?
- Use WITH clause in OPENJSON to improve parsing performance
- Smart Transaction log backup, monitoring and diagnostics with SQL Server 2017
- Using Certificates in R Server Operationalization for Linux
- Automatic plan correction in SQL Server 2017
- Configuring R Server to Operationalize Analytics using ARM Templates
- SQL Server 2017 Showplan enhancements
- From DeployR to R Server Operationalization
- Enterprise-grade R package management made easy in SQL Server
- rxExecBy - Productivity and scale with partitioned data
- Azure Database Migration Service now available for preview
- Using RxOdbcData with Oracle Wallet
- Performance: rxExecBy vs gapply on Spark
- rxExecBy Insights on RxSpark Compute Context
- New in SSMS: Query Performance Troubleshooting made easier!
- Using RStudio Server with Microsoft R Server Parcel for Cloudera
- Leveraging Microsoft R and in database analytics of SQL Server with R Services through Alteryx Designer
- Programmatically find SQL Server TCP ports
- Community driven Enhancements in SQL Server 2017
- "You Shall Not Regress!!!" - How SQL Server 2017 prevents plan regressions?
- How to find query plan choice regressions with SQL Server 2017 CTP2
- Stratified Splitting using rxExecBy
- SQL Server Mysteries: The Case of the Not 100% RESTORE…
- Introducing Interleaved Execution for Multi-Statement Table Valued Functions
- Introducing Batch Mode Adaptive Joins
- Microsoft ML on Spark and Hadoop
- New Features in 9.1: Microsoft R Server with sparklyr Interoperability
- What’s new in R Server 9.1 Operationalization
- SQL Server Performance Baselining Reports Unleashed for Enterprise Monitoring !!!
- FILESTREAM issues with SQL Server on Windows 10 creators update
- Sentiment Analysis with a pre-trained model
- SNAC lifecycle explained
- Microsoft R Server support for Rattle
- SQL Saturday 613: Building 1 million predictions per second with R-services and SQL Server 2016
- Running Pleasingly Parallel workloads using rxExecBy on Spark, SQL, Local and Localpar compute contexts
- Troubleshooting High HADR_SYNC_COMMIT wait type with Always On Availability Groups
- Image featurization with a pre-trained deep neural network model
- Using a pre-trained model for sentiment analysis
- Logging in Microsoft R Server Engine
- Step by Step Guide to Setup LDAPS on Windows Server
- Role Based Access Control With MRS 9.1.0
- CDC functionality may break after upgrading to the latest CU for SQL Server 2012, 2014 and 2016
- (Moved to R Server Blog) Image featurization with a pre-trained deep neural network model
- Considerations when tuning your queries with columnstore indexes on clone databases
- JDBC Download Center Pages and Repackaging
- Pre-trained AlexNet model for MicrosoftML's rxNeuralNet
- Understanding data security in cloned databases created using DBCC CLONEDATABASE
- Feature Engineering using R
- Easy way to get statistics histogram programmatically
- Running MicrosoftML in SQL Server 2016
- Columnstore Index – How to Estimate Compression Savings
- Galaxy classification with neural networks: a data science workflow
- 11 ways to deploy R Server on HDInsight Cluster
- Demonstration of capability of applying simple ML and TextMining techniques to perform prediction and draw allied characteristics
- Using R to perform FileSystem Operations on Azure Data Lake Store
- R Server and Shiny
- Getting started with GPU acceleration for MicrosoftML's rxNeuralNet
- Image Segmentation Using MicrosoftML
- mrsdeploy R package - ServiceOption data-dir
- REST Calls using PostMan for R server Operationalization
- REST Calls using PostMan for R server O16N
- Reference implementation of credit risk prediction using R
- SQL Server 2016 Developer Edition in Windows Containers
- Getting more statistics information programmatically
- Microsoft R Server VMs available in Azure China
- Classify Yelp restaurant reviews’ food origin with MicrosoftML
- Exporting large data using Microsoft R (IDE: RTVS)
- Predicting Hospital Length of Stay (LOS) using SQL Server 2016 with R Services
- Parsing 4GB JSON with SQL Server
- Remote Spark Compute Context using PuTTY on Windows
- Import and analyze IIS Log files using SQL Server
- Extreme 25x compression of JSON data using CLUSTERED COLUMNSTORE INDEXES
- Exporting tables from SQL Server in json line-delimited format using BCP.exe
- JSON data in clustered column store indexes
- Microsoft R Server - Using Hive data source in Spark compute context
- Microsoft R Server Operationalization Examples
- Upgrading a Replication Topology to SQL Server 2016
- Released: Microsoft Kerberos Configuration Manager for SQL Server v3.1
- Best practices for executing embarrassingly parallel workloads with R Server on Spark
- SQL R Services optimization for concurrent execution of sp_execute_external_script
- SQL R Services optimization for concurrent execution of sp_execute_external_script
- SQL Server Mysteries: The Case of TDE and Permanent Tempdb Encryption
- Introducing VDC_Complete for Backup and Restore applications using SQLVDI
- Unicode strings and implicit conversions
- Data Transformation in Function rxDataStep
- Columnstore Index: SQL Server 2016 – Improved DMV performance
- Predicting NYC Taxi Tips using MicrosoftML
- Change Tracking Cleanup – Part 2
- Columnstore Index Performance: SQL Server 2016 – Window Aggregates in BatchMode
- Columnstore Index Performance: SQL Server 2016 – String Predicate Pushdown
- Columnstore Index Performance: SQL Server 2016 – Aggregate Pushdown
- Columnstore Index Performance: SQL Server 2016 – No Performance Cliff
- Columnstore Index Performance: SQL Server 2016 – Multiple Aggregates
- Columnstore Index Performance: SQL Server 2016 – Multiple Aggregates
- SQL Server R Services - Why we built it
- Using MRS with Teradata: Limitations of Teradata's API and Temporary Constant Columns
- Microsoft R Server 9.0 VMs now support Ubuntu and Korea regions
- Columnstore Index Performance: Batch Mode Execution
- Columnstore Index Performance: BatchMode Execution
- SQL Server Performance Dashboard Reports unleashed for Enterprise Monitoring !!!
- Columnstore Index Performance: Rowgroup Elimination
- Columnstore Index Performance: Rowgroup Elimination
- Columnstore Index Perfomance: Column Elimination
- Columnstore Index Performance: Rowgroup Elimination
- Columnstore Index Performance: Rowgroup Elimination
- Columnstore Index Performance: Column Elimination
- A walkthrough of Loan Classification using SQL Server 2016 R Services
- Microsoft R Server 9.0.1 is Packed with Exciting New Capabilities
- Split update operation can result in higher number of replicated commands
- Data Exploration in XDF Files using ScaleR Functions
- SQL Server 2016 SP1: Know your limits
- Extended per-operator level performance stats for Query Processing
- Clustered Columnstore Index in Azure SQL Database
- Developers Choice: Query progress - anytime, anywhere
- Transaction Commit latency acceleration using Storage Class Memory in Windows Server 2016/SQL Server 2016 SP1
- Introducing Batch Mode Adaptive Memory Grant Feedback
- Developers Choice: Programmatically identify LPIM and IFI privileges in SQL Server
- Developers Choice: USE HINT query hints
- SQL Server 2016 SP1: Things you should know
- Columnstore Index: Standard and Express editions with SQL Server 2016 SP1
- Developers choice: Columnstore index in Standard and Express Edition with SQL Server 2016 (SP1)
- In-Memory OLTP in Standard and Express editions, with SQL Server 2016 SP1
- Developers Choice: CREATE OR ALTER
- Open sourcing the Microsoft JDBC Driver and Maven support
- CREATE OR ALTER - another great language enhancement in SQL Server 2016 SP1
- Pattern Matching on xdf files in Microsoft R Server
- Importing .dbf files in Microsoft R Server
- Performance Optimization When Using rxExec() to Parallelize Algorithms
- New Showplan XML properties in SSMS October Release
- Columnstore Index: Why do I need to create clustered columnstore Index on In-Memory OLTP- tables for Analytics?
- In-Memory OLTP: Is your database just in memory or actually optimized for memory?
- In-Memory OLTP: Is your database just in memory or actually optimized for memory?
- Columnstore Index: Which Columnstore Index is right for my workload?
- Columnstore Index: Which Columnstore Index is right for my workload?
- Columnstore index: Why do we refer to it as In-Memory Analytics?
- Columnstore index: Why do we refer to it as In-Memory Analytics?
- Columnstore Index: Why do I need to create clustered columnstore Index on In-Memory OLTP table for Analytics?
- In-Memory OLTP: Is your database just in memory or actually optimized for memory?
- In-Memory OLTP: Is your database just in memory or actually optimized for memory?
- Columnstore Index: Which Columnstore Index is right for my workload?
- Columnstore Index: Which Columnstore Index is right for my workload?
- Columnstore index: Why do we refer to it as In-Memory Analytics?
- Columnstore index: Why do we refer to it as In-Memory Analytics?
- Data Wrangling in XDF files using ScaleR Functions
- .Net 4.6.2. Framework client driver for Always Encrypted resulting in intermittent failures to decrypt individual rows
- Migrating SAP workloads to SQL Server just got 2.5x faster
- Integrating PolyBase with Cloudera using Active Directory Authentication
- Integrating PolyBase with Cloudera using Active Directory Authentication
- AdaptiveIndexDefrag and Maintenance Solution moved to GitHub
- Filestream RsFx Driver fails to load after installing SQL Server 2016 with CU2 on Windows Server 2016 with SecureBoot ON
- Change Tracking Cleanup–Part 1
- Something for the SQL Server Backup Vendors
- Integrating PolyBase with Cloudera using Active Directory Authentication
- Integrating PolyBase with Cloudera using Active Directory Authentication
- SQL Server 2016 Express Edition in Windows containers
- Getting Started with PHP 7 + SQL Server and Azure SQL Database on Linux (Ubuntu) with Apache
- Columnstore Index- Should I partition my columnstore Index?
- Columnstore Index: In-Memory Analytics (i.e. columnstore index) Videos from Ignite 2016
- In-Memory OLTP Videos: What it is and When/How to use it
- Loan Classification using SQL Server 2016 R Services
- SQL Server 2016 - It Just Runs Faster: Always On Availability Groups Turbocharged
- Joseph Sirosh's Keynote on 1 Million Predictions Per Second
- Understanding the requirements for SeSecurityPrivilege to SQL setup account on remote fileserver when default backup folder is set to UNC path
- SQL R Services optimization for concurrent execution of sp_execute_external_script
- SQL R Services optimization for concurrent execution of sp_execute_external_script
- DeployR log rotation to avoid large catalina.out
- MRS Capability Extension: Importing and Exporting Large In-Memory Data Frames
- Understanding Grid Nodes and Slots in DeployR
- Transactional Replication and Always On Availability Groups Support Update
- Improving Concurrency & Scalability of SQL Server workload by optimizing database containment check in SQL 2014\SQL 2016
- Operator progress changes in LQS
- Remote Blob Storage (RBS) client library setup requirements in SQL Server 2016
- Enterprise Security in DeployR 8.0.5
- Columnstore Index: Parallel load into clustered columnstore index from staging table
- Columnstore Index: Differences between Clustered/Nonclustered Columnstore Index
- Columnstore Index: Differences between Columnstore Index vs BTree index
- Memory grant related diagnostics
- Dynamic Memory Object Scaling
- New defaults for model and user databases in SQL Server 2016
- Increased Memory Size for In-Memory OLTP in SQL Server 2016
- IoT Smart Grid code sample
- Announcing availability of SQL Server 2014 Express Docker image
- Appending JSON arrays using JSON_MODIFY function
- Handling inheritance with JSON
- Encapsulate JSON parsing with inline table value functions
- In-Memory OLTP Performance Demo Available for Download
- Performance Improvements in SQL Server Dashboards Management Pack
- Query Optimizer Additions in SQL Server 2016
- Database Scoped Configuration
- Boosting Update Statistics performance with SQL 2014 & SQL 2016
- Using DB Compatibility Level 130 with Old CE in SQL Server 2016
- Increased nonclustered index key size with SQL Server 2016
- Clarifications on KB 3120595
- April updates to Plan Comparison Tool
- A Technical Case Study: High Speed IoT Data Ingestion Using In-Memory OLTP in Azure
- Generate stored procedure that imports array of JSON object in table
- Loading JSON files from Azure File Storage
- Moving data from relational to JSON columns and vice versa
- Loading line-delimited JSON files in SQL Server 2016
- SQL Server in Windows Containers
- Improving temp table and table variable performance using memory optimization
- JSON support in SQL Server - Details, tips and tricks
- Columnstore Index: A short video showcasing enhancements in SQL Server 2016
- Real-Time Operational Analytics: A short video on the value proposition in SQL Server 2016
- New DMF for retrieving input buffer in SQL Server
- SQL Server 2016: Changes in default behavior for autogrow and allocations for tempdb and user databases
- Added per-operator level performance stats for Query Processing
- Columnstore Index: How does SQL Server delivers Industry leading performance for Analytic Queries?
- Columnstore Index: Overview and Value Proposition
- What’s new with SSMS Plan Comparison Tool?
- Addressing large memory grant requests from optimized Nested Loops
- Columnstore Index Merge Policy for REORGANIZE
- Index Usage DMV behavior updated
- Columnstore Index Defragmentation using REORGANIZE Command
- Real-Time Operational Analytics: Memory-Optimized Tables and Columnstore Index
- Real-Time Operational Analytics: Compression Delay option with NCCI and the performance
- Real-Time Operational Analytics: Compression Delay Option for Nonclustered Columnstore Index (NCCI)
- Real-Time Operational Analytics: Filtered nonclustered columnstore index (NCCI)
- Real-Time Operational Analytics: DML operations and nonclustered columnstore index (NCCI) in SQL Server 2016
- Upsert JSON documents in SQL Server 2016
- SQL Server 2016 - Making DBCC CHECKDB Faster
- Several improvements to DBCC CHECKDB to make it run faster
- SQL Server 2014 is FIPS 140-2 compliant
- Real-Time Operational Analytics: Simple example using nonclustered clustered columnstore index (NCCI) in SQL Server 2016
- Real-Time Operational Analytics - Overview nonclustered columnstore index (NCCI)
- Clustered columnstore Index: Data Load Optimization - Parallel Bulk Import
- Columnstore Index: Scan and parallelism
- SQL Server Remote Blob Storage (RBS) Credential Store Symmetric Key Rotation
- TLS 1.2 Support for SQL Server 2008, 2008 R2, 2012 and 2014
- JSON parsing - performance comparison
- Returning spatial data in GeoJSON format - Part 2
- Clustered Columnstore Index: Data Load Optimizations - Minimal Logging
- Best Practices for Moving Data Encrypted with Always Encrypted
- Best Practices for Moving Data Encrypted with Always Encrypted
- Windows Enforcement of Authenticode Code Signing and Timestamping impact on SQL Server
- Loading GeoJSON data into SQL Server
- Returning spatial data in GeoJSON format - Part 1
- Indexing data in JSON product catalogs
- Designing Product Catalogs in SQL Server using JSON
- WITHOUT_ARRAY_WRAPPER - New important change in FOR JSON
- Using SQL Server Integration Services (SSIS) with Always Encrypted
- SQLIO Disk Subsystem Benchmark Tool is being retired
- Columnstore Index: Real-Time Operational Analytics using In-Memory Technology
- CHECKSUM and BINARY_CHECKSUM might not return unique values for different inputs
- Create relational view over JSON text
- Columnstore Index: Speeding up analytics in SQL Server 2016
- Built-in functions for compression/decompression in SQL Server 2016
- Using non-relational models in SQL Server
- De-normalize database schema using JSON
- Query JSON data
- Log analysis with SQL Server
- Storing JSON in SQL Server
- Using Hardware Security Modules with Always Encrypted
- FOR JSON performance - simple experiment
- Indexing JSON arrays using full-text search indexes
- Tutorial: Row-Level Security and Entity Framework
- Generate serie of numbers in SQL Server 2016 using OPENJSON
- DROP IF EXISTS - new thing in SQL Server 2016
- OPENJSON - one of best ways to select rows by list of ids
- SQL Server 2016 – Added information on TempDB Spill events – xEvents
- SSMS Encryption Wizard - Enabling Always Encrypted in a Few Easy Steps
- Oil & Gas Security Demo with SQL Server 2016
- New Enhancements in Always Encrypted
- SQL Server 2016 – Added information on TempDB Spill events – Showplan
- @@VERSION and SERVERPROPERTY – What changed?
- Dynamic Data Masking–highlighting the latest improvements
- How we moved from on-premise to Azure Virtual Machine
- Comparison Tool released with latest SSMS
- Multi-fold increase in throughput for big gateway query compiles in SQL Server
- Returning child rows formatted as JSON in SQL Server queries
- Importing JSON files into SQL Server using OPENROWSET (BULK)
- Querying JSON documents in Sql Server 2016 and DocumentDB
- Cardinality Estimation for Correlated Columns in SQL Server 2016
- Parsing GeoJSON format in Sql Server 2016
- Indexing JSON documents in Sql Server 2016
- New extended events for database recovery progress
- New extended event to track backup and restore progress
- OPENJSON - The easiest way to import JSON text into table
- Loading non-relational data formatted as JSON text
- Clustered Columnstore Index: Enforcing uniqueness constraint in table
- Passing arrays to T-SQL procedures as JSON
- Let's chat about SQL Server cloud hosting
- Combining relational and NoSQL concepts in SQL Server
- Using Always Encrypted with Entity Framework 6
- Always Encrypted Key rotation – Column master Key rotation.
- Yes, You Really Can
- Encryption options in RESTORE HEADERONLY
- Eliciting your feedback about upgrading SQL Server
- Ninja Troubleshooting- User Interface freezing during SQL Server database restore.
- Encrypting Existing Data with Always Encrypted
- Optimizing RLS performance with the Query Store
- Always Encrypted Key Metadata
- Building elastic and fault tolerant Data Platform solutions with Azure, SQL Server and HDInsight
- Developing Web Apps using Always Encrypted
- FOR JSON clause in SQL Server 2016 CTP2
- Getting Started With Always Encrypted
- Azure SQL Database and SQL Server programming with Node.js: Stored procedures, Transactions, and UDFs
- Azure SQL Database and SQL Server programming with PHP: Stored procedures, Transactions, and UDFs
- Apply Row-Level Security automatically to newly created tables
- Nonclustered Columnstore Index on Base Table Partitioned by Computed Column
- Using CLR to replace xp_cmdshell for specific tasks
- Secondary Replica may go into suspended state if you alter the readability property of the Availability Group and page compression is enabled
- Getting Started with Node.js on Microsoft SQL Server and Azure SQL Database
- Getting Started with PHP 5.6 and Microsoft SQL Server and Azure SQL Database
- Row-Level Security: Performance and common patterns
- Apply Row-Level Security to all tables -- helper script
- Row-Level Security: Blocking unauthorized INSERTs
- Row-Level Security for Middle-Tier Apps – Using Disjunctions in the Predicate
- Best practices for maximum performance and scalability gains for SQL Server workloads
- When do conversions generate conversion warnings? And why are these bad?
- SQL Swiss Army Knife #15 - Handling duplicate indexes
- Have you heard of the EPM Framework?
- MDS 2012/2014: Where my soft deletes at?
- SQL Application Column Encryption Sample (Codeplex) available
- Too many single use plans, now what?
- Clustered Column Store Index: Bulk Loading the Data
- Clustered Column Store Index: Concurrency with INSERT Operations
- Clustered Column Store Index: Concurrency and Isolation Levels
- Beam me up, Azure!
- Clustered Column Store: Factors that impact size of a RowGroup
- SQL Swiss Army Knife #14 - Troubleshooting with Waits and Latches
- SQL Swiss Army Knife #13 – Exploring the plan cache – Part 2
- AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments
- AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.
- AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios
- Published: Troubleshooting Guide for Availability Group Listener in Windows Azure
- Using DQS with SQL Server AlwaysOn AG
- More Windows Azure E2E Scripts!
- Availability Group Listener in Hybrid IT: End-to-End PowerShell Script Published
- Master Data Services Operations Guide released
- Programmatically find MS Shipped Databases
- PVKConverter
- SQL Server Transparent Database Encryption (TDE)
- Availability Group Listener in Windows Azure Now Supported! (And Scripts for Cloud-Only Configuration)
- SQL Swiss Army Knife #13 – Exploring the plan cache – Part 1
- AlwaysOn Availability Groups Troubleshooting and Monitoring Guide published!
- Upgrade and Update Guide for AlwaysOn Availability Groups published!
- PAGELATCH_EX waits and heavy inserts
- Microsoft BI Authentication and Identity Delegation white paper
- SQL Swiss Army Knife Series is indexed
- Connecting to Availability Group Listener in Hybrid IT
- The Kerberos, SharePoint, Reporting Services and Internet Explorer case
- Introducing the new Microsoft ODBC Drivers for SQL Server
- Test Lab: Create an AlwaysOn Availability Group in Windows Azure End-to-End
- HADR Tutorials for SQL Server in Windows Azure VMs
- Table variables and row estimations - Part 2
- WSFC Cluster Configuration on Windows Azure Virtual Machines
- Table variables and row estimations – Part 1
- How To: Migrate to AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 2
- How To: Migrate to AlwaysOn AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 1
- Hiding SQL Server from External Crackers
- Filter SQL Server Audit on action_id / class_type predicate
- How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 3
- How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 2
- How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 1
- About Maintenance Plans – grooming SQL Server
- SQL Swiss Army Knife #11.1 - Locking, blocking and active transactions
- Take most of Reporting Services Logs with Excel 2013
- Managed Service Accounts
- Migration Guide: Migrating to AlwaysOn Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping
- Alert On Low Disk Space, Including Mount Points
- Enabling SSL on SQL Server Connections on Failover Clusters
- AlwaysOn Architecture Guides
- SQL Server Ports
- Quickly Setup SQL Server AlwaysOn Failover Cluster Instance (FCI) in Hyper-V
- Configure Windows Failover Clustering for SQL Server (Availability Group or FCI) with Limited Security
- A practical example on missing a filtered index
- Note to self on AlwaysOn...
- SQL Swiss Army Knife #12 - Index information galore!
- Installing SQL Server in a High-Security Domain, Part II
- How Would You Use Table Valued Parameters (TVP)?
- Concurrent ADD NODE operation yields unexpected results in a SQL Server Failover Cluster Instance
- DO NOT use Windows Failover Cluster Manager to perform Availability Group Failover
- SQL Server 2012 new high VLFs warning: Important update
- Quorum vote configuration check in AlwaysOn Availability Group Wizards (Andy Jing)
- The SQL Swiss Army Knife #3 - View I/O per file - Updated
- Security Best Practice and Label Security Whitepapers
- Install the latest AlwaysOn features for ADO.NET(Matt Neerincx)
- Dealing With an Unjoined Database On a Primary Replica
- SAG Awards Drupal Website Moves to Windows Azure
- Does the DoD STIG require Transparent Database Encryption (TDE)?
- A case of seeks and scans
- Supporting SQL Server 2012 AlwaysOn® in .NET Framework 4 (by Luiz Fernando Santos)
- Monitoring AlwaysOn Health with PowerShell - Part 4 : Integration with SQL Server Agent
- Monitoring AlwaysOn Health with PowerShell - Part 3 : A Simple Monitoring Application
- Monitoring AlwaysOn Health with PowerShell - Part 1: Basic Cmdlet Overview
- Monitoring AlwaysOn Health with PowerShell - Part 2: Advanced Cmdlet Usage
- The AlwaysOn Health Model Part 2 -- Extending the Health Model
- The AlwaysOn Health Model Part 1 -- Health Model Architecture
- How to create multiple listeners for same availability group (Goden Yao)
- Configuring AlwaysOn with SQL Server PowerShell
- SQLAzure – “SQL Azure Compatibility Assessment” and “SQL Azure Security Services” Services
- SQL Server 2012 – AlwaysOn (HA/DR)
- Add a Log Shipping Primary Database and Secondary Database(s) to an Existing Availability Group
- Joomla! 2.5 Adds SQL Server Support!
- NOW AVAILABLE: Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
- PowerPivot Security Architecture
- AlwaysOn: Comparing Readable Secondary with the similar functionality available in DB2
- Introduction to the Availability Group Listener
- T-SQL Misconceptions - JOIN ON vs. WHERE
- Three effective tips for Reporting Services management
- Using SQL Azure and the Microsoft JDBC Driver?
- Who is using AlwaysOn
- Converting a logshipping configuration to Availability Group
- Prepare SQL Server for using AlwaysOn feature
- SQL Server Accounts
- SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns
- AlwaysOn: Value Proposition of Readable Secondary
- AlwaysOn: Value Proposition of Readable Secondary
- AlwaysOn: I just enabled Readable Secondary but my query is blocked?
- AlwaysOn: Making latest statistics available on Readable Secondary, Read-Only database and Database Snapshot
- AlwaysOn: Challenges with statistics on ReadOnly database, Database Snapshot and Secondary Replica
- AlwaysOn: Impact of mapping reporting workload on Readable Secondary to Snapshot Isolation
- AlwaysOn: Minimizing blocking of REDO thread when running reporting workload on Secondary Replica
- AlwaysOn: Impact on the primary workload when you run reporting workload on the secondary replica
- AlwaysOn: Readable Secondary and data latency
- AlwaysOn: Why there are two options to enable a secondary replica for read workload?
- AlwaysOn: Setting up Readable Seconary Replica
- AlwaysOn: Value Proposition of Readable Secondary
- AlwaysOn: Value Proposition of Readable Secondary
- Get Rid of Deadlocks
- The Database STIG's System Security Plan
- Securing SQL Server Integration Services (SSIS)
- Can PerformancePoint have interactive features?
- How to configure cascading filters in Dashboard Designer (SharePoint 2010 SP1)
- Using SQL Azure to Store PHP Session Data
- SQL Databases on File Shares - It's time to reconsider the scenario.
- The “rumor” is true: SQL Server 2012 has a new high VLFs warning (Edited).
- Announcing Microsoft SQL Server ODBC Driver for Linux
- SQL Server and PowerShell Security
- Auto Update Statistics Asynch - Are you really, really using it?
- TVP or Bulk Copy?
- Separation of Duties for DBA's
- Checking Your SQL Azure Server Connection
- Checking Your SQL Azure Server Connection
- Microsoft is Aligning with ODBC for Native Relational Data Access
- Checking Your SQL Azure Server Connection
- Checking Your SQL Azure Server Connection
- Data Hashing in SQL Server
- Database Engine Permission Basics
- SQL Server, the DoD, and Common Criteria
- SQL Swiss Army Knife #10 - VLFs again. What’s your current status?
- Conditionally Updating Statistics
- SQL Server 2008 PCI DSS v.2.0 Whitepaper
- MOSS, BizTalk, SCOM and SQL Server Collations
- Adaptive Index Defrag
- How to integrate SSRS Reports with PerformancePoint Dashboards in SharePoint 2010
- The “Balanced Data Distributor” for SSIS
- SQL Connectivity UserVoice Site is Live!
- SQL Swiss Army Knife #9 - Fixing VLFs
- Fundamentals: DBCC - SQL Server's FDISK
- Test SharePoint Mirror Without Down-Time
- Backups: Doing it right so you can recover quickly!– Automating the backups
- Data Compression and Fill Factor
- Backups: Doing it right so you can recover quickly!– Don’t keep your eggs in one basket
- Backups: Doing it right so you can recover quickly! - Checking backups have occurred.
- Can log files growth affect DML? Post-CU Update
- Fundamentals: Cloning a production database to a test server
- Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes
- Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes
- Tuning ISV SQL Server databases - Overview
- Integrity checks with EncryptByKey
- Changing Domains on a SQL Server
- Adding enhanced password constraints to SQL Server
- SQL Swiss Army Knife #8 - Find a Maintenance Window
- SQL Swiss Army Knife #7 - Adaptive Index Defrag
- Do You Need MSDTC?
- Best Practices Analyzer for ISV SQL Servers to protect your company’s property
- Migrating from Oracle to SQL Server
- Don’t let documents and mixed media complicate your product!
- Improving SQL Server Security to PCIDSS Standards
- Right sizing ISV installations for the best bang for the buck!
- Prevent Tampering of Encrypting Data Using add_authenticator Argument of EncryptByKey
- Concurrency Series: My application was running fine yesterday but why is it blocking today?
- Concurrency Series: Minimizing blocking between updaters
- Concurrency Series: Why do I get blocked when no one has locked the row(s) being queried?
- Concurrency Series: Why do I get blocking when I use Read Uncommitted isolation level or use NOLOCK hint?
- Concurrency Series: Basics of Transaction Isolation Levels
- Loose notes on FILESTREAM…
- Best Practices on FILESTREAM implementations
- Revisiting the RC4 / RC4_128 Cipher
- The Easiest Way To Rebuild The master Database
- How Important Is Your Data? (Mini-Lab Part 2/2)
- How Important Is Your Data? (Mini-Lab Part 1/2)
- Tips for using DB user with password
- How To STIG a Database System
- Benchmarking Series "The Benchmarking Process" (5/5)
- Benchmarking Series "Benchmark Sizing Guide" (4/5)
- Benchmarking Series "The Applicability/Usage of a Benchmark" (3/5)
- Benchmarking Series "The Elements of a Benchmark" (2/5)
- Benchmarking Series "The Need For Benchmarking" (1/5)
- The SQL Swiss Army Knife #6 - Evaluating compression gains
- Benchmarking Series "Introduction" (0/5)
- Use CPU Instance Counters for Better Insight
- Using Read-Committed Snapshot Isolation - Mini-Lab
- Mini-Lab - Part 2 - Backup Compression with Resource Governor
- Mini-Lab - Part 1 - Backup Compression
- Contained Database Authentication in depth
- Contained Database Authentication: How to control which databases are allowed to authenticate users using logon triggers
- Summary of Audit-Specific STIG ID's
- Contained Database Authentication: Monitoring and controlling contained users
- PROS: Oracle to SQL Case Study
- Contained Database Authentication: Introduction
- Change Data Capture - What is it and how do I use it?
- All Good Things Come to an End - Why You Should Upgrade
- Troubleshooting SQL Azure applications with SQL Server Native Client
- Temenos T24 - Trace Flag 834 and When to Use It
- The SQL Swiss Army Knife #5 - Checking Autogrow times
- SQL Server Drive Configurations
- Data Compression for SQL Server 2008
- Instant File Initialization - Oh you didn't know?
- File-Sizing
- TempDB - True, False, and It Depends
- The SQL Swiss Army Knife #4 - Making sense of FILESTREAM containers
- DBA 101: Choosing a Database Recovery Model (Siemens Teamcenter)
- Can log files growth affect DML?
- How To: Clean up old database backup history
- Testing Hot Fixes, Cumulative Updates and Service Packs
- Index Fragmentation–“If it isn’t broken, don’t fix it”
- Why Pay More For Less
- Buying a Vehicle vs. Buying a Database Platform
- Policy-Based Management and Best Practices for Running Siemens Teamcenter
- Backing Up All SQL Server Databases Using PowerShell
- Primary DBA Responsibilities
- Guest account in User Databases
- DG0155: Trusted file check
- SharePoint/SQL Server Hierarchy
- rand vs. crypt_gen_random
- Defragmenting Indexes
- Security Checklists on TechNet Wiki
- External Activator Security
- DEK and the Log
- Connection Error After Removing Public Permissions
- Agent Schedules
- SQL Swiss Army Knife #2.1 - Scripting Logins - Updated
- Database Encryption Key (DEK) management
- TDE, DEK and the LOG
- Concurrency Series: Common Concurrency Issues with Applications
- Minimal logging and MERGE statement
- SQL Server and Log File usage
- SQL Server Runaway Transaction Logs
- SQL Server Connectivity has a new portal page!
- New SQL Connectivity Portal!!!
- Enabling Transparent Data Encryption (TDE)
- SQL Server is now supported by phpBB!
- Blocking automated SQL injection attacks
- The SQL Swiss Army Knife #1 - Scripting Securables - Updated
- SQL Server Driver for PHP 2.0 CTP adds PHP's PDO style data access for SQL Server
- Using Time and Date Data Types - Part 1 (It's about time)
- SQL Server "Login Failure" troubleshooter
- SQL Server Authentication Troubleshooter
- The Myth of Unstructured Data
- Public Not Granted Server Permissions
- Import the Default PBM Policies
- Presentation on SQL Security
- Mystery of memory fraction in Showplan XML
- Sample activated application
- HIPAA Compliance with SQL Server 2008
- Backup compression and Virtual Device Interface (VDI)
- DG0116 and DG0121: DBA Privileges Via Roles
- Understanding SQL server memory grant
- Remove Public and Guest Permissions
- Performance improvement by orders of magnitude when merging partitions in SQL Server 2008R2
- Quick security references (QSR) on Cross-Site scripting and SQL injection.
- Permissions for SQL Server Agent Proxy for SSIS Maintenance Plans
- SharePoint User Connections
- More on Implicit Conversions
- Hyper-Cluster
- Improvement in minimizing lockhash key collisions in SQL Server 2008R2 and its impact on concurrency
- SQL Server Index Key Performance Indicators
- Installing SQL Server 2008 Services in a High-Security Domain
- Documenting Full-Text Indexes
- Consolidation Guidance for SQL Server
- SQL Server vs. Oracle Security Vulnerabilities
- Information about the SNAC package and Cumulative Updates
- Custom Auditing
- Making STIG Compliance Much Easier, Part II
- Selectively using secure connection to SQL Server
- Mission Assurance Category
- Making STIG Compliance Much Easier
- Changing the Domain of SQL Server
- What's a STIG?
- How To: Share a Single EKM Credential among Multiple Users
- Connection from a Windows Service could be blocked by firewall even if firewall is disabled
- A Unicode Compression example
- Unicode Compression in SQL Server 2008R2
- Customer feedback on Data Compression
- Update on data compression performance/space-savings and links to published white papers
- Using SSIS to get data out of Oracle: A big surprise!
- Understanding SQL Server Fast_Forward Server Cursors
- Correction to my prior post on sys.dm_db_index_operational_stats
- SQL Server 2005/2008 – How to know which are the latest builds available?
- Interesting issue with Filtered indexes.
- Maximum Row Size and Query Hints
- Filtering (obfuscating) Sensitive Text in SQL Server
- Get Started With Using External Activator
- Why did the size of my indexes expand when I rebuilt my indexes?
- How To Choose Audit Action Group When Using Auditing in SQL Server 2008
- SQL Server Native Client: Connection strings and OLE DB
- Spatial Types Platform
- Implied Predicates and Query Hints
- Thales/nCipher announces EKM support for SQL Server 2008
- PCI DSS Compliance with SQL Server 2008
- SQL Server 2005 / 2008 table partitioning : Important things to consider when switching-out partitions.
- SQL Server EncryptByKey cryptographic message description
- Avoid using JDK Date APIs to handle timezone sensitive date and time
- Enforce Windows Password Policy on SQL Server Logins
- Paging Data with the SQL Server Driver for PHP
- OPTIMIZED Nested Loops Joins
- Interested in Compliance?
- Understanding the error “An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.”
- Optimizing I/O Performance by Sorting – Part 2
- An ETL World Record Revealed (Finally)
- SQL Server Tools - Extended Events Manager & Partition Management
- Optimizing I/O Performance by Sorting – Part 1
- The server failed to resume the transaction... Why?
- Performance of Impact of Auditing in SQL Server 2008
- Zeroing in on blocking on seemingly unrelated tables
- Using SQL Server 2008 Management Data Warehouse for database monitoring in my application
- About DEK rotation and log backup in Transparent Database Encryption (TDE)
- SQL Best Practices for Biztalk
- TempDB Monitoring and Troubleshooting: Out of Space
- TempDB Monitoring and Troubleshooting: DDL Bottleneck
- TempDB Monitoring and Troubleshooting: Allocation Bottleneck
- TempDB Monitoring and Troubleshooting: IO Bottleneck
- Managing TempDB in SQL Server: TempDB Configuration
- What is allocation bottleneck?
- Managing TempDB in SQL Server: TempDB Basics (Version Store: Growth and removing stale row versions)
- Managing TempDB in SQL Server: TempDB Basics (Version Store: logical structure)
- Managing TempDB in SQL Server: TempDB Basics (Version Store: Simple Example)
- Managing TempDB in SQL Server: TempDB Basics (Version Store: Why do we need it?)
- Managing TempDB in SQL Server:TempDB Basics (cont..)
- Managing TempDB in SQL Server
- DML operations on a HEAP and compression
- Enabling compression on a HEAP
- Configuring SQL Audit using the Audit Dynamic Management Views
- Caregroup CIO Blogs about using Auditing
- Service Broker Wait Types
- OPTIMIZE FOR UNKNOWN – a little known SQL Server 2008 feature
- Announcing Service Broker External Activator
- SQL Server is Movin' On Up!
- How to script all my database objects? Here is the answer.
- CPU Drift and SQL Server timing values
- SQL Server - Performance Counters, Thresholds, etc.
- SQL Server & Disk Partition Alignment
- TCP listening ports and ENDPOINT ports behavior
- SQL Server 2008 : new binary – hex string conversion functionality can dramatically improve related query performance by orders of magnitude.
- What is the difference between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats?
- TPC-E – Raising the Bar in OLTP Performance
- SQL Audit Buffering and Error Handling
- Random Prefetching
- Working with SQL Server 2008 Filestream using v1.2 JDBC driver
- How and Why to Use Parameterized Queries
- Working with SQL Server 2008 Date/Time Data Types using v1.2 JDBC driver
- Sequential Read Ahead
- Distinct Aggregation Considered Harmful
- Understanding “Data Source=(local)” in SQL Server Connection Strings
- The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.
- New SQL Server Driver for PHP Whitepaper Available
- Unicode Support and Endianness
- Configuring SQL Protocols through Windows PowerShell
- Securing a dialog with certificates
- Dynamic Partition Elimination Performance
- How to create an autonomous transaction in SQL Server 2008
- Fast data push tuning
- Accessing the calling context in modules that use EXECUTE AS
- Does data compression lead to more fragmentation?
- Partitioned Indexes in SQL Server 2008
- Why doesn't executeUpdate() give me the exception I expected?
- SQLServerException: The statement did not return a result set
- Accessing SQL Server from open source software
- Use execute() and getMoreResults() methods for those pesky complex SQL queries
- Microsoft Connect
- Reusing dialogs with a dialog pool
- Connection failure because of mismatched TDS version
- Partitioned Tables in SQL Server 2008
- Using multiple routes in Service Broker
- UPDATE with OUTPUT clause – Triggers – and SQLMoreResults
- Real Time Data Integration with Service Broker and Other SQL Techniques
- Tips for improving application robustness and minimizing upgrade upheaval
- Poison Message Handling
- Subqueries in BETWEEN and CASE Statements
- Getting started with Microsoft ® Source Code Analyzer for SQL Injection
- Service Broker Periodic Tasks
- Use SQL Server replay tools to reproduce and resolve customer issues
- Troubleshooting SQL Server Cluster Installations
- java.lang.SecurityException: class "com.microsoft.sqlserver.jdbc.SQLServerConnection"'s signer information does not match signer information of other classes in the same package
- A simple secure dialog with transport certificates
- Implicit Conversions
- SQL Server Intermittent Connectivity Issue
- ADO: Deriving parameter information for user-defined, table-valued functions
- Connectivity troubleshooting in SQL Server 2008 with the Connectivity Ring Buffer
- Query Processing Presentation
- Understanding the error message: “Login failed for user ''. The user is not associated with a trusted SQL Server connection.”
- Steps to troubleshoot SQL connectivity issues
- Conversion and Arithmetic Errors
- Could not connect to X64 named instance
- Understanding “Connection forcibly closed by remote host” Errors Caused by TOE/Chimney
- Service Principal Name (SPN)
- Frequently Asked Questions for SQL Server JDBC Driver
- Ranking Functions: RANK, DENSE_RANK, and NTILE
- TempDB:: Table variable vs local temporary table
- Overhead of Row Versioning
- CHECKSUM and Tempdb
- Minimal Logging changes in SQL Server 2008 (part-3)
- Minimal Logging changes in SQL Server 2008 (part-2)
- Ranking Functions: ROW_NUMBER
- Using time zone data in SQL Server 2008
- Increase your SQL Server performance by replacing cursors with set operations
- Appending Data Using SQL 2008 Filestream
- Minimal Logging changes in SQL Server 2008
- Functions to return row count and field count
- SQL Server 2005 Encryption – Encryption and data length limitations (feedback page)
- Example: Index fragmentation with insert/updates, measuring it and fixing it
- Halloween Protection
- ETL World Record!
- Bulk Import Optimizations (Minimal Logging)
- What are the Bulk Import Optimizations?
- Why Bulk Import?
- Maintaining Unique Indexes with IGNORE_DUP_KEY
- Compression Strategies
- Sending BLOB Data to SQL SERVER Using IROWSETFASTLOAD and ISEQUENTIALSTREAM
- Details on page compression (page-dictionary)
- Partial Aggregation
- Details on PAGE compression (column-prefix)
- xp_cmdshell
- The TRUSTWORHY bit database property in SQL Server 2005
- OPEN SYMMETRIC KEY scope in SQL Server
- Estimating the space savings with data compression
- Types of data compression in SQL Server 2008
- Why not use compressed disk files or disk volumes?
- Recursive CTEs continued ...
- When is too much success a bad thing?
- Fuzzy backups and RESTORE DATABASE WITH STOPAT
- Recursive CTEs
- CTEs (Common Table Expressions)
- Transparency in the Design Process
- GROUPING SETS in SQL Server 2008
- Data compression techniques and trade offs
- Data Compression: Why Do we need it?
- Aggregation WITH CUBE
- Aggregation WITH ROLLUP
- Maintaining Unique Indexes
- Spool operators in query plan...
- Optimized Non-clustered Index Maintenance in Per-Index Plans
- Optimized Non-clustered Index Maintenance
- More on TOP
- Splits and unions...
- ROWCOUNT Top
- TCP Provider: No connection could be made because the target machine actively refused it
- The UNPIVOT Operator
- Link to MSDN forum discussion: "Yet another question on Application security.... "
- Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005
- PIVOT Query Plans
- The PIVOT Operator
- Login failed for user <xx>, Msg 18456, Level 14, State 1
- SSL Cipher Suites used with SQL Server
- Detecting Overlapping Indexes in SQL Server 2005
- Install a self-signed test certificate that can be loaded by SQL Server automatically
- com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
- java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
- Query Failure with Read Uncommitted
- Read Committed and Bookmark Lookup
- What happens to non-clustered indexes when the table structure is changed?
- New SQL Best Practice Articles now available
- SQL Server's 'black-box' flight recorder
- The Ins and Outs of Offline Files
- Read Committed and Large Objects
- Read Committed and Updates
- What's swimming in your bufferpool?
- Serializable vs. Snapshot Isolation Level
- Named Pipes Provider, error: 40 - Could not open a connection to SQL Server (Microsoft SQL Server, Error: XXX)
- Index Build strategy in SQL Server - Part 4-2: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)
- SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
- Adjust buffer size in SSIS data flow task
- Implement Parallel Execution in SSIS
- Dynamic SQL and digital signatures in SQL Server 2005
- After a long delay, I am ready to start posting again
- Repeatable Read Isolation Level
- Index Build strategy in SQL Server - Part 4-1: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)
- Query Plans and Read Committed Isolation Level
- What is adaptive response buffering and why should I use it?
- Something about SSIS Performance Counters
- Set BLOBTempStoragePath and BufferTempStoragePath to Fast Drives
- Quick list of VLDB maintenance best practices
- Set up OLE DB source to read from View efficiently
- What's the difference between database version and database compatibility level?
- Read Committed Isolation Level
- Getting Optimal Performance with Integration Services Lookups
- How having too many filegroups can affect recovery time
- Can you mix-n-match backup devices?
- How can you tell if an index is being used?
- Parallel Query Execution Presentation
- Example corrupt database to play with and some backup/restore things to try
- What’s so temporary about tempdb?
- VLDB Maintenance - quick addendum
- Microbenchmarking
- How to Check Whether the Final Query Plan is Optimized for Star Join Queries?
- VLDB Maintenance Practices and Problems?
- Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
- How does your schema affect your shrink run-time?
- Turn AUTO_SHRINK off!!
- Two handy papers on common database performance considerations
- Easy way to create a corrupt database for testing
- How to create fake statistics for testing query plans
- Oh no – my backup is corrupt too! Help!
- Using Visual Studio’s Code Model objects for code base understanding
- Building a WebMethod FORMAT=NONE Stored Procedure
- why cannot i GRANT EXECUTE permission on assemblies anymore ?
- High Volume Update Performance
- How to move databases using detach/attach functions?
- How long does *your* CHECKDB take?
- CHECKDB (Part 8): Can repair fix everything?
- TDSSNIClient initialization failed with error 0x50, status code 0x50
- CHECKDB (Part 7): How long will CHECKDB take to run?
- 4.0 Useful Queries on DMV’s to understand Plan Cache Behavior
- 2.0 Diagnosing Plan Cache Related Performance Problems and Suggested Solutions
- Index Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning (Aligned partitioned parallel index build)
- 12.0 Plan Cache Trace Events and Performance Counters
- 11.0 Temporary Tables, Table Variables and Recompiles
- Fixing damaged pages using page restore or manual inserts
- 10.0 Plan Cache Flush
- Index Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning
- 9.0 Memory Pressure Limits
- 8.0 Factors that Affect Batch Cache-ability
- 7.0 Costing Cache Entries
- 6.0 Best Programming Practices
- 5.0 Retrieving Query Plans from Plan Cache DMV’s
- 4.0 Query Parameterization
- 3.0 How Cache Lookups Work
- 2.0 Sql_Handle and Plan_Handle Explained
- 1.0 Structure of the Plan Cache and Types of Cached Objects
- Plan Cache Concepts Explained
- Read-Only filegroups and Locking
- Connection Alias
- Case-insensitive Search Operations
- Dynamic SQL & SQL injection
- Let's talk about Dynamic SQL (preamble)
- "Cannot Generate SSPI Context" error message, Poisoned DNS
- Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning (Non stats plan (no histogram))
- Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning
- Semi-join Transformation
- Understanding Kerberos and NTLM authentication in SQL Server Connections
- Knowing about 'Forwarded Records' can help diagnose hard to find performance issues.
- Introduction to Partitioned Tables
- Query Execution Timeouts in SQL Server (Part 2 of 2)
- Index Build strategy in SQL Server - Part 1: offline, serial, no partitioning
- Parallel Hash Join
- Query Execution Timeouts in SQL Server (Part 1 of 2)
- Index Build strategy in SQL Server - Introduction (II)
- Parallel Nested Loops Join
- When can allocation order scans be used?
- Index Build strategy in SQL Server - Introduction (I)
- Building T-SQL Custom WSDL generator
- Parallel Scan
- Using a digital signature as a secondary identity to replace Cross database ownership chaining
- Intro to Query Execution Bitmap Filters
- The Parallelism Operator (aka Exchange)
- CHECKDB (Part 6): Consistency checking options for a VLDB
- Index Union
- Resolving Login Errors with Duplicated Databases
- What's this cost?
- Introduction to Parallel Query Execution
- Introduction to Parallel Query Execution
- Viewing and Interpreting XML Showplans
- Decorrelating Subqueries
- Introduction to Showplan
- Skipping rows in the datafile that contains NULL for a column that does not allow NULLs
- Introducing SQL Native Client
- Getting started with SQL Native Client
- Using MARS with SQL Native Client
- Scalar Subqueries
- XML: Typed and Untyped
- What Master???
- Hash Aggregate
- CHECKDB (Part 5): What does CHECKDB really do? (part 4 of 4)
- Fragmentation (part 4): what are heaps?
- CHECKDB (Part 4): What does CHECKDB really do? (part 3 of 4)
- Stream Aggregate
- Aggregation
- Subqueries: ANDs and ORs
- Subqueries in CASE Expressions
- Summary of Join Properties
- SQL Linked Server Query failed with “Login failed for user …”
- Hash Join
- Don't try this at home kids... (data recovery using DBCC PAGE)
- Poking about with DBCC PAGE (Part 1 of ?)
- Merge Join
- Nested Loops Join
- "No process is on the other end of pipe" caused by bad certificate
- Can't I ever get a guarantee?
- Scale-up technology
- Introduction to Joins
- CHECKDB (Part 3): What does CHECKDB really do? (2 of 4)
- Index Examples and Tradeoffs
- Under the covers: GAM, SGAM, and PFS pages
- Seek Predicates
- Quick guide to DB users without logins in SQL Server 2005
- Bookmark Lookup
- Why is the NULL bitmap in a record an optimization?
- Fragmentation (part 3): What are extents?
- Scans vs. Seeks
- Fragmentation (part 2): What are pages?
- Introducing Multiple Active Result Sets (MARS) (2)
- Fragmentation (part 1): What are records?
- Why are those IOs taking so long?
- Fun with execution context switching
- Why you should NOT optimize your backup strategy for backup speed
- Properties of Iterators
- CHECKDB (Part 2): What does CHECKDB really do? (1 of 4)
- Another disaster recovery 'advice' gem...
- Ta da! Emergency mode repair
- Do you need to run CHECKDB because of SQL Server?
- Impersonation in SQL CLR
- Assembly redirection and CLR Integration
- Which part of 'REPAIR_ALLOW_DATA_LOSS' isn't clear?
- When should you rebuild the transaction log?
- Just why are you backing up your database?
- Data files: To Autogrow Or Not To Autogrow?
- Here's a good reason not to run SHRINKDATABASE...
- How to use DBCC PAGE
- TSQL Basics II - Parameter Passing Semantics
- CHECKDB (Part 1): How does CHECKDB get a consistent view of the database?
- The Building Blocks of Query Execution
- Diagnosing 17883, 17884, 17887, 17888 errors
- Common bad advice around disaster recovery
- Repair vs Restore Dilemma
- Creating a CLR user define aggregate (part 2). Use multiple columns in the aggregation function
- Creating a CLR user define aggregate (part 1). Simple CLR aggregate
- Diagnosing CLR Execution in SQL Server
- Bulk Importing data with OPENROWSET in SQL2005
- How to distribute digitally signed SQL modules
- Range locks
- XML Data Type Limitations
- Lock Escalation in SQL2005
- TSQL Basics I: Stored Procedures In An Intrepreted Language
- Improving query plans with the SCHEMABINDING option on T-SQL UDFs
- Predicate ordering is not guaranteed
- What are the different cached objects in the plan cache?
- SQL Server 2005 –Encrypting data on existing applications
- Link to Laurentiu's blog
- Plan Guides Are Your Best Friends
- Introducing Multiple Active Result Sets (MARS) (1)
- Overview of T-SQL and CLR debugging in SQL Server 2005
- Cursors and memory scalability in SQL Server 2005
- Dealing with the Limitations of XSD Content Models
- Getting netmon sniff on local machine
- Checklist and tips for Connectivity Questions
- Exception handling in SQLCLR
- XML processing with XQuery (part 1)
- What does server side FOR XML return?
- Restrict IP Address to prevent invalid login attack to SQL Server.
- Strong named assemblies and AllowPartiallyTrustedCallers
- Configure Aliases Programmatically Using WMI
- Server Side Error Handling - Part 3 (Why do I still see error messages from inside tsql try-block?)
- Sorting undefined characters in Unicode and/or Windows collation
- SQL Server Identity column FAQs
- Name resolution, default schema, implicit schema Part IV
- Name resolution, default schema, implicit schema Part III
- Name resolution, default schema, implicit schema Part II
- Name resolution, default schema, implicit schema Part I
- Server Side Error Handling - Part 2 (Errors and Error Messages)
- Server Side Error Handling - Part 1 (Migrating from @@error to tsql try-catch)
- Host Policy level Permission Sets and their permissions
- Multiplication and Division with Numerics
- Newsequentialid (Histrory/Benefits and Implementation)
- Unable to connect to a SQL Server named instance on a cluster
- Understanding "login failed" (Error 18456) error messages in SQL Server 2005
- Understanding server-side protocol initialization error codes
- Troubleshoot Connectivity Issue in SQL Server 2005 - Part III
- VSS: SQL Server does not exist or access denied
- Unable to correct invalid SQL Server Network Configuration on clustered SQL Server causes clustered SQL Server fail to start “permanently”
- SQL Express remote connections
- Encrypting connections in SQL Server 2005 & SQL Native Client with SSL
- Connecting to SQL 2005 through SOAP Native Web Services using SQL user credentials from a different domain
- TDSSNIClient initialization failed with error 0xd, status code 0x36.
- Troubleshoot Connectivity Issue in SQL Server 2005 - Part II
- Creation of SOAP(HTTP) SSL endpoint fails with error 0x80070494
- SQL Server 2005 Connectivity Issue Troubleshoot - Part I
- “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain
- Unauthorized or AccessDenied exception when using SOAP Native Xml Web Services
- “Cannot Generate SSPI Context” error message, more comments for SQL Server
- Using Kerberos with SQL Server
- Additional comments on how to enable channel encryption
- Valid SELECT statement resulting in empty DataSet
- How to Enable Channel Encryption
- SQL Server enumeration and Windows Firewall
- SQL Server enumeration returns SQL Express but not MSDE
2018 47
December 2018
- Using SQL Service Broker for asynchronous external script (R / Python) execution in OLTP systems
- Performance implications of using multi-Statement TVFs with optional parameters
- Unattended install and configuration for SQL Server 2017 on Linux
- Collecting performance data with PSSDIAG for SQL Server on Linux
- How the SQLCAT Customer Lab is Monitoring SQL on Linux
- Improve query performance on memory optimized tables with Temporal using new index creation enhancement in SP1
- How bwin is using SQL Server 2016 In-Memory OLTP to achieve unprecedented performance and scale
- Do it right! Deploying SQL Server R Services on computers without Internet access
- SQLSweet16!, Episode 10: "I can eat glass …", but can I load it into a database?
- SQLSweet16!, Episode 9: Scripting Always Encrypted operations
- SQLSweet16!, Episode 8: How SQL Server 2016 Cumulative Update 2 (CU2) can improve performance of highly concurrent workloads
- SQLSweet16!, Episode 7: Install Option for Instant File Initialization
- SQLSweet16!, Episode 6: DBCC CHECKDB with MAXDOP
- SQLSweet16!, Episode 5: TRUNCATE Selected Partitions
- Changes in SQL Server 2016 Checkpoint Behavior
- Real World Parallel INSERT...SELECT: What else you need to know!
- SQLSweet16!, Episode 4: SQL Server R Services makes you a smarter T-SQL Developer
- SQLSweet16!, Episode 3: Parallel INSERT … SELECT
- SQLSweet16!, Episode 2: Availability Groups Automatic Seeding
- SQLSweet16!, Episode 1: Backup Compression for TDE-enabled Databases
- Checkpoint process for memory-optimized tables in SQL 2016 and implications on the log
- Considerations around validation errors 41305 and 41325 on memory optimized tables with foreign keys
- SQL Server 2016 SSIS Data Flow Buffer Auto Sizing capability benefits data loading on Clustered Columnstore tables
- Soften the RBAR impact with Native Compiled UDFs in SQL Server 2016
- SQL 2016: Columnstore row group Merge policy and index maintenance improvements
- SQL 2014 Clustered Columnstore index rebuild and maintenance considerations
- Data Loading performance considerations with Clustered Columnstore indexes
- AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.
- SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns
- Top 10 SQL Server Integration Services Best Practices
- Top 10 Best Practices for Building a Large Scale Relational Data Warehouse
- SQLCAT.com consolidated index of Whitepapers
- Writing New Hash Functions for SQL Server
- Comparing Different Results with RCSI & Read Committed
- How to tell which version of SQL Server data access driver is used by an application client
- Resolving DTC Related Waits and Tuning Scalability of DTC
- SQL Server 2008 R2 UNICODE Compression – what happens in the background?
- Monitoring free space in tempdb transaction log
- Looking deeper into SQL Server using Minidumps
- Backup More Than 1GB per Second Using SQL2008 Backup Compression
- Querying a Database Snapshot
- SQL Server 2005 Transactional Replication: Benefit of using SubscriptionStreams for low bandwidth, high latency environments
- Previously committed rows might be missed if NOLOCK hint is used
- OLTP Blueprint - A Performance Profile of OLTP applications
- Load 1TB in less than 1 hour
- Partitioned Tables, Parallelism & Performance considerations
- How do you measure CPU pressure?