SQLServer 2008: Query joining SSAS data with a table of any other database using openquery


SQL Server SSAS linked serverSometimes we may need to make a report that should contain data from our sales cube, for example, and supplement it with missing data that can only be found in the source relational schema or directly from another data source..

eBook: The beginners guide to NoSQL

Tipo de recurso: 

Beginners guide to NoSQLTake advantage of noSQL by learning the basics and more with this FREE eBook offered by Robert Gordon University that includes:

  • An introduction to noSQL
  • The four different types of noSQL database that exist
  • The difference between SQL and noSQL and which to choose for your work     

Download white paper

How to recover the sa user password in Sql Server 2008


There are many ways to link it with our SqlServer database and one of them is to forget or not to have the user's password available to us. It may be because we never use it, because we have our own admin user and we really do not log in with that account. We may have inherited that wonderful database and we do not have any user or domain that is an administrator.

How to disable autocommit in SQL Server Management Studio


Disable autocommit on SQL Server Management Studio

Have you ever wondered how to disable autocommit in the Sql Server Management Studio?

Well the answer is quick. You can change it by activating the check in the menu..



Change in SQLServer the key column of a table to a new one of type integer that is identity using OVER


Relational scheme master detailAt some point it may be necessary to change the key column type for our table / s because of a poor design or a subsequent change that forces us to do so.

If we do and the new has to be a column of the integer type, maybe identity, we can do it with some criterion so that it is sorted ..


Update table statistics dynamically across an entire SQL Server database


In Oracle there is a table where all tables in the database (dba_tables) are listed and we can use it to perform maintenance operations dynamically. In Sql Server we can do the same by consulting the table [database].dbo.Sysobjects.

In the example below (as in others I've posted) I update the statistics of all tables in a Sql Server database dynamically by querying the data dictionary. This could be encapsulated in a stored procedure or directly executed in a job of the Agent of Sql Server to keep updated the statistics of all the tables of a database automatically..

Big Data Analytics guide

Tipo de recurso: 

Big Data AnalyticsIn this guide, you’ll learn how to extract Hunk to VM. We’ll also see how to set up Hunk variables and configuration files. You’ll learn how to run Hunk and how to set up the data provided and a virtual index for the CDR data.

You’ll also learn how to create a dashboard

Download white paper


How Digital Transformation is Redefining the Financial Industry

Tipo de recurso: 

Leaders Thrive on Data-Driven DecisionsIn this white paper, we will talk about the need for digital transformation in the banking and financial services space due to changes in customer needs, expectations and behavior, as well as digital disruptors and competitors that are succeeding in modernizing and disrupting the industry..

Download white paper


Free White Paper offered by Progress Software Corporation

Free report: Data Science and Business Intelligence Salaries and Skills

Tipo de recurso: 

Data Science and Business Intelligence earningsWhat you need to know to earn more in data science and business intelligence

What are the money-making skills you need to know to get ahead in ITs most valuable  industry?

Download this report to know who's hiring with the top salaries, and what they're looking for on your résumé

Download white paper


ShrinkDatabase of SQL Server may cause fragmentation and performance issues


ShrinkDatabase SQL ServerIn SQL Server you can use the DBCC SHRINKDATABASE command to reduce the space occupied by the data files and log of a database.

The problem with SHRINKDATABASE is that, contrary to what may seem, if not used carefully, the result can be a significant increase in the fragmentation of the indexes, and tables, which leads to a worsening of performance of our SQL Server, data and even an increased footprint when affected by fragmentation indexes are rebuilt...