Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

SQL Server management, tutorials, scripts, coding, programming and tips for database administrators

MS SQL

Microsoft Azure SQL Database Security - Firewall Configuration 04/07/2014

Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.

SQL Server 2014 In-Memory OLTP Dynamic Management Views 04/03/2014

Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and your Instances that support In-Memory OLTP tables.

Managing SQL Server Services with PowerShell 03/24/2014

PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Read on to learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets.

Windows Azure SQL Database - Uploading Data by Using the bcp Utility 03/10/2014

While using a custom SSIS-based project to upload content of an arbitrarily chosen table from an on-premise SQL Server database to Azure PaaS-based SQL Database provides the most flexibility its inherent complexity might not be justified in more simplistic scenarios. Marcin Policht presents an alternative approach that addresses this concern by employing the bcp utility, which not only eliminates the need for any custom development, but also rivals SSIS in terms of its data transfer efficiency.

Review Your BUCKET_COUNT Statistics with DMV 03/03/2014

Greg Larsen discusses the BUCKET_COUNT setting of a HASH index and how to determine how well SQL Server distributes the In-Memory table rows across multiple buckets of a HASH index, by exploring a new DMV, provided with SQL Server 2014, along with the In-Memory OLTP table functionality.

Getting Starting with Change Data Capture (CDC) in SQL Server – Part 2 02/20/2014

The Change Data Capture feature of SQL Server captures DML changes happening on a tracked table. Arshad Ali demonstrates how this feature can be leveraged.

Windows Azure SQL Database - Uploading Data by using SQL Server Integration Services 02/06/2014

Recently we presented a procedure for uploading data to a Windows Azure SQL Database from an on-premise SQL Server instance. Today we will accomplish the same objective by employing a more traditional approach to data extraction, transformation, and loading (ETL) that relies on SQL Server Integration Services (SSIS).

Natively Compiled Stored Procedures with SQL Server 2014 02/03/2014

With the new SQL Server 2014 In-Memory OLTP tables, stored procedures can be natively compiled and can improve performance. Read on to learn more.

Getting Starting with Change Data Capture (CDC) in SQL Server – Part 1 01/20/2014

Starting with SQL Server 2008, two different in-built mechanisms identify DML changes at the source table so that only changed data sets can be considered for data pulled from the source table to load into the data warehouse. These two in-built mechanisms are Change Data Capture (CDC) and Change Tracking (CT). Read on to learn more.

SQL Server 2014 Memory Optimization Advisor 01/06/2014

The new SQL Server 2014 “Memory Optimization Advisor” tool helps you quickly analyze tables to see how easy it is to migrate them to In-Memory OLTP tables. Read on to learn more.

Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files 01/02/2014

Marcin Policht shows you how to migrate on-premise data that is already cloud-compliant to Windows Azure SQL Databases by converting it into a BACPAC formatted file.

In-Memory OLTP Samples for SQL Server 2014 12/19/2013

On November 4th, Microsoft released a new set of samples targeted at In-Memory OTLP tables in SQL Server 2014. Now is the time to get a better understanding this new performance related feature that is coming out in the next release of SQL Server.

Migrating SQL Server Database to Windows Azure - Deploying SQL Database 12/12/2013

In recent articles we've been discussing the challenges associated with deployments of data services in Windows Azure, focusing in particular on SQL Database. Now it is time to turn our attention to an actual deployment and migration of locally stored data to SQL Database.

How to Use Microsoft's AMR Tool 12/05/2013

In order to help DBAs determine which tables and stored procedures might be good to take advantage of using the new In-Memory OLTP tables in SQL Server 2014, Microsoft introduced the AMR Utility. Greg Larsen explores how to use this tool.

Migrating SQL Server Database to Windows Azure - Resolving Incompatibility Issues 11/14/2013

Continuing a discussion focused on implementing data services in Windows Azure, we turn our attention to the remediation of incompatibilities, resulting from of limitations inherent to Platform as a Service (PaaS) based deployments, that need to be addressed as part of the migration process.

MS SQL Archives




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM