📅 Week 10
Clearing SQL Server Connection Pools In C# & .NET
[SQL Server, C#, .NET]
Creating database connections from an application is an expensive operation.
What Does Truncate Table Do In PostgreSQL
[PostgreSQL, Database]
Yesterday’s post, “What Does Truncate Table Do In SQL Server”, looked at what happens when we execute the TRUNCATE TABLE command in a SQL Server Database.
What Does Truncate Table Do In SQL Server
[SQL Server, Database]
If you have a large amount of data in a SQL Server table and want to quickly purge it, one way is to truncate the table using the TRUNCATE command.
Tip - XtraReports DevExpress.Data.Internal.XtraSerializationSecurityTrace.NonTrustedTypeDeserializationException
[DevExpress, Reporting]
In a previous post, “Tip - DevExpress XtraReports CodeDomLayoutSerializationRestrictedException”, we looked at an exception that you may get when you attempt to load a XtraReport that has been serialized using CodeDOM.
📅 Week 09
FIX - SQL Server Database Stuck In 'Restoring' State
[SQL Server, FIX]
Recently, I noticed one of my SQL Server databases had been stuck in a ‘Restoring’ state for quite some time.
How To Set Scoped Environment Variables In C# & .NET
[C#, .NET]
In a previous post, “How To Read Environment Variables In C# & .NET”, we looked at how to read environment variables in C# & .NET.
How To Set Scoped Environment Variables In PowerShell
[PowerShell]
In a previous post, “How To Read Environment Variables In PowerShell”, we looked at how to read environment variables in PowerShell.
About Environment Variable Scopes
[Operating Systems]
The past two posts, “How To Read Environment Variables In C# & .NET” and “How To Read Environment Variables In PowerShell”, have looked at how to read environment variables.
How To Read Environment Variables In C# & .NET
[C#, .NET]
Our previous post, “How To Read Environment Variables In PowerShell”, looked at how you can read environment variables using PowerShell and either just view them or use them subsequently in your scripts.
How To Read Environment Variables In PowerShell
[PowerShell]
Occasionally, you might want to read an environment variable from your PowerShell session.
Controlling LDAP & LDAPS Certificate Validation In C# & .NET
[C#, .NET, Security]
Two recent posts, “Leveraging LDAPS Authentication in C# & .NET” and “Leveraging StartTLS Authentication in C# & .NET”, have covered how to leverage LDAPS and StartTLS for authentication, and how they use SSL to ensure all the traffic between the client (application) and server (LDAP) is appropriately encrypted.
📅 Week 08
Leveraging StartTLS Authentication in C# & .NET
[C#, .NET, Security]
In yesterday’s post, “Leveraging LDAPS Authentication in C# & .NET”, we looked at how to leverage LDAPS authentication in our applications, and the fact that it is more secure than LDAP.
Leveraging LDAPS Authentication in C# & .NET
[C#, .NET, Security]
In yesterday’s post, “Leveraging LDAP Authentication in C# & .NET”, we looked at how to leverage LDAP for authentication.
Leveraging LDAP Authentication in C# & .NET
[C#, .NET, Security]
When it comes to authentication, there are lots of solutions on the table, ranging from custom, hand-rolled solutions to elaborate ones like OAuth.
Generating Unique Identifiers In C# & .NET
[C#, .NET, StarLibrary]
A common issue we run into, yet never think much of, is generating identifiers.
📅 Archives ...