Databases
eBook: The beginners guide to NoSQL
Submitted by carlos on 1 December, 2016 - 14:34Take 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
SQLServer 2008: Query joining SSAS data with a table of any other database using openquery
Submitted by Dataprix on 1 December, 2016 - 11:34Sometimes 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..
How to recover the sa user password in Sql Server 2008
Submitted by il_masacratore on 25 November, 2016 - 13:57There 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
Submitted by il_masacratore on 22 November, 2016 - 09:31Have 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
Submitted by il_masacratore on 21 November, 2016 - 12:58At 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 ..
