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.
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Comments posted to this topic are about the item What's new in R 4.6
Comments posted to this topic are about the item Interesting Changes in R, which...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers