I am trying to write a select statement that joins two tables from different databases on my SQL server. The issue is that the two databases are different collation types. DataBaseA is collation ...

The Microsoft Source Code Analyzer for SQL Injection tool is a static code analysis tool, built on the .NET Framework version 3.0, which analyzes your ASP code for SQL injection vulnerabilities ...

Friends,I'm trying to write a select statement that ends like this:and sc.customer_name in (DECODE(shipto,'0',sc.customer_name,shipto));The trouble is that shipto contains a comma delimted list. I ...

Denny's SQL Secrets Finding Storage Performance Problems in SQL Server The first step is to understand the nature of performance monitoring software. By Denny Cherry 09/08/2014 ...

Today's DBA is the Sherlock Holmes of IT - always in demand to solve performance mysteries. But even Sherlock needed Watson to do the footwork for him. In the same way, DBAs need smarter tools to keep ...

These regressions affecting SQL Server were delivered in the July 10 patches to Windows 7, Windows 8.1 and various Windows 10 versions (1803, 1709, 1703 and 1607). Also affected were Windows Server ...