Sat.Jun 29, 2013 - Fri.Jul 05, 2013

article thumbnail

Installing SQL Server 2014 CTP1

BI Insight

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.

52
article thumbnail

Business Intelligence Tool for Lower Cost & Higher Revenue

Elegant BI

Business Intelligence Tool for Lower Cost & Higher Revenue. I hate to burst your bubble, but business is becoming more complex every day. Adding to the problem of managing your business is the fact that you probably expect your staff to fully understand corporate goals and objectives and manage their own department, division, team or role to achieve those goals.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

LinkedIn Sponsored Updates: The Best B2B Social Advertising Option Yet?

Digital B2B Marketing

'Have you felt like social advertising just wasn’t right for your B2B marketing? If so, LinkedIn’s new Sponsored Updates may just change your mind. This looks like the most compelling social advertising offering yet for B2B marketers. Up until now, advertising on LinkedIn was just advertising. With great targeting options, LinkedIn was compelling, but advertising opportunities didn’t fit the increasingly social framework of LinkedIn.

article thumbnail

Installing SQL Server Reporting Services (SSRS) 2012 integrated mode with SharePoint 2013

BI Insight

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.

article thumbnail

Are Your Impact Comms Resonating With Stakeholders?

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.

article thumbnail

How to define database owner SQL server wide

BI Insight

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.

More Trending

article thumbnail

Installing SQL Server 2014 CTP1

BI Insight

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.

40
article thumbnail

How to drop tables database wide using T-SQL

BI Insight

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.

40
article thumbnail

Drop tables from selected schemas database wide

BI Insight

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.

40
article thumbnail

Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1) is ready to download

BI Insight

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.

article thumbnail

7 Strategies to Gather (and Actually Use) Competitive Intel from Employees

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.

article thumbnail

How to drop tables database wide using T-SQL

BI Insight

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.

40
article thumbnail

Drop tables from selected schemas database wide

BI Insight

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.

40
article thumbnail

Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1) is ready to download

BI Insight

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.

article thumbnail

Three different approaches for creating a BISM in SSAS 2012, Tabular vs. Multidimensional vs. PowerPivot

BI Insight

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.

article thumbnail

How to Stay Competitive in the Evolving State of Martech

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

article thumbnail

Installing SQL Server Reporting Services (SSRS) 2012 integrated mode with SharePoint 2013

BI Insight

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.

article thumbnail

Three different approaches for creating a BISM in SSAS 2012, Tabular vs. Multidimensional vs. PowerPivot

BI Insight

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.

article thumbnail

Business Intelligence Tools Leave Reporting Software in the Dust!

Elegant BI

Business Intelligence Tools Leave Reporting Software in the Dust! Report writers and tools were cutting-edge twenty years ago. Today, they fall woefully short of what we need. Reporting software may seem low cost, and it may offer pretty templates but it isn’t getting it done. This software was designed for report analysts or IT pros and consultants.