Open Microsoft SQL Management Studio on the Source server. Log in to your SQL server. Expand the server and as well as Databases. Right click on the name of your database and go to Tasks...

Oh crud. Sorry. I totally missed that this was a managed instance. I actually have never set up Extended Events on MI. I've done it multiple times on Azure SQL...

Just be careful what you use the Developers Edition for.  If the databases on your SQL Express system are production databases in any way, shape, or form, it's a...

If you go to the Microsoft certification web site, they list all the topics you need to study for the test. Study those topics. Done.

The service account that SQL Server is running under must have access to the folder where you expect the Extended Event session to write to. It's nothing about creating the...

So, you want to return a list of procedures that are SELECT queries with result sets, but not INSERT, UPDATE, DELETE queries?

Honestly, I'm not sure how I'd go about doing...

• This reply was modified 5 years, 7 months ago by Grant Fritchey.

I'd suggest reading the Stairways series here on SQL Server Central. The introduction to T-SQL stairway has a lesson plan on GROUP BY. Scattered throughout the second...

If you set the parameters yourself, as Jeff is suggesting, then you don't have to worry about simple parameterization or forced parameterization (either of which is what you're hitting). That's...

No arguments here. Just as many business are hybrid when it comes to the cloud, many are hosting multiple data platforms. I've been learning (relearning to a degree) some Oracle...

Call me anything you want, just not late for dinner.

The job of administering databases was radically different in 1995 than it is today. Technology has shifted radically.

Yet, there's still a...

You can set up Availability Groups and other HA solutions using Azure (or AWS, GCP) as the secondary. I haven't had to do it myself in years & years, so...

When they say "pages" are they actually thinking about something like a Yabingle search result? Get the first 25 "pages" could mean the first set of results and the last...

You're looking at it. SQL Server Central has simply tons and tons of articles and instructions on how to work with SQL Server. I'd suggest the Stairways series as a...

Troubleshooting query performance is an enormous topic. In fact, if you look down in my signature line, I have two books on it. One is nearly 1,000 pages long. The...

Anyone still running SQL Server 2000 deserves every bit of pain they get doing an upgrade on a 21 year old piece of software.

Yeah, I'm a bad person. I'm strangely...