×

#DataWeekender CU5

May 14, 2022

View Event: Query store hints demo Query Store hints feature provides an easy-to-use method for shaping query plans without changing application code. This feature is a member of the Intelligent Query Processing family. In this demo-only session, I will show how to use and take advantage of Query Store hints.

T-SQL Tuesday #150: Is that a Tech Job?

May 10, 2022

I thank Kenneth Fisher (Blog|Twitter) for hosting T-SQL Tuesday #150. The topic for this month is your first technical job(s). I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the T-SQL Tuesdays and participated in a few. Thank you, Steve Jones (Blog|Twitter), for coordinating this program. If […]

Azure SQL Database backup history

May 4, 2022

There is a new DMV currently in preview which returns information about backups of Azure SQL databases except for the Hyperscale tier. Microsoft official documentation is here. If you run the example query as-is from the above documentation some of the columns do not make sense. Instead, use this query where I am joining with […]

SQLDay 2022

May 10, 2022

View Event: Think like the Cardinality Estimator SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates based 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 […]

Groupby: EUROPE

May 4, 2022

View Event: What the Heck is a Checkpoint and Why Should I Care? An 8K page is the fundamental unit of data storage in SQL Server. For performance reasons, SQL Server performs every data modification operation in memory (buffer pool) and does not write it back to disk immediately. This is where checkpoint comes into […]



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

I want to talk about forgiveness and why no, white people, you are NOT entitled to it from Black people.

It's been ... around 72 hours since ten innocent people were brutally slaughtered for being Black and as usual when things like this happen, white comfort supersedes Black grief.

My good friend @SqlWorldWide is going to teach us new features SSMS at 6 30 pm EST today..not too late to sign ... up..https://www.meetup.com/tripass/events/285184740/?_xtd=gatlbWFpbF9jbGlja9oAJDQ3ODcxNjg5LTE5Y2EtNDJhYy05N2RiLTNiN2MzZjI0YzdkYg&_af=event&_af_eid=285184740

Happy Monday!! Hope you had a great weekend.

@dgmelkin will be talking about "Choosing the Right Tool for the Job"

... Wednesday May 25, 2022
3 PM EST

Registration:
https://www.meetup.com/dbavug/events/285507807/

#tools #dataplatform #mvpbuzz

I will be speaking at Triangle SQL Server User Group.

New features in Management Studio — Performance Troubleshooting... made easier!

Tuesday, May 17, 2022
6:30 PM to 8:30 PM EDT

Registration:
https://www.meetup.com/tripass/events/285184740/

#ssms #performance #sqlserver #MVPBuzz

Load More...