Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year. If you’re not already on the mailing list, sign up now and be the first to know all Summit 2023 updates.
Discover the importance of database ownership in SQL Server and learn the process of changing database owner using SQL Server Management Studio or ALTER AUTHORIZATION statement
At Redgate Software, we've been trialing Copilot from GitHub with our developers. I managed to get access for this experiment and have tried a few things, though I'm not sure I've found it very useful. I'll continue to work with Copilot, but for now, I just don't find Copilot AI helping me with the types […]
You're tasked with installing SSIS as part of a SQL Server installation or adding it to an existing one and would like a step by step guide showing how to install it.
I took part in a podcast this week, Arrested DevOps. I did one with them once before, almost ten years ago. The host and I were both a little surprised that it had been so long. This caused us to look back a bit. Interestingly enough, ten years ago meant I was only about two […]
Reviewing Pull Requests (PR) is something that developers should take seriously, but Steve doesn't think this always happens.
A problem with the configuration of Microsoft Defender caused all activity on the server to get delayed.
Security is a concern whether it be on-premises or cloud-native. Google Cloud offers many products and services including SQL Server. What are some of the security controls that should be considered when using Google Cloud services?
You’ve got an existing application with a database back end. You’re thinking about changing the database, and you don’t wanna break stuff.
Today Steve wonders to which version you would upgrade your SQL Server instances. There should be a minimum version you would try to reach.
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers