DECLARE @DBName VARCHAR(64) = 'databasename'
 
DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX))
 
INSERT INTO @ErrorLog
EXEC sys.xp_readerrorlog 0, 1, 'Recovery of database', @DBName
 
SELECT TOP 5
 [LogDate]
,SUBSTRING([TEXT], CHARINDEX(') is ', [TEXT]) + 4,CHARINDEX(' complete (', [TEXT]) - CHARINDEX(') is ', [TEXT]) - 4) AS PercentComplete
,CAST(SUBSTRING([TEXT], CHARINDEX('approximately', [TEXT]) + 13,CHARINDEX(' seconds remain', [TEXT]) - CHARINDEX('approximately', [TEXT]) - 13) AS FLOAT)/60.0 AS MinutesRemaining
,CAST(SUBSTRING([TEXT], CHARINDEX('approximately', [TEXT]) + 13,CHARINDEX(' seconds remain', [TEXT]) - CHARINDEX('approximately', [TEXT]) - 13) AS FLOAT)/60.0/60.0 AS HoursRemaining
,[TEXT]
 
FROM @ErrorLog ORDER BY [LogDate] DESC

In this article we are going to discuss how to insert, update and delete data into database using ASP.NET MVC 4.0. There is a Layout page and Data base script that we are going to use for this but we are not going to discuss much  how to create a Layout page and database script here in detail. 

The collection includes 14 different tools including a Json to Yaml and Yaml to Json converter, a JWT decoder, a Text compare tool, and more.

The full list includes:

• Converters
  • Json <> Yaml
  • Number Base
• Encoders / Decoders
  • HTML
  • URL
  • Base64
  • JWT Decoder
• Formatters
  • Json
• Generators
  • Hash (MD5, SHA1, SHA256, SHA512)
  • UUID 1 and 4
  • Lorem Ipsum
• Text
  • Inspector & Case Converter
  • Regex Tester
  • Text Comparer
  • Markdown Preview
• Graphic
  • Color Blindness Simulator
  • PNG / JPEG Compressor

Some of the tools will have wider appeal, for example, the text comparison tool would be useful for writers and solicitors alike, while the PNG/JPEG compressor could help webmasters. Expect more utilities to join the bundle in the future.

The collection is free, and can be accessed via GitHub here or free via the Microsoft Store. 

Are you looking for a free, cross-platform and highly customizable code editor? Then Visual Studio Code might be what you are looking for so let's explore it in this video!

The Rust community doubled its number of users over the past two years -- from two million in the first quarter of 2022 to four million in the first quarter of 2024.

All the features are described in wonderful detail in the docs. Start with the overview, What’s new in C# 7.2, which gives you an excellent introduction to the new set of capabilities. 

Steve Ballmer on Tuesday left Microsoft's Board of Directors, citing new commitments as owner of the Los Angeles Clippers, a day after publicly stepping into his role with the team. 

Optimizing speed on eBay.com

Optimizing the performance of eBay’s sites and apps for a faster user experience. 

TDLight Telegram Bot API is a fork of the official Telegram Bot API, focused on memory footprint and performance.