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, 6 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...

Without seeing both plans and the code, I can only make a guess as to why you're not seeing the plan in cache. It could be, production is busy and...

I don't know what changes were made to DBCC between 08 and 16. I'm sure there were more than a few since there were all sorts of underlying updates. However,...

I don't recall it being a strict "two versions". Just that, at some point, they stop trying to keep the code up to date for the upgrades, forcing a two-hop...