×

SQLSATURDAY 930 Cleaveland USA

December 29, 2019

View Event: If you use Azure, you must learn Kusto Query Language? Kusto is a service for storing and running interactive analytics over Big Data, easy to query using Kusto Query Language (KQL). As we make progress in our migration to the cloud, we are learning new ways to monitor and alert on resources and […]

Did My UDF Inlined?

December 30, 2019

With the release of SQL Server 2019, CTP 2.1 new features were added to Intelligent Query Processing (QP) feature family. One of those features was Scalar UDF Inlining. You can read about the announcement by Karthik Ramachandra from Microsoft in this blog post. Karthik explained why UDFs are a problem when inlining is not done. Another […]

UDFs CPU and Elapsed Time

December 23, 2019

Microsoft SQL Server Management Studio (SSMS) version 17.5 added new showplan attributes UdfCpuTime and UdfElapsedTime to QueryTimeStats. These two attributes will measure the time and CPU spent on user-defined functions within a query execution hence helping to discover the impact of UDF execution within full query execution. This feature was first added in SQL Server […]

Database Administration Virtual Group

December 20, 2019

View Event: New features in Management Studio — Performance Troubleshooting made easier!https://dba.pass.org/MeetingDetails.aspx?EventID=14678 Abstract SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools, which enabled rapid enhancement to the Execution Plan. Do you know that now you can see how many pages are spilled to disk […]

Rochester PASS Chapter Monthly Meeting

December 20, 2019

View Event: Azure SQL Database – Where is my SQL Agent? You migrate your on-premise SQL Database to cloud, taking advantage of the PaaS offering of Azure SQL Database. You heard the promise of spinning up databases on demand and being able to scale up resources during high peak and scale down when not in […]

My Stackexchange Profile

profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Preparing for my presentation to #Vermont SQL User Group on Tuesday.
https://www.meetup.com/VTCode/events/267938985/

... http://sqlworldwide.com/vermont-sql-server-user-group/

@sqlpass
#MVPbuzz

Load More...