Export SQL Server Data to Multiple Excel Worksheets with C#
In this article we look at how to export data from different SQL Server tables or queries into multiple Excel sheets in the same file.
2020-12-07
SQL Server
SQL Server
I am new to SQL Server and I have heard the term used in a number of different capacities and in different contexts. So what exactly is it? What are the common components? How does it work? How do people use it? I am brand new to the technology, where do I get started?
2020-11-20
SQL Server Clustered Index Fragmentation on GUID Columns
In this article we take a look at using GUID columns in your SQL Server database tables and the impact GUID columns may have on indexing.
2020-11-11
SQL Server Phone Home
SQL Server shares some data with Microsoft, but the use is documented. Steve sees this as a model for how companies might share information.
2020-10-26
250 reads
Computed Column Performance in SQL Server
Computed columns may be the cause of hard to track down performance issues. In this article, Robert Sheldon reviews the issues and some ways to get around them.
2020-10-12
How do You Identify Object Dependencies in SQL Server
In this article we look at different ways to determine if one SQL Server database object is dependent on another database object.
2020-09-03
Getting started with SQL Server stored procedures
In this article we look at different examples of creating SQL Server stored procedures.
2020-08-20
Using Simple Linear Regression to Make Predictions
The first part of this article focuses on using an R program to find a linear regression equation and the second part is devoted to simple linear regression analysis.
2020-08-13
SQL Server Agent Job Monitoring for Last Execution
In this article we continue our series of using PowerShell to monitor SQL Server by collecting the last run information for SQL Server Agent Jobs.
2020-08-12
SQL Server Bulk Insert for Multiple CSV Files from a Single Folder
Check out this article to see how to quickly import into SQL Server many files with the same structure using T-SQL.
2020-08-11
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers