system_health Extended Events in Azure SQL Database
The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management...
2019-03-04
499 reads
The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management...
2019-03-04
499 reads
What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The...
2019-02-27 (first published: 2019-02-11)
2,091 reads
I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I received recently asked how to export a database from...
2019-02-25
14 reads
If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing a few extensions. Buck Woody has a great list...
2019-02-18
6 reads
If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing...
2019-02-18
313 reads
I see more and more people starting to use Azure Data Studio. As it keeps growing and expanding, it’s going...
2019-02-15 (first published: 2019-01-28)
1,804 reads
What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The only way to find out how this works is...
2019-02-11
6 reads
I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer, I love Entity Framework. That’s right. Entity Framework is...
2019-02-04
13 reads
I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer,...
2019-02-04
164 reads
I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here. I’m going to start doing regular live events on...
2019-01-29
5 reads
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