Category: SSMS
-
Big Data / NoSql
MongoDB Tutorials Tutorial 1 (guru99) Terms Quick Reference show dbs – show all dababases show collections – show all collections in database. use [db name] – switch to the specific database. db.[collection].find() – find records in the collection. db.[collection].find({email:”[email protected]”}) – find specific value db.[collection].findOne() – find one record in the collection. db.[collection].findOne({email:”[email protected]”},{password:”12345″}) – find specific…
-
SQL SERVER – ENABLE QUERIES THAT REQUIRE TABLE RECREATION
At Sql Server Management studio sometime We run queries that changes table properties or structure. At this point We get an error message that says something like: “Please drop and recreate table…”. The solution for it is here:
-
Create and Map a Server Environment
https://msdn.microsoft.com/en-us/library/hh213230.aspx https://www.simple-talk.com/sql/ssis/ssis-2012-projects-deployment-configurations-and-monitoring/
-
How to automate cube processing with XMLA OR AMO
http://aniruddhathengadi.blogspot.co.il/2011/12/how-to-automate-cube-processing.html
-
BI SSRS / SSMS / SSAS / SSMS
BI SSRS / SSMS / SSAS / SSMS Password: nayabi2015 https://www.dropbox.com/sh/qjawz1tn033f2qn/AACgZP17vaBk4as_HwGBr4IIa?dl=0
-
Step by step of executing SSIS 2012 package through stored procedure
Step by step of executing SSIS 2012 package through stored procedure http://blogs.msdn.com/b/biblog/archive/2013/05/07/step-by-step-of-executing-ssis-2012-package-through-stored-procedure.aspx
-
How to find Object ID by name at SQL Server
How to find Object ID by name at SQL Server Example of how to find ID of tables at database according to tables name: SELECT * FROM sys.columns WHERE object_id = Object_id(’employees’)