aartemiou.blogspot.com
The SQL Server and .NET Blog: Where are Programmability Objects Stored in SQL Server?
http://aartemiou.blogspot.com/2013/11/where-are-programmability-objects.html
The SQL Server and .NET Blog. Thursday, November 21, 2013. Where are Programmability Objects Stored in SQL Server? SQL Server programmability objects such as stored procedures, functions, assemblies, etc. are widely used, especially in cases of a major database design where you want to have a well-structured database with code reuse and performance. Even though many of us use these programmability features, we do not often think of where these objects are stored. The first catalog is " sys.objects. IF = ...
aartemiou.blogspot.com
The SQL Server and .NET Blog: Handling NULL Character \x00 when Exporting to File Using BCP
http://aartemiou.blogspot.com/2015/03/handling-null-character-x00-when.html
The SQL Server and .NET Blog. Thursday, March 5, 2015. Handling NULL Character x00 when Exporting to File Using BCP. This article discusses the behavior of the BCP utility. When extracting data from SQL Server to files and more specifically to CSV files. Imagine that you have the below table:. As you can see, records 2 and 3 contain null values. Then you export the table contents to CSV using BPC:. Now consider that the original table, instead of NULL values has empty strings. We read the following:.
aartemiou.blogspot.com
The SQL Server and .NET Blog: CY Hackathon Nov 29-30 2014: A Short Review
http://aartemiou.blogspot.com/2014/12/cy-hackathon-nov-29-30-2014-short-review.html
The SQL Server and .NET Blog. Monday, December 1, 2014. CY Hackathon Nov 29-30 2014: A Short Review. On the weekend of Nov 29-30, Windows Hackathon. Took place in Cyprus. The contestants had almost two days to develop a universal application for Windows Store and Windows Phone. They were given an open data API that they had to use. Beyond that, everything was up to their imagination which as their presentations proved, it has no limits! Once again congratulations to all participants as well as to the Com...
aartemiou.blogspot.com
The SQL Server and .NET Blog: Transferring Ownership of All Database Objects Back to DBO
http://aartemiou.blogspot.com/2015/05/transferring-ownership-of-all-database.html
The SQL Server and .NET Blog. Monday, May 4, 2015. Transferring Ownership of All Database Objects Back to DBO. Consider the following scenario: You created a Window or SQL login in SQL Server and in the user mapping along with assigning a database role membership, you assigned as default schema something different than the “dbo”. Take as an example the following screenshot:. As you can see, the SQL login “ testLogin. If you still want to remove the login don’t lose hope, there is a way! And maybe any oth...
aartemiou.blogspot.com
The SQL Server and .NET Blog: How to Import and Export Unstructured Data in SQL Server - FILESTREAM
http://aartemiou.blogspot.com/2014/02/how-to-import-and-export-unstructured.html
The SQL Server and .NET Blog. Friday, February 28, 2014. How to Import and Export Unstructured Data in SQL Server - FILESTREAM. A few weeks ago I posted an article. On how to import and export unstructured data in SQL Server 2005 by using the "image" data type. In this article I will show how you can manipulate unstructured data in SQL Server 2008 or later by using the FILESTREAM. Step 1: Enabling FILESTREAM. And under SQL Server Services. 8221; and “ Enable FILESTREAM for file I/O access. For creating a...
aartemiou.blogspot.com
The SQL Server and .NET Blog: How to Import and Export Unstructured Data in SQL Server - FileTables: The Movie!
http://aartemiou.blogspot.com/2014/12/how-to-import-and-export-unstructured.html
The SQL Server and .NET Blog. Friday, December 12, 2014. How to Import and Export Unstructured Data in SQL Server - FileTables: The Movie! A few weeks ago I was contacted by Webucator. An online training provider that requested my permission to include one of my articles into a free video-training series. Called " SQL Server Solutions from the Web. This is one of my articles on FileTables with title: “ How to Import and Export Unstructured Data in SQL Server – FileTables. BSc, M.Sc., Senior SQL S...Featu...
bmijuskovic.blogspot.com
mixbig: Microsoft Momentum 2009
http://bmijuskovic.blogspot.com/2009/12/microsoft-momentum-2009.html
Thursday, December 10, 2009. Last month there was an MS event going on in Cyprus, Momentum 2009. Being different from previous events, this one seemed to me as the best until now. If nothing else but because of the venue where the event took place. Usual MS events in Cyprus are 'played' at the hotel conference rooms while this year's Momentum had a full-size Hall within the Cyprus State Fair exhibition area. Professionalism was on their side this time. Has more details about the event and his session here.
aartemiou.blogspot.com
The SQL Server and .NET Blog: New Artemiou Data Tools Release: SQL Multi-Exporter
http://aartemiou.blogspot.com/2014/06/new-artemiou-data-tools-release-sql.html
The SQL Server and .NET Blog. Monday, June 30, 2014. New Artemiou Data Tools Release: SQL Multi-Exporter. Today I released a brand new data tool via my " Artemiou Data Tools. Initiative. The tool is called SQL Multi-Exporter. SQL Multi-Exporter allows the user to connect to a SQL Server instance and by issuing a query against a database, to export the results to an XML, CSV or HTML file with a single click. SQL Multi-Exporter (Community Edition) Main Screen. Export to XML file. Labels: .NET Tools. Featur...
aartemiou.blogspot.com
The SQL Server and .NET Blog: T-SQL Tip: How to Create a Simple Linked Server Between SQL Server Instances
http://aartemiou.blogspot.com/2012/09/t-sql-tip-how-to-create-simple-linked.html
The SQL Server and .NET Blog. Friday, September 14, 2012. T-SQL Tip: How to Create a Simple Linked Server Between SQL Server Instances. The Entire Operation Takes Place on the Local Instance. Create the linked server object. EXEC master.dbo.sp addlinkedserver. Server = N'[LinkedServerName]',. Set up the user mapping between local and remote instances. EXEC master.dbo.sp addlinkedsrvlogin. Useself=N'False',@locallogin=N'[LocalLogin SQL or Windows]',. Rmtuser=N'[Remote SQL Login Name]',. The SQL Server and...
aartemiou.blogspot.com
The SQL Server and .NET Blog: How to Import and Export Unstructured Data in SQL Server - The IMAGE Datatype
http://aartemiou.blogspot.com/2014/01/how-to-import-and-export-unstructured.html
The SQL Server and .NET Blog. Thursday, January 30, 2014. How to Import and Export Unstructured Data in SQL Server - The IMAGE Datatype. Importing and exporting unstructured data from a database is a common practice, especially in large applications. SQL Server 2008 introduced the FILESTREAM. Feature that allows storing unstructured data (i.e. music, video, documents, etc.) onto the NTFS file system and manipulating it via the Database Engine. SQL Server 2012 introduced FileTables. VALUES ('SampleTextFil...
SOCIAL ENGAGEMENT