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...
Pertokoan Paradise, Jl. Paradise 11 No.23 Blok J-1 No. 6 & 7, Papanggo, Kec....
Jl. HOS Cokroaminoto Jl. Ciledug Raya, RT.001/RW.006, Kreo Selatan, Kec. Larangan, Kota Tangerang, Banten...
Jl. Utan Kayu Raya No.94, RT.12/RW.10, Utan Kayu Utara, Kec. Matraman, Kota Jakarta Timur,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers