SQL Server 2017 introduced the concept of graph data tables as part of the SQL Server database engine. With SQL Server 2019, there were some enhancements like ‘shortest path’ function and constraints on edge tables that make this feature more usable – although it is far from a full-fledged graph database. Graph tables are essentially […]
In this tip we look at how to restore a missing or corrupt SQL Server model database.
Phil Factor shares a handy keyboard shortcut diagram that reveals some of the most useful of Prompt's keyboard shortcuts, and a wallchart showing every piece of Prompt functionality, what it does, where to find it in the various menus, and of course its keyboard shortcut.
This week Grant talks about the need for change and growth to adapt to the changing world.
Identifying Performance Tuning Opportunities Using Extended Events: Part 3 Aggregate Report
Today Steve Jones looks at the relative cost of hardware and how we sometimes cause ourselves issues by not spending enough.
Phil Factor explores and discusses the current state of the art in SQL Formatting, as done automatically by SQL Prompt.
Learn about the range of connectivity options available for Azure SQL Database deployments.
A short article to help you quickly find a CU that isn't the latest one.
In this article we look at a new feature in SQL Server 2019 that can help improve TempDB performance.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Ruko Danau Sunter Utara, BLK. a 36D Jl. Danau Sunter Utara No.56, RT.11/RW.9, Sunter...
BCA KCP Tmn. Harapan Indah. Tlp:085373737845.Komp. Taman Harapan Indah Blok EE No.1, Jelambar Baru,...
Jl. Taman Pluit Kencana Selatan No.1-3, RT.4/RW.6, Pluit, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers