Posts

How To Shrink Database Log Files In SQL Server Using T-SQL

-
Hello! Below are the scripts to shrink a specific log file assuming log files take up so much disk space. -- View all log files in db and their log sizes DBCC SQLPERF(LOGSPACE); -- Backup log file first before shrinking BACKUP LOG [SandboxDb] TO DISK = 'Z:\SQL\Backups\Customer_DB\SandboxDb_Log.trn' WITH INIT, COMPRESSION; GO -- View Log File name of DB USE SandboxDb GO SELECT name FROM sys.master_files WHERE database_id = db_id() AND type = 1 /* Commands to shrink the db */ USE [SandboxDb]; GO CHECKPOINT ; GO -- Change the database recovery model to SIMPLE if FULL is the current recovery mode. ALTER DATABASE SandboxDb SET RECOVERY SIMPLE ; GO -- Shrink log file to 10240 MB. -- 10240 means 10,240 MB = 10 GB. DBCC SHRINKFILE (SandboxDb_Log, 10240 ); GO -- Reset the database recovery model. ALTER DATABASE SandboxDb SET RECOVERY FULL ; GO Cheers!
Post a Comment
Read more

Donate

SQL Server System Versioned Table Scripts

-
Hello, Here's some of my compiled T-SQL scripts to convert ordinary tables to System Versioned and data manipulation scripts. See below the scripts using ficticious tables and columns. How To Convert An Ordinary Table To A System Versioned Table Use TEST_DB GO ALTER TABLE dbo.tblFileFolders ADD StartTime DATETIME2 GENERATED ALWAYS AS ROW START CONSTRAINT DF_tblFileFolders_StartTime DEFAULT SYSUTCDATETIME(), EndTime DATETIME2 GENERATED ALWAYS AS ROW END CONSTRAINT DF_tblFileFolders_EndTime DEFAULT CONVERT (DATETIME2, '9999-12-31 23:59:59.9999999' ), PERIOD FOR SYSTEM_TIME (StartTime, EndTime); ALTER TABLE dbo.tblFileFolders SET ( SYSTEM_VERSIONING = ON ( HISTORY_TABLE = dbo.tblFileFoldersHistory ) ); How To A Drop System Versioned Table Use TEST_DB GO -- 1. Disable system versioning ALTER TABLE [dbo].[tblFileFolders] SET (SYSTEM_VERSIONING = OFF ); GO -- 2. Dr...
Post a Comment
Read more

Login failed for user 'Domain\MachineName$' When Connecting To SQL Server From WCF Or Windows Service

-
Image
Hello, In the event that you have a Windows Service that has some piece of sql or EF code that will connect to a SQL Server database and it will generate an error specified by the title of this post, the solution that worked was to add that machine to the Security node of the SQL Server instance. To elaborate the solution, first is to create a new Login object inside the Security node using the script below or thru the SSMS IDE. Use Master GO CREATE LOGIN [PH\GGSP006450$] FROM WINDOWS Once the login object has been created, go the User Mapping tab and select the appropriate database(s) that the machine will connect to and check the db_owner, db_datareader and db_datawriter roles for that that database. After that, your service can now connect to the SQL Server database. Cheers!
Post a Comment
Read more

How To Prioritize xUnit Test Methods Using TestPriority Attributes and ITestCaseOrderer Interface

-
Image
Hello, A requirement for a project wherein we want to prioritize tests given that a certain algorithm depends on the execution of another one, we need to create tests priorities so that test methods are executed in a sequential order. After doing some research, I found an article here that demonstrates on how to control the execution order of test methods. Given the sample code below in a console application, I would like to set a priority for each method using the MDAS (Multiplication->Division->Addition->Subtraction) rule using the concepts from that article. public class MathOperations { public double Addition( double a, double b) { return a + b; } public double Subtraction( double a, double b) { return a - b; } public double Multiplication( double a, double b) { var result = a * b; return result; } public double Division( double a, double b) { var result = a / b; return result; } } The methodology that I ...
Post a Comment
Read more

Contoso Crafts Website Converted To Blazor Web Application In .NET 8

-
Image
Hello, Here's an upgrade of the Contoso Crafts Website project from ASP.NET Razor Pages to Blazor Web Application. As you remember, Contoso Crafts is the final output of the course ASP.NET Core 101 hosted by Scott Hanselman. To ellaborate this in detail, here's how I migrated the project to Blazor. The project structure illustrates that the razor pages were converted to components specifically the Home.razor, ProductCard.razor and ProductRating.razor. The products.json, Products.cs and the services are located to it's designated folders. I have copied the styles from the razor pages to the site.css and have referenced the font styles used to the App.razor component <!DOCTYPE html> <html lang= "en" > <head> <meta charset= "utf-8" /> <meta name= "viewport" content= "width=device-width, initial-scale=1.0" /> <base href= "/" /> <link rel= "stylesheet...
Post a Comment
Read more

Properties With DisplayFormat Attribute And Timestamp Not Showing Correctly In Blazor Using DisplayFor(). DisplayFor() Isn't Recognized In Blazor.

-
Image
Hi All, Given that we were migrating a proof of concept from ASP.NET Core MVC to Blazor, we were used to using the DisplayFor() method to show the values of the properties decorated with DataAnnotations attributes such as the example below. [DataType(DataType.Date)] [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)] [Display(Name = "Start Date")] public DateTime StartDate { get ; set ; } = DateTime.Now; [DataType(DataType.Currency)] [Column(TypeName = "money")] public decimal Budget { get ; set ; } However DisplayFor() isn't recognized method in Blazor, so what we did was to create a display property to return the values with proper format strings. Note that we added a NotMapped attribute so that when we perform database migrations, these properties are ignored. [NotMapped] public string DisplayDate { get { return EnrollmentDate.ToString( "yyyy-MM-dd" ); } } [NotMapped] public string ...
Post a Comment
Read more

DotNet.invokeMethodAsync() Does Not Invoke C# Method In Blazor Component Using Microsoft Edge Browser

-
Hello, Here's an odd error of DotNet.invokeMethodAsync() that I encountered. This method works for both Google Chrome and Mozilla Firefox but not on Microsoft Edge. The code below will just call a weather API and deliver a response payload to the C# caller function. I window.checkWeather = (cityName) => { const API_KEY = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxx" return new Promise((resolve, reject) => { fetch(`https: //api.openweathermap.org/data/2.5/weather?q=${cityName}&appid=${API_KEY}&units=metric`) .then(res => { if (!res.ok) { console.error(`HTTP error: ${res.status}`); } DotNet.invokeMethodAsync( 'WeatherApplication' , 'ShowWeatherContainer' ); return res.json(); }) .then(data => { resolve(data); }) . catch (error => reject(error)) }) } Afte...
Post a Comment
Read more

Blazor TableTemplate DataSource Or Items Not Updating After Modifying Its Items When CheckBoxChanged Is Fired

-
Image
Good day! As I was following a module on component templates in Blazor, it illustrates a table template with a row template and has a checkbox control that when clicked, it will fire an event and alter the value of a property of a collection. <TableTemplate Items= "benefits" IsSmall= "true" > <TableHeader> <th class= "w-auto" >Benefit</th> <th class= "w-25" >Start date</th> <th class= "w-25" >End date</th> </TableHeader> <RowTemplate> <td> <input type= "checkbox" checked = "@context.Selected" @onchange= "e => CheckBoxChanged(e, context)" /> </td> <td>@context.Description</td> @if (@context.Selected) { <td>@context.StartDate?.ToString( "dd/MM/yyyy" )</td...
Post a Comment
Read more

Blazor - Not All Code Paths Return A Value In Lambda Expression Of Type 'RenderFragment In Code Behind

-
Hello, When I was transferring the C# Rendering Fragment snippet from the razor component to the code-behind class, I encountered this error which is "Not All Code Paths Return A Value In Lambda Expression Of Type 'RenderFragment<string> as presented on the code below. @code{ private RenderFragment< string > intro = text => @<h3>@text</h3>; } Afer reading the docs, this issue can be fixed in the code behind csharp class, by using the AddMarkUpContent() method builder parameter which will add HTML tags with content to the component as the delegate function of the RenderFragment object. private RenderFragment< string > intro = (text) => builder => { builder.AddMarkupContent(0, $ "<h3>{text}</h3>" ); }; In Code Behind" alt="Blazor - Not All Code Paths Return A Value In Lambda Expression Of Type 'RenderFragment In Code Behind" border="0" width="320" data-origin...
Post a Comment
Read more

Cascading Parameter Is Always Null Or Is Not Working In Blazor .NET 8

-
Hello, When working with cascading parameters in Blazor Web Application in .NET 8, I encountered an issue that this always returns null even if the logic is in place. After doing some research, I found the solution here which is to set the interactive mode attribute of Routes component in App.razor component. Routes component in App.razor without the interactive mode. <body> <Routes /> <script src= "_framework/blazor.web.js" ></script> </body> Routes component in App.razor the the interactive mode set. <body> <Routes @rendermode= "InteractiveServer" /> <script src= "_framework/blazor.web.js" ></script> </body> I just hope there will be a better solution for this issue in the near future.
Post a Comment
Read more

Donate