It should look something like this: hamshackserver.database.windows.net

You just have to edit 'hamshackserver' to be whatever you named your server instance where the database lives.

You'll also have to allow your IP...

In addition to what Johan has pointed out, you can also use Extended Events to capture log behaviors, including the query that sparked them. Here's another article by Paul...

In addition to all the other good advice, look at the logic of the query. Filter data on retrieval instead of loading everything into temporary tables for processing.

I'm with Jeff.

Let's just clarify a bit though. Dimensional modeling is a good thing, for certain kinds of queries. It's not a good thing for other kinds of queries. So,...

The default value was set in 1998 on SQL Server 7. It's utterly and completely out of date. It bears no relation to the modern world. It should be a...

The default value was set in 1998 on SQL Server 7. It's utterly and completely out of date. It bears no relation to the modern world. It should be a...

It's another day when I think SQL Server Central must have been spying on us, producing such on-topic editorials, as here I am, old enough to claim my UK...

To summarize, if you (again, used figuratively an not pointed at anyone in particular) really want to learn something new, learn what you've been missing in SQL for the...

If you want to have a life, find a new career outside of IT.  Find a role that uses the technology skills you have in a privately held company...

Grant, thank you for the gentle reminder, but I fear that my response is not what I would have hoped and expected of myself.  I have become acutely aware...

Hey Jeff,

I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should I...

Hey Jeff,

I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should...

Hey Jeff,

I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should I use?

The reason I can think about the posts are because of may Accidental DBAs who are forced to do the DBA job who are Developers, Network admins, I also...

Thanks for the comments. Sorry I haven't gotten back. I was on vacation.

And yeah, I'm assuming a bug-in scenario more than a but-out one. However, set for both if necessary.