I have a search being performed on a join. The two tables are A and B. A record always exists in A and has a 1 to 1 relationship with B. However not all records in A are forced ro have a record in B. So when I do the join some of the columns in B are showing as NULL.
Now the problem is that I am doing a wildcard search on oen of the columns in B such that if the wildcard is blank I would like this to come back as true but it seems to basically not do any checking against NULL values.
Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days.
Lets' understand the Au…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed