Microsoft SQL Server

Amazon Machine Images (AMI)

An Amazon Machine Image (AMI) provides the information required to launch an instance, which is a virtual server in the cloud. You must specify a …

Cloud Computing

Microsoft Sharpens SQL Operations Studio's Job Management Tools

Microsoft has released a new version of SQL Operations Studio, borrowing key features from SQL Server Management Studio (SSMS), including the ability …

Databases

Microsoft SQL Server 2008 Support Extended for Cloud Migrations

In a little less than a year, Microsoft will end support for SQL Server 2008 and 2008 R2. But businesses looking to eke a few more years out of their …

Databases

Any ETL tool suggestion to extract from Microsoft SQL Server

We need to extract data from Microsoft sql server, Transform into the consumable form i.e. Make it compatible to the model structure present …

SQL Servers

No permissions on SQL Server Data Folder

I am writing a custom install for a c# project. I start with a clean install of SQL Server 2012. Then I am using Visual Studio installer to copy a …

SQL Servers

TSQL CTE's (common table expression) bug

I'm working with Microsoft SQL Server 2008 (SP3) - 10.0.5520.0 (X64) Standard Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack …

SQL Servers

Export a Large SQL Database via Query

I am trying to export a database within Microsoft SQL Server Management Studio 2000. My database is extremely large with over 1,300 unique tables.<p>I …

Databases

how to connect azure database in sql server

I am trying to connect a database created in <b>Azure</b> but an error:Cannot open server '' requested by the login. Client with IP address 'x.x.x.x' is not …

SQL Servers

SSIS Error Code DTS_E_OLEDBERROR 0x80040E21 Invalid character value for cast specification

I am new to SSIS and just started experimenting. I am trying to figure out how to pass parameters from the ssis project to sql statement in the …

SQL Servers

Microsoft SQL Server Native Client 11.0 error '80040e14'

I am getting this error when running my asp page. I am using sql server 2012.Here is the full error:Microsoft SQL Server Native Client 11.0 error …

SQL Servers

Licensing Microsoft SQL Server in a VMware Cloud on AWS Environment

…. From Part I As enterprise IT teams, leadership and business owners continuously drive towards service improvements, they invariably look at the …

Virtualization

Update Dimension Table of Azure Data Warehouse in SSIS

is it possible to update a row of azure data warehouse table just like update rows of sql database in SSIS ? bcs when i put OLE DB Command and insert …

Databases

As technical decision makers look for ways to move their Microsoft applications to the cloud, they are faced with several providers to choose from. …

Amazon Web Services

Can I uninstall these Microsoft XXX windows programs and more?

I am just cleaning my pc. I had Visual Studio and Microsoft SQL Server installed. Now I want to remove them. But I'm not sure which programs Windows …

SQL Servers

Failed to open a fastload rowset/Communication Link Failure

i am running an SSIS package and I am getting this failure. I have tried multiple solutions such as deleting and recreating that task flow which does …

SQL Servers

Login Failed for user 'MicrosoftAccount\xxx'. (Microsoft SQL Server, Error:18456)

So I'm asking this question the nth time. That is because I didn't still came up with a solution from all the solutions out there.<p>My error log reads …

SQL Servers

triggering nodejs function from mssql table insert trigger

I want to setup a trigger on inserts that occur to a datbase table inside a Microsoft SQL Server environment.<p>What is the best method to have the …

SQL Servers

New form of banking malware leverages Microsoft SQL Server

Security researchers at IBM X-Force have uncovered a new form of banking malware that leverages a remote Microsoft SQL Server to communicate with …

SQL Servers

Banking RAT MnuBot leverages Microsoft SQL Server database to target Brazilians

A newly discovered banking malware that's been actively targeting Brazilians behaves as a remote access trojan (RAT) and uses a Microsoft SQL Server …

Malware

Atlas.Query

Provides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server backends connected via Atlas.Pdo.<p>Read the documentation …

Databases

How to debug 'Login failed for user' on an Azure SQL database?

Here's the error message that is stumping me:My Web App seems to have the correct connection string. This is exactly what Azure provides me when I …

Databases

SSIS locking table while updating it

I have an SSIS package which when runs, updates a table. It is using a staging table and subsequently, uses slowly changing dimension table to load …

SQL Servers

SQL Server Merge Replication Syntax Error

I'm getting an error in applying snapshot in a SQL Server merge replication as mentioned:<p>Message: The merge process was unable to deliver the …

Databases

SQL Server Management Studio Object Explorer - How to increase Font Size?

In SQL Server Management Studio Object Explorer - How to increase Font Size?<p>From the tool --> Options --> Fonts & Colors we can change fonts for many …

SQL Servers

Cannot create master key for master database in azure sql

i'm using Azure SQL. In Azure Portal, i was create 1 Azure SQL Server (with username login user01) and 2 Azure SQL Database (ExDatabase1 and …

Databases

This database cannot be imported - error keeps showing up

I have been trying to refresh my database data to see if my database works and I get this error:This database cannot be imported.it is either an …

SQL Servers

Using R - recommenderlab and can't get results into dataframe for Microsoft SQL Server

This is my first post here. I'm very much a newbie when it comes to R, so please keep that in mind. I'm building a recommender system (User Content …

SQL Servers

"unable to load package as XML..." in sql server agent

I want to schedule a SSIS Package which can read from an oracle source and transfer it into sql server. I build my SSIS package with "import and …

Databases

Django: Unable to connect to Microsoft SQL Server

I am unable to connect to the MS SQL server using Django (Version- 1.11.3)<p>Here is the error, I seem to be getting:<p>django.db.utils.OperationalError: …

Databases

How to execute *.sql file with python in SSMS

GOOD MORNING<p>I just have a question please is there apossibility to execute a .sql file with python in Microsoft Sql Server Management Studio ? If …

SQL Servers