View Event: The Magnificent Seven – Intelligent Query Processing in SQL Server Is there a way to fix query performance issues without any code changes? Making application changes can be an expensive undertaking. Hence, developers and DBAs want the query processor to adapt to their workload needs vs. having to use options and trace flags […]
View Event: Think like the Cardinality Estimator SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code […]
View Event: Extended Events – How to collect the first 10 or every 4th event Fast-paced 15-minutes-or-less talks, followed by a chance to have some Q&A with the speaker. Extended Events offers a rich filtering mechanism, called predicates. Have you ever thought of collecting only the 4th event, first 10 occurrences of an event, capture […]
View Event: New features in Management Studio — Performance Troubleshooting made easier! SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which enabled rapid enhancement to Execution Plan. Do you know that you can now see how many pages are spilled to disk for a sort, […]
PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. SQLSaturday Rochester will be held on Feb 29, 2020, at Rochester Institute of Technology, 1 Lomb Memorial Drive, Rochester, New York, 14623, United States. […]
Got stack dumps? Check out the latest version of the SQLCallstackResolver from @arvisam ! ... https://github.com/arvindshmicrosoft/SQLCallStackResolver/releases/tag/2.0.1
Looking forward to moderate this session by @SQLGoddess .
We have 142 data professionals signed up. We can accommodate ... few more.
Looking forward to hosting @SQLGoddess tomorrow night, talking about "TempDB: The Good, the Bad, and the Ugly". There's still time to sign up: https://www.meetup.com/NESQLUG/events/271358709/
"See" you there!
What an honor and privilege to be speaking at @ROCSqlUG
Thursday, August 13, 2020
19:00 - 21:00 EDT
The Magnificent ... Seven - Intelligent Query Processing in SQL Server
Registration details:
https://rochesterpass.pass.org/
#sqlpass #sqlserver #sqlserver2019
#mvpbuzz
@timweigel @SqlWorldWide @sqlpass The game changer that I found for SQL Saturday Iowa 2020 was to fully embrace the ... online event and stop thinking of it as an "in person" event presented online. We found innovative ways around many of the online event challenges.
The great staff we have didn't hurt either!
@timweigel @SqlWorldWide @sqlpass In person is great for a rock solid paywall.
In person events allow me to see people ... who I love to talk to but who live in places I rarely get to visit... @SQLInTheWild, @rob_farley, and @jesus_gilv jump right to mind, among a full on hoard of European friends.
