Adding a Database with Polybase External Tables to Always On Availability Group
Learn how to ensure your PolyBase objects are accessible from all nodes in an Availability Group.
2020-05-26
3,855 reads
Ramya Makam
TempDB growth due to version store on AlwaysOn secondary server
On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.
2016-11-07
21,868 reads
SELECT INTO vs INSERT INTO on Columnstore
This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.
2016-08-05 (first published: 2015-06-09)
21,716 reads
Mail Fails with SQLCMD Error
I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.
2015-03-19
10,258 reads
How does a View work on a Table with a Clustered Columnstore Index ?
This article is about how a view works when it is created on a table with clustered columnstore index on it.
2015-02-05
6,565 reads
Clustered Columnstore Index Gives "Unable to find index entry" Error
The Clustered columnstore index generates "unable to find index entry" error and a memory dump after few DMLs on the table
2014-09-02
2,375 reads
Blogs
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
Forums
ALAMAT BANK BCA KCU GUNSA 45 TLP/WA 08218154374
Hub Cs: 08218154374 Jl. Gn. Sahari No.45, RT.7/RW.5, Gn. Sahari Utara, Kecamatan Sawah Besar,...
ALAMAT BCA KCU PASAR BARU TLP/WA 08218154374
Hub Cs: 08218154374 Jl. Samanhudi No.8, RT.2/RW.8, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Alamat BCA KCU PALANGKARAYA Telp 08218154374
WhatsApp: 08218154374 Jl. Jend. A. Yani No.47, Langkai, Kec. Pahandut, Kota Palangka Raya, Kalimantan...
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers