External Article

Core Database Source Control Concepts

Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. In this article, taken from Robert Sheldon's book 'SQL Server Source Control Basics' , he takes a step back from the details to explain the whole purpose of database source control and the most important operations within source control such as versioning, branching and merging.

External Article

Using Power BI in a Hybrid Environment

Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores. This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources.

External Article

SQL Server Bulk Insert Row Terminator Issues

We often need to import data into SQL Server from a file. Sometimes unwanted end of line characters are part of the source file and these can create issues when importing the data. One of the ways to avoid this issue is to use SQL Server Integration Services (SSIS), but it doesn't always make sense to use SSIS for simple operations. Rahul Mehta explains that he uses BULK INSERT sometimes faces issues with Line Feeds and Carriage Returns. In this post, Rahul shows some examples and explains how to fix the issue.

Blogs

The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5

By

Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...

A Prompt AI Experiment

By

Prompt AI released recently and I decided to try a few things with the...

SQL Server Is Slow (part 1 of 4)

By

How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...

Read the latest Blogs

Forums

how to get notification that my database has corssed 8gb

By rajemessage 14195

i have sqlexpress on rds, is there any way i can get notifacation that...

SQL Server, Heaps and Fragmentation

By dbakevlar

Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation

Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Visit the forum

Question of the Day

SQL Server, Heaps and Fragmentation

A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?

See possible answers