Recent Posts | - May, 2023-5,(1)
- February, 2023-2,(1)
- November, 2022-11,(1)
- July, 2022-7,(2)
- March, 2022-3,(1)
- November, 2021-11,(2)
- August, 2021-8,(2)
- July, 2021-7,(2)
- June, 2021-6,(1)
- May, 2021-5,(1)
- March, 2021-3,(1)
- February, 2021-2,(2)
- January, 2021-1,(7)
- December, 2020-12,(3)
- March, 2020-3,(2)
- February, 2020-2,(1)
- December, 2019-12,(2)
- November, 2019-11,(1)
- October, 2019-10,(1)
- September, 2019-9,(1)
- August, 2019-8,(1)
- May, 2019-5,(1)
- April, 2019-4,(2)
- March, 2019-3,(2)
- December, 2018-12,(1)
- November, 2018-11,(4)
- July, 2018-7,(1)
- May, 2018-5,(3)
- April, 2018-4,(2)
- February, 2018-2,(3)
- January, 2018-1,(3)
- November, 2017-11,(2)
- August, 2017-8,(1)
- June, 2017-6,(3)
- May, 2017-5,(5)
- February, 2017-2,(1)
- December, 2016-12,(1)
- October, 2016-10,(2)
- September, 2016-9,(1)
- August, 2016-8,(1)
- July, 2016-7,(1)
- March, 2016-3,(2)
- February, 2016-2,(3)
- December, 2015-12,(5)
- November, 2015-11,(5)
- September, 2015-9,(1)
- August, 2015-8,(2)
- July, 2015-7,(1)
- March, 2015-3,(2)
- February, 2015-2,(1)
- December, 2014-12,(4)
- July, 2014-7,(2)
- June, 2014-6,(2)
- May, 2014-5,(3)
- April, 2014-4,(3)
- March, 2014-3,(1)
- December, 2013-12,(2)
- November, 2013-11,(1)
- July, 2013-7,(1)
- June, 2013-6,(2)
- May, 2013-5,(1)
- March, 2013-3,(3)
- February, 2013-2,(3)
- January, 2013-1,(1)
- December, 2012-12,(3)
- November, 2012-11,(1)
- October, 2012-10,(1)
- September, 2012-9,(1)
- August, 2012-8,(1)
- July, 2012-7,(6)
- June, 2012-6,(1)
- April, 2012-4,(1)
- March, 2012-3,(3)
- February, 2012-2,(3)
- January, 2012-1,(4)
- December, 2011-12,(3)
- October, 2011-10,(3)
- September, 2011-9,(1)
- August, 2011-8,(10)
- July, 2011-7,(2)
- June, 2011-6,(7)
- March, 2011-3,(2)
- February, 2011-2,(3)
- January, 2011-1,(1)
- September, 2010-9,(1)
- August, 2010-8,(2)
- June, 2010-6,(1)
- May, 2010-5,(1)
- April, 2010-4,(3)
- March, 2010-3,(2)
- February, 2010-2,(3)
- January, 2010-1,(1)
- December, 2009-12,(3)
- November, 2009-11,(3)
- October, 2009-10,(2)
- September, 2009-9,(5)
- August, 2009-8,(3)
- July, 2009-7,(9)
- June, 2009-6,(2)
- May, 2009-5,(2)
- April, 2009-4,(9)
- March, 2009-3,(6)
- February, 2009-2,(4)
- January, 2009-1,(10)
- December, 2008-12,(5)
- November, 2008-11,(5)
- October, 2008-10,(13)
- September, 2008-9,(10)
- August, 2008-8,(7)
- July, 2008-7,(8)
- June, 2008-6,(12)
- May, 2008-5,(14)
- April, 2008-4,(12)
- March, 2008-3,(17)
- February, 2008-2,(10)
- January, 2008-1,(16)
- December, 2007-12,(6)
- November, 2007-11,(4)
|
|
|
| Visual Studio IIS Debug web project | 5/29/2023 12:44:58 PM |
| Sometimes the debugger won't launch.
Make sure visual studio started as an admin
Sometimes permissions are lost. elevated command prompt
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Aspnet_regiis.exe -ga domain\user
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files
|
| | IIS NT Authentication Stopped working | 2/19/2023 6:39:09 AM |
| Just an internally hosted web site, for use by members of my group on our domain. Been working for years, suddenly today it begins prompting for credentials and/or wouldn't load. Of course no changes, but there are always changes we can't control when you work in a big organization, group policy changes and patching being the biggest. This same server, also hosts SSRS and it was authenticating fine with windows / nt authentication, so we knew it wasn't a problem of the server. Ultimate credit goes to Ben Reese for helping solve this ! Ben sent me this so I could put it here as a place holder so we can remember the fix. Followed these steps:
https://success.outsystems.com/Support/Troubleshooting/Application_runtime/Issues_logging_in_with_Integrated_Authentication_in_Internet_Explorer_or_Edge
The solution for this is to disable the NEGOTIATE protocol in IIS,
so that NTLM is always use. In sporadic situations, or to confirm the problem,
you may want to disable NEGOTIATE in the client workstation.
- Access
IIS Manager;
- Expand
<server> Sites Default Web Site;
- In
the IIS group, choose Authentication;
- Click
Windows Authentication. On the side bar, option Providers shows up; if
not, first activate Windows Authentication so it does show up;
- Remove
NEGOTIATE provider.
- If
you added Windows Authentication on step 4, deactivate it again;
- Do
an IISReset
After
performing the steps above, authentication should start working in Internet
Explorer / Microsoft Edge.
I tried lowering the priority of “NEGOTIATE” provider first,
but that didn’t work unfortunately. Went ahead and removed it then tested
again… It’s working in Edge without a UN/PW! Chrome still prompts the first
time, but I maybe integrated security doesn’t work the same on Chrome ??
SSRS prompts for credentials in Chrome too if you haven’t authenticated
already.
And how I got there in case that was the wrong “fix” and
it needs to be undone: 

 |
| | Remove SMO - Parse for GO | 11/29/2022 7:25:14 AM |
|
SMO = SQL Management Objects.
GO is not a TSQL command, but is often used in many scripts, the client must parse for go and submit in batches.
SSMS = SQL Server Management Studio.
SSMS Does this automatically.
Take the same script and execute it via submitting the command to the DBMS (java, c#, powershell etc) and it will fail.
Generally, the solution for this is to implement SMO in the code.
Long term this has always been an issue as SMO libraries are a pain too install, upgrade, patch. As the years go by even upgrading projects in visual studio become difficult fighting the GAC and other .NET fun.
Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Finally, I just removed SMO from my project(s) and life is soo much easier.
Below is the REGEX Function I use to parse a command into the different statements based on the GO operator.
using System.Collections;
using System.Text.RegularExpressions;
using System.Collections.Generic;
using System.Collections.Specialized;
public static class SQLFunctions
{
public static ArrayList ParseForGo(String query)
{
// If 'GO' keyword is present, separate each subquery, so they can be run separately.
// Use Regex class, as we need a case insensitive match.
string separator = "GO";
Regex r = new Regex(string.Format(@"^\s*{0}\s*$", separator), RegexOptions.IgnoreCase | RegexOptions.Multiline);
MatchCollection mc = r.Matches(query);
ArrayList queries = new ArrayList();
int pos = 0;
foreach (Match m in mc)
{
string sub = query.Substring(pos, m.Index - pos).Trim();
if (sub.Length > 0) queries.Add(sub);
pos = m.Index + m.Length + 1;
}
if (pos < query.Length)
{
string finalQuery = query.Substring(pos).Trim();
if (finalQuery.Length > 0) queries.Add(finalQuery);
}
return queries;
}
} To call this: // If the user has selected text within the query window, just execute the
// selected text. Otherwise, execute the contents of the whole textbox.
string allquerytext = txtQuery.SelectedText.Length == 0 ? txtQuery.Text : txtQuery.SelectedText;
// if (query.Trim() == "") return;
// now parse for the go operatory
ArrayList queries = new ArrayList();
if (chkAdhocParseForGo.Checked)
{
queries = parseForGo(allquerytext);
}
else
{
queries.Add(allquerytext);
}
|
| | Honda CTX 700 2014 | 7/25/2022 10:52:38 AM |
| New to me ! Honda CTX 700 2014
|
| | SQL Server Management Studio MFA hanging not prompting | 7/12/2022 5:58:15 AM |
|
We have certain "zones" / "restrictions" that cause us too use a common "jump box" (server).
Sometimes SQL Server Management Studio SSMS hangs when using Multi Factor Authentication to access Azure SQL resources. The prompts for logging in never appear. ( Make sure the URL's for Microsoft are white listed).
This appeared to only affect some users.
Internet Explorer is "retired", but it appears that SSMS still uses some calls to IE underneath the hood to call MFA.
The team was able to find a workaround that users can
compete to clean up a bad cookie that seems to be the ultimate culprit. Details
on this fix are below:
Executing the below commands in a
Powershell window. – If you have never ran Internet explorer on the server
before, do that before running the command. E.g open IE and close it, the run
the below.
RunDll32.exe
InetCpl.cpl,ClearMyTracksByProcess 1
start-sleep
2
RunDll32.exe
InetCpl.cpl,ClearMyTracksByProcess 2
start-sleep
2
RunDll32.exe
InetCpl.cpl,ClearMyTracksByProcess 8
start-sleep
5
[Net.ServicePointManager]::SecurityProtocol
= [Net.SecurityProtocolType]::Tls12
Invoke-WebRequest https://login.microsoftonline.com
|
| | Postgres to SQL Quick Tips | 3/4/2022 7:23:55 AM |
| Very First make sure your working with a great Postgres DBA.
1. Convert the schema from Postgres to SQL Server 2. Install ODBC Drivers 3. Use SSIS or it's watered down cousin DTSWizard 4. If really necessary you can drop down to custom code to transfer data. 5. Edit the ProvidersDescriptors.xml 6. Out of Memory Reading tuples ? (add UseDeclareFetch=1 to connect string).
For data type compatibility https://www.convert-in.com/docs/mss2pgs/types-mapping.htm For: sql server odbc postgres column attribute colum_size is not valid providerdescriptors.xml MaximumLengthColumnName , NumericPrecisionColumnName , and NumericScaleColumnName attribute values to "LENGTH" , "PRECISION" , and "SCALE" , respectively.
The column attribute "COLUMN_SIZE" is not valid. The column attribute "DECIMAL_DIGITS" is not valid. The column attribute "COLUMN_SIZE" is not valid.
<dtm:ColumnSchemaAttributes
NameColumnName = "COLUMN_NAME"
OrdinalPositionColumnName="ORDINAL_POSITION"
DataTypeColumnName = "TYPE_NAME"
MaximumLengthColumnName = "COLUMN_SIZE"
NumericPrecisionColumnName = "COLUMN_SIZE"
NumericScaleColumnName = "DECIMAL_DIGITS"
NullableColumnName="NULLABLE"
NumberOfColumnRestrictions="4"
/>
... to ... <dtm:ColumnSchemaAttributes
NameColumnName = "COLUMN_NAME"
OrdinalPositionColumnName="ORDINAL_POSITION"
DataTypeColumnName = "TYPE_NAME"
MaximumLengthColumnName = "LENGTH"
NumericPrecisionColumnName = "PRECISION"
NumericScaleColumnName = "SCALE"
NullableColumnName="NULLABLE"
NumberOfColumnRestrictions="4"
/>
sql server postgresql out of memory while reading tuples
"Driver={PostgreSQL Unicode};Server=ip;Port=port;Database=db_name;Uid=user;Pwd=pass;UseDeclareFetch=1"
https://stackoverflow.com/questions/22532149/vba-and-postgresql-connection
|
| | Stored procedure can not return BIGINT | 11/2/2021 2:02:07 PM |
| SQL Server stored procedures can not return a big integer.
Table has identity value with primary key as big integer.
Stored procedure is running Return Scope_Identity() which works until the identity values exceeds the value of the implicit integer conversion, 2,147,483,646.
This is documented, but rarely run into.
The correct best practice is too use an output parameter for the stored procedure. This requires changing the procedure and calling code, which can be difficult if this happens in production environment during a busy period.
The temporary solution is too reset the identity value to a negative values, as the range of an integer, -2,147,483,646 to +2,147,483,646.
Watch when you do this, as checkident('tablename') will reset an identity value, so be sure to use noreseed as part of the command.
For monitoring purposes:
dbcc checkident ([table name],reseed,-2147483646) select max([column identity]),min([column identity]) from [table name] with (nolock) select count(*) from [table name] with (nolock) where [column identity] < 0
|
|
|