The most recent content from our members.
DPA displays when a query has used multiple plans however it is unclear when the query plan changed. In the native MDW / data collector as well as indicating that a query used multiple plans it reports at what date/time the new plan was used. It also displays what parameters the query is optimized for. This information is…
Hi, we use DPA 2025.2 with some multi database SQL Server. On one of them we get an error 422, if we open the Tuning section in DPA. The index advisor is empty and in iwc.log this: ERROR (2025-06-26T14:57:02,930+0200) [https-jsse-nio-443-exec-2-rest-229] RestExceptionHandler:371 - RestResponse{data=null,…
The audience for this post are technologists who have some exposure to provisioning resources in the Azure portal, but haven’t yet started doing scripted deployments. The purpose of this post is to get started with understanding and customizing the contents of an ARM template (as opposed to doing the one-click deployment…
This month's T-SQL Tuesday is hosted by Raul Gonzalez (@SQLDoubleG), and is about Lessons Learned the Hard Way. Now, I've learned many lessons the hard way. When I started my career and transitioned from web design and server-side scripting into more focus on SQL Server, I bought a whole bunch of books; my favorites were…
In a previous life, I was responsible for a production system with somewhere around 1,500 roughly identical databases, one per client. I called it a multi-tenant system for years, but that causes strife, because many people only think of multi-tenant as a database-level concept rather than an instance-level concept. This…
On June 19th, @kekline and I presented a webinar called "Tales from Building a SQL Server in Azure." In this session, we shared experiences and lessons learned from a recent migration of our business intelligence and data warehousing environment to Azure. Key discussion topics in the webinar: * Deciding between SQL Server…
This month's T-SQL Tuesday - hosted by Matt Gordon (@sqlatspeed) - is called "Fixing Old Problems with Shiny New Toys." Matt wants us to write about how we've solved old problems in new ways afforded by enhancements to SQL Server (or new features anywhere in the stack, I would guess). Over the years I have helped a lot of…
This month's T-SQL Tuesday topic is "SQL Server Bugs & Enhancement Requests." This is a topic near and dear to my heart; for several years I was a huge proponent of the Connect system. For a while, I even published weekly digests, where I highlighted bugs and feature requests that I thought deserved more eyeballs and…
This month's T-SQL Tuesday topic is "SQL Server Bugs & Enhancement Requests." My T-SQL Tuesday post is about a request for Power BI, which may be a little on the edge of SQL Server as far as T-SQL Tuesday goes. I want to talk about a limitation when sorting a Stacked Chart. As I mentioned in my previously, I started to…
This month's T-SQL Tuesday is hosted by Brent Ozar (b/t), and is about those wonderful Connect requests that we want fixed/added in SQL Server. Aaron Bertrand (b/t) reminded me of one of my all-time favorites. You know when you started working with SQL Server and you'd get error messages that you couldn't figure out? One…
It looks like you're new here. Sign in or register to get started.