Posts

Showing posts from October, 2018

Why Business Banking Customers Face Delays After Their Accounts Are Approved

Image
  The paperwork is complete. Compliance checks are done, and the relationship manager confirms that the account is ready. Yet, the business customers still cannot use all the banking services they need. Opening a bank account is only the first step for many businesses. They may also need access to ACH transfers, wire payments, treasury services, online banking, or business debit cards. These services often involve separate applications, departments, and approval steps. So, even after account approval, some services may still be pending. This delay frustrates customers and increases bank employees' workload . Account Approval Does Not Always Mean Business Readiness Business banking onboarding involves more than verifying documents and creating an account. Several activities may remain incomplete before a customer can use the services they requested. These may include: Setting up online banking and user access. Activating ACH and wire transfers. Setting up treasury management servic...

The most dangerous command in SQL

Image
Vijay is a SQL Server/Microsoft Data Platform professional with over 10 years of experience working in various fields such as financial, healthcare, and Manufacturing Domains. He has worked in various DB-related roles from database Modeler to database developer to Data Warehouse. The most dangerous command in SQL There’s one command, in particular, that has been effectively hidden since it was introduced pre-SQL Server 2000. I present to you  DBCC WRITEPAGE  – the most dangerous command you can use in SQL Server. Well, no danger of death  DBCC WRITEPAGE  allows you to alter any byte on any page in any database, as long as you have sysadmin privileges. It also allows you to completely circumvent the buffer pool, in other words, you can force page checksum failures. The purposes of  DBCC WRITEPAGE  are: To allow automated testing of  DBCC CHECKDB and repair by the SQL Server team. To engineer corruptions for demos and testing. To a...