Why Brackets in SQL queries with SQL Server

  1. The brackets are required if you use keywords or special chars in the column names or identifiers. You could name a column (with a space)–but then you’d need to use brackets every time you referred to that column.
  2. 155 more words

#0396 - SQL Server - SSIS - Move and rename a file - "Could not find part of the path." File System Task error

When working with disconnected sources or remote systems in SSIS, source data is often received in the form of files. A common requirement is to rename the file once the data import/processing is completed. 432 more words


SQLServer on Ubuntu Restore Tests

Just for fun I decided to test how portable backup files made on the Windows version of SQLServer restore into the Linux version of SQLServer.  I used the wizard built in to my SQL2016 SSMS software connected to the Linux version running on Ubuntu 16 on Amazon EC to run the restore.   156 more words

Database Administration

Creating schemas in SQL Server

Schema is a container or work area, that can store all the objects of database in SQL Server.

Schema is a collection of objects under a database principal. 118 more words


SQLServer Running On Ubuntu

So its official.  SQLServer does in fact install on linux and at first pass works.   I just spun up a Ubuntu 16 instance on Amazon EC.   2,461 more words

Database Administration

#0395 - SQL Server - SSIS - Adding date and time to a file name after processing

As we have been discussing over the last couple of weeks, moving data from a “source” to a “destination” is the crux of SSIS. The data source can be literally anything – a SQL Server  database, a web-service, a script, an XML or even a conventional delimited file. 643 more words


.Net Core on Mac: Connecting to SQLServer

In the previous post I described how I set the basic development environment using Visual Studio Code. You cannot do much application development without a database though, and while there are many options for database connectivity, since this exercise is  about using a Microsoft development stack on a Mac, the database of choice is inevitably Sqlserver. 323 more words