Additional Articles

Using SQL SERVER and Cloud Hosted Databases with OBIEE 11g

by Additional Articles

SimpleTalk

Business Intelligence (BI)

If your organisation is committed to using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g /12c as their BI solution, you aren't thereby committed to using Oracle throughout your organisation. You can use a range of data sources including SQL Server, and save a great deal of money by doing so. Sadly, Oracle will only support the use of the venerable SQL Server 2008 R2. Zafar Ali demonstrates how to connect OBIEE to the world beyond Oracle.

2017-02-24

4,245 reads

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

by Additional Articles

SimpleTalk

Performance

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.

2017-02-23

8,502 reads

Questions About the Use of PowerShell That you were Too Shy to Ask

by Additional Articles

SimpleTalk

PowerShell

Let's forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did it come from? Why did it take so long to arrive? These and many other basic questions are answered in William Brewer's latest addition to the series that answers those seemingly simple questions that you were too shy to ask in public.

2017-02-22

7,518 reads

Getting Started with Azure SQL Data Warehouse - Part 1

by Additional Articles

Database Journal

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

As the demand for data analytics grows so does the need for a technology or platform to process large amounts of different types of data in timely manner. Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just a few minutes. Read on to learn more about this data warehouse-as-a-service offering from Microsoft.

2017-02-21

5,158 reads

New CREATE OR ALTER statement in SQL Server 2016 SP1

by Additional Articles

MSSQLTips.com

SQL Server 2016

Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.

2017-02-20

5,523 reads

Introduction to SAP HANA on Azure

by Additional Articles

Database Journal

SAP HANA

Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, this trend has been exemplified by advancements in support for SAP-based solutions on Microsoft Azure. Marcin Policht provides an overview, focusing in particular on support for SAP HANA on Azure.

2017-02-17

4,185 reads

Lists With, or Without, Ranges in both T-SQL and PowerShell

by Additional Articles

SimpleTalk

PowerShell

Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.

2017-02-16

4,920 reads

Compression and its Effects on Performance

by Additional Articles

SQLPerformance.com

Compression

Erin Stellato takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.

2017-02-15

6,456 reads

Office Hours Webcast 2017/02/01

by Additional Articles

Brent Ozar Blog

always on

In this edition of Office Hours, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, their favourite high availability solutions, and more.

2017-02-14

3,764 reads

How to Build Your First SQL Server Virtual Lab in Windows Azure

by Additional Articles

SimpleTalk

Azure

If you are a DBA who hasn't so far dived in head-first into using Azure, it is worth setting up an Azure 'Virtual Lab' environment the easy way, using a template. This will then allow you to experiment, try things out with SQL Azure, and get familiar with Resource Groups. Joshua shows how to build a virtual lab, from the ground up in the first of a series that aims to give you a grounding in Azure.

2017-02-13

5,534 reads

All authors

Additional Articles

Using SQL SERVER and Cloud Hosted Databases with OBIEE 11g

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Questions About the Use of PowerShell That you were Too Shy to Ask

Getting Started with Azure SQL Data Warehouse - Part 1

New CREATE OR ALTER statement in SQL Server 2016 SP1

Introduction to SAP HANA on Azure

Lists With, or Without, Ranges in both T-SQL and PowerShell

Compression and its Effects on Performance

Office Hours Webcast 2017/02/01

How to Build Your First SQL Server Virtual Lab in Windows Azure

Blogs

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

Future IT Roles – Agentic Architect and AI Boom!!

Free Webinar about Columnstore Indexes

Forums

BCA KCP Elang Laut TLP/WA 08216977749

BCA KCP Ricci TLP/WA 08218573837

BCA KCP Arundina Cibubur Hub.0821•3111•185

Question of the Day

SSoL Support on the OS