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.
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.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
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 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?
Speaker: Jay Allardyce, Deepak Vittal, and Terrence Sheflin
As we look ahead to 2025, business intelligence and data analytics are set to play pivotal roles in shaping success. Organizations are already starting to face a host of transformative trends as the year comes to a close, including the integration of AI in data analytics, an increased emphasis on real-time data insights, and the growing importance of user experience in BI solutions.
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.
Competitive Intelligence Brief brings together the best content for intelligence professionals from the widest variety of industry thought leaders.
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.
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.
Advertisement
In a world where uncertainty and change are constant, scenario planning empowers companies with the agility and competitive edge needed to thrive. Download the toolkit to fortify your business strategy , set up your competitive positioning , and ensure your company is poised to respond to any future scenario.
.jpg)
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
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?
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.
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?
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.
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 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.
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.
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 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.
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.
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
Expert insights. Personalized for you.
52 
Let's personalize your content