Geeks With Blogs
SharePoint & SQL Thoughts April 2013 Entries
Let’s talk some T-SQL
So you have two tables that you want to compare to see what’s common between them and what’s not. Traditionally I have used JOINS to get what I need but did you know you can compare the two tables results simply by using the EXCEPT and INTERSECT syntaxes? Let’s look at these two beauties. EXCEPT – returns any distinct values from the left (sounds familiar LEFT JOIN) that are not found on the right query. Assuming that everyone has a master database that they can query, run the following queries to ......

Posted On Friday, April 19, 2013 4:03 PM

Database Encryption - Transparent Data Encryption (TDE) - how to
Some literature first If you are not, you should start considering database encryption for your organization as data is the only reason you are in business. If and when it becomes compromised bad things are bound to happen. When TDE is enabled or disabled for that matter a background process is initiated by the server that encrypts all the database files. This is an Enterprise or Developer version(s) only feature. How it works DDL is initiated (SELECT something FROM SOMEWHERE WHERE otherthing = 'athing') ......

Posted On Tuesday, April 16, 2013 11:05 AM

Copyright © Leonard Mwangi | Powered by: