Windows PowerShell ISE
Editor for PowerShell script.
Author
Accounting Reconciliation
In accounting, reconciliation is the process of ensuring that two sets of records are in agreement. Reconciliation is used to ensure that the money leaving an account matches the actual money spent. This is done by making sure the balances match at the end of a particular accounting period.
Log was not truncated because records at the beginning of the log are pending replication or Change Data Capture
Issue: Log has grown to be very large and unable to trunk log file even after database and transaction log backup. Get the following error message when trying to truncate log. The log was not truncated because records at the beginning of the log are pending replication or Change Data Capture. Ensure the Log Reader... » read more
Deploy SSIS Packages using .ISPAC File
Copy .ISPAC file to the server. Click on the .ISPAC file on the server, this should bring up the Integration Services Deployment Wizard. Select packages and deployment server to deploy SSIS packages. Note .ISPAC file is generated in the bin\Development folder of Visual Studio project. SSIS Package deployment using .ISPAC file seems to be the... » read more
Server is not configured for remote access
Linked Server Error: Could not execute procedure on remote server ‘XXXX’ because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access. Fix: Make sure remote access is enabled on the database server and that the server has been restarted if the configuration changed. Also... » read more
Visual Studio 2022 Launch
https://visualstudio.microsoft.com/launch/
SQL Convert vs Cast
Convert vs Cast CAST and CONVERT are two SQL functions used by programmers to convert one data type to another. The CAST function is ANSI standard and is compatible to use in other databases while the CONVERT function is a specific function of the SQL server. Since the CAST function is compatible with other databases,... » read more
Sql Server Permission to View / Execute Sql Job
Open up “Login Properties” of the user. Go to “User Mapping” page and select “msdb” database. Add the following membership… SQLAgentUserRole SQLAgentReaderRole SQLAgentOperatorRole SQL Agent User Role: SQLAgentUserRole is the least privileged of the SQL Server Agent fixed database roles. It has permissions on only operators, local jobs, and job schedules. Members of SQLAgentUserRole have... » read more
Report Viewer Download
Microsoft Report Viewer 2015 Runtime https://www.microsoft.com/en-us/download/details.aspx?id=45496 Install Errors Microsoft System CLR Types for SQL Server 2014 is missing. Download Microsoft SQLSysCLRTypes from Official Microsoft Download Center
Inner Join vs Inner Remote Join when dealing with Linked Servers
Linked Server The bottom line is that linked servers are always slow. Try to run queries on the remote server or try to push data from the remote server. Also look for ways to replicate data from the remote server locally. Remote Join When you use the INNER REMOTE JOINÂ hint you are forcing the tables... » read more