Recently I had a requirement to generate/convert varbinary column data to a csv file. Below is the way I achieved this.
select ‘bcp.exe “select [column(s)] from <DB Name>.<Schema>.<Table> where <Condition> ‘” queryout <filename>.csv -n -T -S “‘ + @@SERVERNAME + ‘”‘
Happy coding!!
If you ever come across the following error when running .Net Core app in a Docker container.
Check the Docker file in the project and make sure the entries shown in bold below are matching the targeted .Net Core framework of your app
FROM mcr.microsoft.com/dotnet/aspnet:5.0-buster-slim AS base
WORKDIR /app
EXPOSE 80
FROM mcr.microsoft.com/dotnet/sdk:5.0-buster-slim AS build
Good luck!!
Open up the Anaconda command prompt:
You can do this either inside the Anaconda navigator or just running the Anaconda Prompt desktop App.
To open the Anaconda command prompt through Anaconda navigator:
Go to Environments > Click on the triangular button 
of the target environment (default is: base(root))
Then select “Open Terminal” from the popup menu
In the terminal window key in the following command to create the “jupyter_notebook_config.py” config file in the .jupyter folder in default user directory (i.e. C:\Users\<username>)
Modify the config file and restart Anaconda Navigator:
Open the jupyter_notebook_config.py file in any suitable text editor and modify the “c.NotebookApp.notebook_dir” entry to point to the desired working directory. You will have to modify the “\” to “\\” in your windows file path. Make sure to uncomment the line by removing the “#”.
Save the file and restart the Anaconda Navigator.
Keep getting the following error when trying to access the website running on Anonymous Authentication?
“Error message 401.3: You do not have permission to view this directory or page using the credentials you supplied (access denied due to Access Control Lists)”
Solution:
For example:
If the application pool name is “DefaultAppPool”, then the application pool identity userid would be IIS APPPOOL\DefaultAppPool.
There is no EventLog source named ‘ASP.NET x.x.x.’. This module requires .NET Framework x.x
The above error is thrown because we are trying to log the ASP.Net errors (in most cases, unhandled errors) in to EventLog of the O/S using “WebMonitor.UnhandledExceptionModule” but the required EventLog source is missing. Therefore the fix for this would be to create the missing EventLog source. But where? Below I explain where and how to create the missing EventLog source in the server that you have hosted your site.
Where?
The missing EventLog source should be created in the O/S registry at the following location;
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet001\Services\EventLog\Application
How?
That’s it, this should fix the issue for you!! If not pls let me know
Hi All,
Recently I had to write the following script on MS SQL Server to create a proc that would search through all the procedures in the database for a given search phrase. Guess it would be helpful for someone else as well.
create proc adm_SearchProcs
@searchText varchar(max)
as
begin
select ‘exec sp_helptext ‘ +””+ specific_schema +’.’ + routine_name +””
from information_schema.routines
where routine_definition like ‘%’+@searchText+’%’
order by 1
end
Happy Coding!!
Rasika
Hi All,
I recently came across the following errors on trying to do an integrity check on one of my DBs
Msg 8951, Level 16, State 1, Line 1
Table error: table ‘LIVE.CBNHEA’ (ID 1652916960). Data row does not have a matching index row in the index ‘CBNHEA_ROWID’ (ID 2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (1:3726817:1) identified by (HEAP RID = (1:3726817:1)) with index values ‘ROWID = 5679187 and HEAP RID = (1:3726817:1)’.
Msg 8951, Level 16, State 1, Line 1
Table error: table ‘LIVE.CBNHEA’ (ID 1652916960). Data row does not have a matching index row in the index ‘CBNHEA_CBH0’ (ID 3). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (1:3726817:1) identified by (HEAP RID = (1:3726817:1)) with index values ‘STOFCY_0 = ‘HLT’ and ITMREF_0 = ‘ and HEAP RID = (1:3726817:1)’.
Msg 8951, Level 16, State 1, Line 1
Table error: table ‘LIVE.CBNHEA’ (ID 1652916960). Data row does not have a matching index row in the index ‘CBNHEA_CBH1’ (ID 4). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (1:3726817:1) identified by (HEAP RID = (1:3726817:1)) with index values ‘STOFCY_0 = ‘HLT’ and LLC_0 = 99 and ITMREF_0 = ‘ and HEAP RID = (1:3726817:1)’.
CHECKDB found 0 allocation errors and 3 consistency errors in table ‘LIVE.CBNHEA’ (object ID 1652916960).
CHECKDB found 0 allocation errors and 3 consistency errors in database ‘xxxxx’.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (xxxxx).
Then I ran the dbcc CHECKDB with ‘repair_rebuild’ on single user mode and it fixed the issue straight away.
This is what I did;
1. Put the DB on single user mode – In order to do this, right-click on the DB and select properties and then go to options, in the options select “Restrict Access” and then select “Single_User” and click “Yes”. You will have to close the management studio and reconnect again before proceeding to the next step.
2. After login on to management studio open up a query window that points to the relevant DB. Type the following
dbcc CHECKDB(‘dbname’,‘repair_rebuild’)
3. run the dbcc CHECKDB(‘dbname’)
This time all the inconsistency errors are gone 🙂
Happy Coding 🙂
Hi All,
Recently I came across a requirement where I had to cleanse the data that I’m inserting in to MySQL database using regular expressions, so I started searching for a function to do this on MySQL, but unfortunately I couldn’t find any. There was one called UDB but that’s also you need to install a module and stuff like that. I gave up searching finally and wrote my own “regex_replace” MySQL function.
Below is the source code of my function;
DELIMITER $$ CREATE FUNCTION `regex_replace`(pattern VARCHAR(1000),replacement VARCHAR(1000),original VARCHAR(1000)) RETURNS VARCHAR(1000) DETERMINISTIC BEGIN DECLARE temp VARCHAR(1000); DECLARE ch VARCHAR(1); DECLARE i INT; SET i = 1; SET temp = ''; IF original REGEXP pattern THEN loop_label: LOOP IF i>CHAR_LENGTH(original) THEN LEAVE loop_label; END IF; SET ch = SUBSTRING(original,i,1); IF NOT ch REGEXP pattern THEN SET temp = CONCAT(temp,ch); ELSE SET temp = CONCAT(temp,replacement); END IF; SET i=i+1; END LOOP; ELSE SET temp = original; END IF; RETURN temp; END$$ DELIMITER ;
Note:
If you are using MySQL version 5.0.1 or higher, make sure you set the NO_BACKSLASH_ESCAPES mode ON, before you use the above function to replace any characters which are escaped with back slash “\”, ie: \A,\B,etc… See how to set the NO_BACKSLASH_ESCAPES mode here
Example on how to use this function
mysql> select regex_replace('[^a-zA-Z0-9\-]','','2my test3_text-to. check \\ my- sql (regular) ,expressions ._,');
Happy Coding!! 🙂
Function ParseDBNull(objVal,strDataType)
If ISNull(objVal) = True Then
Select Case lcase(strDataType)
Case “string”,”datetime”
ParseDBNull = “”
Case “numeric”
ParseDBNull = 0
Case “boolean”
ParseDBNull = False
Case Else
ParseDBNull = “”
End Select
Else
ParseDBNull = objVal
End If
End Function
Hi All,
You can use the following method to add menu items dynamically to the PopUpMenu of the DataGrid control of the SalesLogix6.2 LAN Client.
Sub PupulateMenu()
dim objMnu,i
dim arrMenuItems
arrMenuItems = Array(“Menu Item1″,”Menu Item2″,”Menu Item3″,”Menu Item4”)
set objMnu = <DataGrid Control Name>.PopupMenu
For i=0 to Ubound(arrMenuItems)
objMnu.Add
objMnu.Items(i+1).Caption = arrMenuItems(i)
Next
End Sub
Sub <DataGrid Control Name>MenuClick(Sender,Item)
Select case <DataGrid Control Name>.PopupMenu.MenuIndex
case 1
msgbox “Menu Item1 Selected”
case 2
msgbox “Menu Item2 Selected”
case 3
msgbox “Menu Item3 Selected”
case 4
msgbox “Menu Item4 Selected”
case else
msgbox “Invalid Menu Option”
End Select
End Sub
Happy Coding!! 🙂
Rasika's Blog 