SQL Server Collation Options
“CS” / “CI” – Obviously, this one is just case sensitivity between upper and lower case. The default during SQL Server install as well as a database creation is “case insensitive”. With case-insensitive, your queries...
Author: Ozkan Oner
Changing texts in GridDateTimeColumn filter in Telerik Radgrid
I think Google Translate is used in the Turkish translation of Telerik Radgrid, so when choosing between two dates, the text From and To is written next to the datepicker. This creates an absurd...
T-SQL Cursor Usage
Cursor allows us to perform line-by-line operations within the returned values in SQL Server. We make this structure, which we use frequently in programming languages, thanks to the cursor in the database. We can...
Meta Tags for SEO
Meta tags are html codes that allow your site to be understood by search engines and social networks and show your results accordingly. It is positioned between the head tags of the site. Meta...
https redirect with htaccess
After installing SSL on your site, we have a very simple code to redirect all incoming requests to https. When you paste this code into the .htaccess in your site’s main directory, all requests...
Simple Security Measures for WordPress with htaccess
WordPress is a content management system that many people like and use around the world. That’s why it’s interesting for hackers. Having so many users means plenty of material for hackers. Of course, I...
How to sort by date instead of string with DataTable
DataTable perceives the date column as a default string and because it sorts alphabetically, illogical listing emerges. In order to avoid this problem, we need to add data-order to the column of the table...
Set AutoIncrement initial value for Sql Server Primary Key column
Actually, this code has several purposes. It gives Identity information only when the table name is given. When ‘reseed‘ is added, if the table has a problem with identity, it helps to fix it,...