search

searching on site content

1 

Article - 25 Feb 2018

How to truncate and save truncated data simultaneously

Δεν είναι λίγες οι φορές που χρειάζεται να σβήσεις όλα τα δεδομένα από ένα table αλλά πριν το κάνεις αυτό χρειάζεται να τα φυλάξεις κάπου αλλού για διάφορους λόγους


Article - 21 Oct 2016

Move a database file (data or log file) to another location

Αρκετές φορές έχω ερωτηθεί για το πώς μπορεί κάποιος να μεταφέρει μια βάση ή ένα αρχείο της (data / log file) από ένα σημείο (disk/folder/…) σε άλλο.


Article - 22 Apr 2014

In-Memory OLTP – Common Workload Patterns and Migration Considerations - White paper

In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures. For performance critical workloads, users can also migrate Transact-SQL code to natively compiled stored procedures. This can provide additional performance gains. This paper aims to help readers understand some of the common architectural patterns where In-Memory OLTP has provided significant benefits. The paper also discusses considerations for migrating applications to In-Memory OLTP


Book - 01 Jan 2000

SQL Server 2012 Data Integration Recipes

SQL Server Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more. What DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server Data Integration Recipes is the one book that will meet your needs.


Book - 01 Jan 2000

Beginning SQL Server 2012 for Developers

Beginning SQL Server 2012 for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft’s market-leading database system for the Windows platform. Now in its third edition, the book is enhanced to cover the very latest developments in SQL Server 2012. Also new in the book is coverage of the no-cost Express Edition. Whether you have no knowledge of databases, or have knowledge of desktop databases such as Microsoft Access, or even come from another brand such as Oracle Database, Beginning SQL Server 2012 for Developers provides the insights to get up and running with SQL Server 2012. Within the book, there are plenty of examples of tasks that developers routinely perform. You’ll learn to create tables and indexes, and best practices for securing your valuable data. You’ll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code. Beginning SQL Server 2012 for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you’ll be able to design and create solid and reliable database solutions using SQL Server 2012.


1 
Follow us in
PASS chapter logo

The Official PASS Local Group for Greece

Subscription

If you want to receive updates from us subscribe below with your email.
sql school greece logo
© 2010-2020 All rights reserved