Import Excel Data into SQL Server with PowerShell
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
Articles
What’s most important to you when dealing with database software?
Take part in this short exercise (no more than 5 minutes) by letting us know what matters most to you when considering, purchasing, or using database software. As a thank you, you can also enter our prize draw at the end for a chance to win a $150 Amazon gift voucher.
2021-01-05
Do *not* place TEMPDB on a local disk in a SQL failover cluster
What happens with tempdb on a local disk in a cluster? Read on to see that you will not get a failover if the local disk fails
2021-01-04
10,102 reads
Ten tips for attracting and retaining DevOps talent
To stay competitive and bring value to customers, organisations are adopting DevOps, but finding people experienced in DevOps can be challenging. Robert Sheldon has ten tips to help managers attract and retain DevOps talent.
2021-01-04
2021-01-01 (first published: 2017-08-17)
3,965 reads
SQL Server Management Studio Database Diagram Support Objects Cannot be Installed
In this article we look at how to resolve the error database diagram support objects cannot be installed because the database does not have a valid owner.
2021-01-01
SSRS Install, Setup and Configuration
In this article we cover all of the steps required to install, setup and configure SQL Server Reporting Services.
2020-12-31
Feature branches and pull requests with Git to manage conflicts
Feature branching and pull requests are two important concepts when using Git. In this article, Kendra Little explains these patterns and even provides a video to demonstrate.
2020-12-30
Free eBook: SQL Server Internals: In-Memory OLTP
In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.
2020-12-30 (first published: 2015-05-13)
55,467 reads
Join the Redgate Tool Tips Swap
Learn and share tool tips with your peers. Redgate has launched their Tool Tips Swap to help everyone make the most of their Redgate products. To get involved, simply share your top Redgate tool tip for boosting productivity. All tips will be collated into a blog post and shared with the community. Plus, you’ll get the chance to win a 3-month subscription to Pluralsight.
2020-12-30 (first published: 2020-12-17)
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers