Add a SQL Server Database to an Existing Always On Availability Group
In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.
2018-02-05
2,385 reads
Additional Articles
Install and Configure SQL Server 2017 Availability Groups on Linux - Part 3
In this tip, Edwin Sarmiento looks at how to create the Always On Availability Group with a listener name when using SQL Server on Linux.
2018-02-02
3,045 reads
Historical Stock Prices and Volumes from Python to a CSV File
Python is a versatile language that is gaining more popularity as it is used for data analysis and data science. In this article, Rick Dobson demonstrates how to download stock market data and store it into CSV files for later import into a database system.
2018-01-31
2,873 reads
Network Issue or THREADPOOL waits?
Tara Kizer talks identifying THREADPOOL waits and what you can do about them.
2018-01-30
3,043 reads
SQL Server Machine Learning Services – Part 3: Plotting Data with Python
One of the advantages of running Python from SQL Server is the ability to create graphics to assist in analysis of data. Robert Sheldon demonstrates matplotlib, a 2D plotting library, widely used with Python to create quality charts.
2018-01-29
3,463 reads
Free eBook: SQL Server Internals: In-Memory OLTP
In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.
2018-01-09
5,525 reads
Questions about Data Masking That You Were Too Shy to Ask
The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that can help your organization comply with this and other regulations. William Brewer answers those questions about data masking that you were too shy to ask.
2018-01-05
3,734 reads
SQL Server Machine Learning Services – Part 1: Python Basics
Python is a very popular language used for many purposes including machine learning. SQL Server 2017 supports Python with its Machine Learning Services component. Robert Sheldon explains how to get started using Python in SQL Server in the first article of this series.
2018-01-04
5,906 reads
How to Turn on Instant File Initialization
Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages.
2018-01-03
3,515 reads
Create Size-based Backups for SQL Server 2017
Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.
2018-01-02
3,457 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers