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

Management of Windows Azure SQL Databases via PowerShell with REST APIs 08/07/2014

Management of Azure SQL Databases has been greatly simplified by the introduction of the Azure PowerShell module. Marcin Policht describes the principles of dealing with the Azure PowerShell module’s REST APIs directly.

Automating SQL Server Agent Notification 08/04/2014

If you are a DBA you probably are responsible for running and monitoring all of the SQL Server Agent jobs on one or more SQL Server instances. Read on to learn some automated approaches of monitoring SQL Server agent jobs.

Getting Started with Hashing in SQL Server 07/24/2014

Encryption brings data into a state which cannot be interpreted by anyone who does not have access to the decryption key, password, or certificates. Hashing brings a string of characters of arbitrary size into a usually shorter fixed-length value or key. Read on to learn about hashing in SQL Server and how it is different from encryption.

Using PowerShell to Manage Windows Azure SQL Databases 07/07/2014

Marcin Policht provides a comprehensive overview of Windows PowerShell’s capabilities in regard to managing SQL Databases (or, in general, cloud-resident resources).

Traits of a DBA - Part Two – The Personal Side of a DBA 07/03/2014

A good DBA needs to have good technical skills but he also has to have good personal skills. In this article, Greg Larsen discusses the personal skills a DBA should have.

Granular or Cell Level Encryption in SQL Server 06/23/2014

Arshad Ali demonstrates granular level encryption in detail and explains how it differs from Transparent Data Encryption (TDE).

Introduction to SQL Server in Microsoft Azure 06/09/2014

The convenience, competitive pricing, resiliency, and ease of maintenance of the SQL Database Platform as a Service (PaaS) offering hosted on the Microsoft Azure platform are partially offset by a lack of support for some of the features available in full-fledged editions of the SQL Server. Fortunately, these limitations can be eliminated by taking advantage of the Microsoft Azure Infrastructure as a Service (IaaS) capabilities and installing a SQL Server instance in an Azure-hosted virtual machine (VM).

Traits of a DBA - Part One – The Technical Side 06/02/2014

What does it take to become a database administrator, or what kinds of traits should I be looking for when I am hiring a DBA. Those traits can be summarized it two categories: Technical and Personal. In this article, Greg Larsen discusses the technical traits a DBA should have.

Transparent Data Encryption (TDE) in SQL Server 05/19/2014

There are several ways to implement encryption in SQL Server; Arshad Ali focuses on Transparent Data Encryption (TDE), which was introduced in SQL Server 2008 and is available in later releases.

Restricting IO Using SQL Server 2014 Resource Governor 05/05/2014

With the introduction of SQL Server 2014 the Microsoft team has enhanced the Resource Governor to now cover I/O. With this new version you are now able to throttle your I/O intensive processes, should you need to. Greg Larsen shows you how to setup Resource Governor to limit the resources for those large I/O operations.

Microsoft Azure SQL Database Security - Authentication, Authorization, and Encryption 05/01/2014

Continuing the overview of securing Microsoft Azure-based SQL Database deployments, we will now explore authentication and authorization, as well as data integrity and confidentiality.

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.

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