Learn how a C# script can easily load data from Excel into SQL Server.
The post A Simple Method to Load Excel Data appeared first on SQLServerCentral.

Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” In that post, I talked about how we can use SQL Server’s metadata to instantly retrieve the row count for a table.
The post Counting more efficiently appeared first on SQLServerCentral.

Learn how you can handle dimensional modeling in a data warehouse when your data uses different categorization for ages.
The post Dimensional Modelling Case Study Part 1 - Age Group appeared first on SQLServerCentral.

A list of articles in my series on Azure Data Studio.
The post The Mastering Azure Data Studio Series appeared first on SQLServerCentral.

We are adding a consent form to the SQL Server Central website to allow our cookies.
The post Adding Cookie Consent to SQL Server Central appeared first on SQLServerCentral.

But nowadays, most services are in the cloud. They're not on your servers; they're somewhere else. With most software-as-a-service (SAAS) offerings, you don't have many options to configure connectivity. What if you need data from one SaaS service into another?
The post Connecting SQL Server to SaaS applications with a Linked Server appeared first on SQLServerCentral.

Learn about the benefits of mixed extent allocation in SQL Server 2016, along with how you can check this setting or enable it in your database.
The post An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation appeared first on SQLServerCentral.

Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so you can check the whole SQL Expression and work out why it is running so slowly.
The post Using a SQL Tokenizer appeared first on SQLServerCentral.