Background This is a difficult subject material. But, each one of us encounter problem areas in our lives. Videos Pastor John A. Kilpatrick Witches cast spells against 'wicked' Trump Profile Alabama pastor John A. Kilpatrick calls for prayer against witchcraft, for Trump Videos Video #1 Channel :- AL.com Published on :- 2018-August-22nd Link Fox … Continue reading Witchcraft & Governance
Background Reviewing a few SQL Statements and noticed some of them came across as prepared statements. Wanted to see if I will be able to understand them by converting them to plain generic SQL. SQL Sample SQL Here is a sample SQL Traditional SQL Here is a hand crafted comversion Azure Data Studio Extension I … Continue reading Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql”
Background This time last week, this little lady came out of the train, pointing at a young man running down the elevator. She was pointing him out saying he just took, he just stole my phone. I felt so bad for her. Hit a Lick To him, he just hit a lick. To her To … Continue reading Hit A Lick
Background Reviewing some SQL and wanted to point out a tiny dissimilarity between database platforms. Data Our test table is Oracle's SCOTT.EMP Here is what the data looks like :- Substring/Substr The HIREDATE is the only well formatted fixed length string. Its format is DD-MMM-YY. Query Oracle SQL Output Explanation Oracle relies on Substr to … Continue reading ANSI Standards – Database – Substring
Background Deployed a new SSIS package. It is time to test it out. But, really having problems. Error Error Text Error Image Troubleshooting Googled for help. Landed @ Title :- Deploying single SSIS package to SQL 2016 from SSDT 17.0-17.4 Description :- Deploying a single SSIS package with VB script task, targeted for SQL 2016 … Continue reading SSIS :- Exception – Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException
Background Needing to deploy SSIS packages on a new machine, noticed that the SQL Server Instance has yet to be provisioned with an Integration Services Catalog. Let us address fairly quickly. Outline Launch SQL Server Management Studio ( SSMS ) Connect to the SQL Server Instance Navigate to the Integration Services Catalog Create Catalog Right … Continue reading SSMS :- Integration Services Catalog – Create Catalog – Version Compatibility
Early this week I was watching a video on YouTube, and a small commercial came on. The young man was tying to sell financial training. The quote he used has stayed on me. It goes .... If you fight for your limitations, you get to keep them.