Digital B2B Marketing
JULY 17, 2013
'Over time, your role in marketing begins to permeate every part of your life. You adopt behavior, language or perspective that is completely natural to you, but doesn’t make sense to anyone around you. Just maybe, that means it is time to take a break. If more than a handful of these describe you, it is time to get to know, again, what the world beyond your marketing bubble is like.
BI Insight
JULY 23, 2013
First of all I want to explain the process of sending SSIS Logs through email for better understanding. As you might know you can save SSIS logs in several ways for administration purposes. In this article our focus is on how to send SSIS logs to the administrator whenever an event like a package failure … Continue reading How to send SSIS logs (errors) through email.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Elegant BI
JULY 31, 2013
Every business employee has heard the words, ‘empowerment’ and ‘accountability’. But, how can an employee be accountable for results without being empowered to make decisions? How can a company empower an employer to make decisions if employees don’t have accurate, timely, clear information with which to make these decisions? If your business is struggling with these issues, it’s important to understand the role business intelligence tools can play in solving your problems.
Digital B2B Marketing
JULY 11, 2013
'When the success of your business is less important than the success of your marketing, something is seriously wrong. Yet this is exactly how most B2B marketers approach lead generation today! You don’t care about the number of leads your sales team has. Instead you care about the number of marketing sourced leads. We all know B2B marketing measurement is imperfect, yet we momentarily suspend all reservations in order to judge our effectiveness based on results attributed to our efforts i
Advertisement
Whether your organization is at the start of its sustainability and impact journey or years into it, many brands share a common concern: the uncertainty of whether they are sending stakeholders mixed messages. Creating content that speaks to your audience's “love language” can be a tricky dance. But, worry not! 3BL has put together tips to ensure that your content not only finds its rhythm but also resonates with your target audiences.
Digital B2B Marketing
JULY 23, 2013
'What is a good ROI on marketing? If you can increase net income by 50 cents for every dollar spent on marketing, that’s good, right? The more you spend, the more money you make. But what if you learned your primary competitor was getting $1.50 in income for every dollar spent on marketing? 3x the return you are getting on marketing! All of a sudden your marketing looks pretty ineffective!
BI Insight
JULY 23, 2013
First of all you need to read my previous article called “How to send SSIS logs (errors) through email” as the processes are pretty the same. However, you need to create some changes in the Execute SQL Task (ref.: section “J” number 5 and 12 of “How to send SSIS logs (errors) through email”). As … Continue reading How to send more precise SSIS logs (errors) through email.
Competitive Intelligence Brief brings together the best content for intelligence professionals from the widest variety of industry thought leaders.
BI Insight
JULY 4, 2013
After downloading the SQL Server 2014, mount the media file downloaded and run “setup.exe” In SQL Server Installation Centre click on “Installation” Click on “New SQL Server stand-alone installation or add features to an existing installation” Note that if you have any of previous versions of SQL Server installed on your machine the setup process … Continue reading Installing SQL Server 2014 CTP1.
BI Insight
JULY 1, 2013
Reporting services 2012 integrated with SharePoint 2013 In this post I’m going to describe installing SSRS 2012 integrated mode with SharePoint 2013. As some guys are pretty new to SSRS 2012 or SharePoint or even SSRS integrated with SharePoint, I am explaining the situation from scratch. Requirements: SQL Server 2012 Enterprise (or Business Intelligence) edition … Continue reading Installing SQL Server Reporting Services (SSRS) 2012 integrated mode with SharePoint 2013.
Elegant BI
JULY 25, 2013
Tell us how BI has helped (or CAN help) with empowerment and accountability. Betsy says: How can an employee be accountable for results without being empowered to make decisions? How can a company empower an employer to make decisions if employees don’t have accurate, timely, clear information with which to make these decisions? This is a question many businesses are pondering.
BI Insight
JULY 23, 2013
First of all I want to explain the process of sending SSIS Logs through email for better understanding. As you might know you can save SSIS logs in several ways for administration purposes. In this article our focus is on how to send SSIS logs to the administrator whenever an event like a package failure … Continue reading How to send SSIS logs (errors) through email.
Advertisement
Leaders in competitive intel know that the employees who interact with customers and prospects every day hold valuable competitive insights that could help win sales. But they don’t have a good plan or system to gather, organize, and share these insights with the stakeholders who need them. In this eBook, we outline 7 strategies to make it easier to build and scale an employee sharing program that will drive competitive advantage.
BI Insight
JULY 23, 2013
First of all you need to read my previous article called “How to send SSIS logs (errors) through email” as the processes are pretty the same. However, you need to create some changes in the Execute SQL Task (ref.: section “J” number 5 and 12 of “How to send SSIS logs (errors) through email”). As … Continue reading How to send more precise SSIS logs (errors) through email.
BI Insight
JULY 20, 2013
There are some cases that you do not have any documentations for the database that you are working on and you need to investigate the entity relationships and so on. We can understand the database entity relationships better if we can find the number of references to the table or the number of tables’ dependencies. … Continue reading Count tables’ references and tables’ foreign keys.
BI Insight
JULY 20, 2013
There are some cases that you do not have any documentations for the database that you are working on and you need to investigate the entity relationships and so on. We can understand the database entity relationships better if we can find the number of references to the table or the number of tables’ dependencies. … Continue reading Count tables’ references and tables’ foreign keys.
Elegant BI
JULY 14, 2013
I Like Lists But I LOVE Business Intelligence Tools! I like lists! Lists keep me organized and help me get things done. What lists don’t do is to give me all the information I need to make the right decision, establish the right priority or the make right direction. That’s where business intelligence tools come in! With business intelligence tools and Corporate Performance Management solutions my team can effectively fulfill business obligations, and I can do my part to meet corporate objectives
Advertiser: ZoomInfo
Marketing technology is essential for B2B marketers to stay competitive in a rapidly changing digital landscape — and with 53% of marketers experiencing legacy technology issues and limitations, they’re researching innovations to expand and refine their technology stacks. To help practitioners keep up with the rapidly evolving martech landscape, this special report will discuss: How practitioners are integrating technologies and systems to encourage information-sharing between departments and pr
BI Insight
JULY 10, 2013
Sometimes you might feel you need to store the database diagrams in a file basis. I’ve faced to this feeling specially when I was testing some databases which were under development. I didn’t like to create the whole database diagrams that I’ve created before in a database that a new version of it is newly … Continue reading How to store a SQL Server database diagram into a file and share it with others?
BI Insight
JULY 8, 2013
SENSITIVE DATA! It’s an interesting topic! In this post I’m trying to explain how to hash data to increase security during ETL. Assume that we have sensitive data stored in several secured source systems. The source systems are located in different countries and different regions. As the source systems themselves are secured, how we can … Continue reading How to hash sensitive data for maximising security in SQL Server 2005 and later versions?
BI Insight
JULY 8, 2013
SENSITIVE DATA! It’s an interesting topic! In this post I’m trying to explain how to hash data to increase security during ETL. Assume that we have sensitive data stored in several secured source systems. The source systems are located in different countries and different regions. As the source systems themselves are secured, how we can … Continue reading How to hash sensitive data for maximising security in SQL Server 2005 and later versions?
BI Insight
JULY 7, 2013
First of all, I’d like to point to the fact that there is almost always a bottleneck with OLTP database’s performance that is related to disk speed. So in-memory processing can improve the current poor performance with disk-based tables significantly as well as achieving scalability. In a very simple and quick explanation, Hekaton is new … Continue reading What is Hekaton?
Advertisement
ChatGPT has dominated boardroom conversations for months now. From drafting a stock trading program, to creating a SQL query to model data, there are practically no limits to the applications of the AI language model assistant. At ManageEngine, we have been working on our own AI-assistant, Zia. Zia is a fully-trained analytics assistant that can perform a range of functions such as creating and adding reports to dashboards, providing conversational support to data analysis, insight discovery, bu
BI Insight
JULY 4, 2013
What does it actually mean that the database doesn’t have a database owner?! It seems odd, but, it is possible. In some cases that the database is created by an application it really happens that the database doesn’t have any database owner. For instance, the databases generated by CRM Deployment Manager doesn’t have database owner. … Continue reading How to define database owner SQL server wide.
BI Insight
JULY 4, 2013
What does it actually mean that the database doesn’t have a database owner?! It seems odd, but, it is possible. In some cases that the database is created by an application it really happens that the database doesn’t have any database owner. For instance, the databases generated by CRM Deployment Manager doesn’t have database owner. … Continue reading How to define database owner SQL server wide.
BI Insight
JULY 4, 2013
After downloading the SQL Server 2014, mount the media file downloaded and run “setup.exe” In SQL Server Installation Centre click on “Installation” Click on “New SQL Server stand-alone installation or add features to an existing installation” Note that if you have any of previous versions of SQL Server installed on your machine the setup process … Continue reading Installing SQL Server 2014 CTP1.
BI Insight
JULY 3, 2013
There are some cases that we need to drop all tables database wide. For example when we have a test database and we need to delete all tables from the database and recreate some other tables for testing we need to drop each table manually using the GUI. Assume we have 50 tables in the … Continue reading How to drop tables database wide using T-SQL.
Speaker: Marius Moscovici, CEO Metric Insights & Mike Smitheman, VP Metric Insights
While the proper governance of data is clearly critical to the success of any business intelligence organization, focusing on data governance alone is a huge mistake. Organizations continually fail to generate ROI on their governance initiatives because they are too narrow in scope. To be effective, Business Intelligence (BI) governance must cover both data and visualizations.
BI Insight
JULY 3, 2013
In my previous post called “How to drop tables database wide using T-SQL” I’ve explained that how we could delete all tables database wide in SQL Server. But, what if there are some other schemas other than “dbo” and some tables that are created in those schemas? If we just delete “[dbo].” from the code … Continue reading Drop tables from selected schemas database wide.
BI Insight
JULY 4, 2013
SQL server 2014 Community Technology Preview 1 (CTP1) is ready to download here: [link] Key Features Project code-named “Hekaton” One of the most exciting features in this version is a project code-named “Hekaton” that provides in-memory OLTP capabilities. As Hekaton is built into core SQL Server database it will improve the performance of the database … Continue reading Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1) is ready to download.
BI Insight
JULY 3, 2013
There are some cases that we need to drop all tables database wide. For example when we have a test database and we need to delete all tables from the database and recreate some other tables for testing we need to drop each table manually using the GUI. Assume we have 50 tables in the … Continue reading How to drop tables database wide using T-SQL.
BI Insight
JULY 3, 2013
In my previous post called “How to drop tables database wide using T-SQL” I’ve explained that how we could delete all tables database wide in SQL Server. But, what if there are some other schemas other than “dbo” and some tables that are created in those schemas? If we just delete “[dbo].” from the code … Continue reading Drop tables from selected schemas database wide.
Advertisement
Navigating the waters of sustainability reporting disclosures and regulations can be intimidating, to say the least. With various measures set in motion in 2023 to keep companies accountable, there is a lot in store for brands’ impact communication in the upcoming year. 3BL is kicking off this January with our Navigating ESG Comms Through the Cosmos - Capricorn Edition by highlighting the impact of: The U.S Securities and Exchange Commission (SEC) Climate disclosure rules The European Commission
BI Insight
JULY 4, 2013
SQL server 2014 Community Technology Preview 1 (CTP1) is ready to download here: [link] Key Features Project code-named “Hekaton” One of the most exciting features in this version is a project code-named “Hekaton” that provides in-memory OLTP capabilities. As Hekaton is built into core SQL Server database it will improve the performance of the database … Continue reading Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1) is ready to download.
BI Insight
JULY 1, 2013
SSAS 2012 supports three different approaches for creating a BISM (Business Intelligence Semantic Model): 1. Tabular a. Uses relational modelling constructs like such as tables and relationships b. Uses xVelocity in-memory analytics engine for sorting and data calculations c. Needs to use SSDT (SQL Server Data Tools) to implement d. Can import data from relational … Continue reading Three different approaches for creating a BISM in SSAS 2012, Tabular vs.
BI Insight
JULY 1, 2013
Reporting services 2012 integrated with SharePoint 2013 In this post I’m going to describe installing SSRS 2012 integrated mode with SharePoint 2013. As some guys are pretty new to SSRS 2012 or SharePoint or even SSRS integrated with SharePoint, I am explaining the situation from scratch. Requirements: SQL Server 2012 Enterprise (or Business Intelligence) … Continue reading Installing SQL Server Reporting Services (SSRS) 2012 integrated mode with SharePoint 2013.
BI Insight
JULY 1, 2013
SSAS 2012 supports three different approaches for creating a BISM (Business Intelligence Semantic Model): 1. Tabular a. Uses relational modelling constructs like such as tables and relationships b. Uses xVelocity in-memory analytics engine for sorting and data calculations c. Needs to use SSDT (SQL Server Data Tools) to implement d. Can import data from relational … Continue reading Three different approaches for creating a BISM in SSAS 2012, Tabular vs.
Advertisement
Temperatures are rising (and not just metaphorically) as key stakeholders anxiously anticipate the outcomes of COP28. While companies reconsider their 2024 environmental sustainability strategies, there is another aspect of ESG that deserves exploring, the social sector. In the latest edition of "Navigating ESG Comms Through the Cosmos - Sagittarius Edition", 3BL hones in on this sign’s bold quality of asking questions others are burning to know the answers to.
Expert insights. Personalized for you.
90 
Let's personalize your content