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
Additional Articles
Optimize SQL Server estate monitoring with Redgate's SQL Monitor
How can we balance our need to monitor SQL Server performance and operational processes across hundreds of SQL Servers, but also save time by focusing on the highest priority issues?
2020-12-04
10 DevOps strategies for working with legacy databases
The database is often left behind as organisations embrace DevOps. In this article, Robert Sheldon explains how to successfully bring databases into DevOps, especially when dealing with legacy databases.
2020-12-03
Why you should include the database in your 2021 IT strategy
As 2020 draws to a close, managers in many organizations are considering what the next 12 months IT strategy should look like, and how this underpins business objectives. Given the current business climate where the pandemic has prompted many companies to change the way they work, it’s even more important right now – and it’s an opportunity to get ahead.
2020-12-03
Configure SQL Server Database Mail on Amazon RDS
In this article we look at how to configure database mail for a RDS SQL Server instance on Amazon AWS.
2020-12-02
Have your say in the 2021 State of Database DevOps survey
Have you taken the 2021 State of Database DevOps survey yet? If you or your organization uses databases, we want to hear from you! Complete the survey for advance access to the final research report, and to be entered into a prize draw for a $500 Amazon voucher. Plus, for each submission we receive, we’ll donate $1 to the World Health Organization’s COVID-19 Solidarity Response Fund.
2020-12-01
SQL Server Backup Types
One of the most important responsibilities for a DBA is to ensure that a database can be restored in case of corruption, a dropped table, or another disaster. In this article, Greg Larsen explains the different types of backups available with SQL Server.
2020-12-01
Database DevOps for Pragmatists: A Datafaction Case Study
Ami Adler, a Software Development Manager at Datafaction explains how they used Redgate tools, and others, to introduce automation and testing into their Database DevOps processes and so achieved a faster and more reliable deployment process for their application.
2020-11-30
Manage Power BI Dataset with PowerShell
Learn how to manage Power BI datasets with PowerShell with examples to give Developers and DBAs the flexibility have real time data stored in the Power BI service for reporting.
2020-11-30
BMWs SQL Server Enterprise Architect on the challenges of monitoring
Tony Maddonna, BMW’s SQL Server Enterprise Architect, writes about the challenges of database monitoring. Drawing on experiences throughout his career, this blog covers manual vs third party, proactive monitoring in dev and test, and managing expectations of the cloud. To learn more, and read his tips on how to build a business case for third-party tooling, check out his blog.
2020-11-27
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers