Zap Business Intelligence Installation
This walkthrough helps you to install Zap Business Intelligence. Some of you may need help knowing where to download the...
2014-03-26
955 reads
Introducing Microsoft Dynamics AX 2012 with SSRS Reports
Hi all, I’ve started a new job with eBECS which is a Microsoft Gold Partner in the ERP Business. Since...
2014-03-25
777 reads
What is Microsoft Management Reporter for Dynamics AX?
It is a collaborative and interactive reporting solution from Microsoft for finance data. View more here: Management Reporter 2012 Overview...
2014-03-25
750 reads
First take on PowerPivot
What is PowerPivot for Excel? PowerPivot brings the power of Data Modelling into your PC. Traditionally, the DataWarehouse is built...
2013-10-30
1,652 reads
Understanding the PIVOT function
The PIVOT function is very useful but not easily understood at first. I thank Itzik Ben-Gan, Dejan Sarka and Ron...
2013-10-25
3,082 reads
Get list of dates using recursive Common Table Expression (CTE)
Many times we need a list of consecutive dates or time at runtime mainly for a recursive ETL process. This...
2013-10-23
1,101 reads
MailChimp Database Synchronisation Process
After giving you the Top 10 Tips when synchronising your database with MailChimp, I thought why not write up the...
2013-10-17
1,143 reads
Top 10 Tips when synchronising your database and Mailchimp
Okay, sooner or later someone is going to need to synchronise all those people who registered on your company website...
2013-10-17
573 reads
Top 11 Qualities of a DataWarehouse Implementer
Top 11th Quality: Curious to explore different designs There are many ways to achieve the same thing. Before actually getting...
2013-10-14
524 reads
Building a simple forecast solution on SQL Server
Pricing Forecast is a marketing function that requires a lot of data crunching. Normally there are some factors that the...
2013-08-30
1,519 reads
Blogs
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Building a Docker image with Docker Build Cloud
In a previous blog post we went through how to build a Docker container...
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Forums
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
process records in loop
I'm only processing 50,000 records not everything from the Table where there are 250,00...
The Marked Transaction
Comments posted to this topic are about the item The Marked Transaction
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers