Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that the SQL Server 2017 version of the DMV, sys.dm_db_file_spavce_usage, has a new column named modified_extent_page_count, which shows the number of pages that have changed since the last full backup.
2017-12-08
3,696 reads
Microsoft has added a ton of new features in SQL Server 2017, including expanded operating system support, Graph database capability, Python support, and more. Join Greg Larsen as he explores nine of these new features.
2017-10-23
5,498 reads
Graph databases are useful for certain types of database tasks that involve representing and traversing complex relationships between entities. These can be difficult to do in relational databases and even trickier to report on. Until now, we have had the choice of doing it awkwardly in SQL Server or having an ancillary database to tackle this type of task. SQL Server 2017 will be bringing graph capabilities to the product but will these features prove to be good enough to allow us to dispense with specialised Graph databases? Dennes Torres decided to find out.
2017-09-07
3,818 reads
Siddharth Mehta shows that R libraries can be used from T-SQL to ingest data from the web into SQL Server.
2017-08-03
5,113 reads
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Yes, many visa services specialize in helping families apply for visas together. When families...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers