SQLTutorials           P1Station
Powered By PhICK1.com            http://sqltutorials.blogspot.com/
SQL Server 2008 T-SQL Enhancements Part - II
Continuing with his series on changes in SQL Server 2008, Arshad Ali takes a look at table enhancements and new data types.
SQL Response SQL Server monitoring made easy
"Keeping an eye on our many SQL Server instances
is much easier with SQL Response." Mike Lile.
Download a free trial of SQL Response now.


Log Growing Pains
Understanding the transaction log seems to be a very difficult concept fro mos DBAs to grasp. Jason Brimhall brings us a new article that helps to troubleshoot the cause of log growths.

SQL Server Central launches online training for SQL Server Developers, DBA’s, and Analyst’s
Build your SQL Server skills without leaving your desk.

SQL Saturday #41 - Register and Call for Speakers
If you'll be near Atlanta on Apr 24, 2010, come to SQL Saturday #41. If you are at all interested in speaking, submit a session.

Kimball University: Three ETL Compromises to Avoid
Why neglecting slowly changing dimensions, failing to capture metadata and overlooking scope creep can be the undoing of a dimensional data warehousing initiative.

Is Your Database Application DeadLock and Timeout Resistent?
Is your application scalable under increased activity? Timothy Claason brings us a methodology for testing how your application will deal with database load.

Top Ten Reasons to Attend the 2010 PASS Community Summit
There are some good reasons to think about attending the 2010 PASS Community Summit.

Raw Materials - Robotic Resources
Derek is judged by a jury of his peers.
SQL Response SQL Server monitoring made easy
"Keeping an eye on our many SQL Server instances
is much easier with SQL Response." Mike Lile.
Download a free trial of SQL Response now.


Database Activity Monitoring Part 2 - SQL Injection Attacks
If you think through the web sites you visit on a daily basis the chances are that you will need to login to verify who you are. In most cases your username would be stored in a relational database along with all the other registered users on that web site. Hopefully your password will be encrypted and not stored in plain text.

How to use Database mail feature in SQL Server 2000
This article describes a way by which we could use the feature of database mail in SQL Server 2000 itself which is a lot easier than SQL Mail.

Immerse Yourself in Advanced SQL Server Knowledge with Paul S. Randal and Kimberly L. Tripp
A chance to dive deep into SQL Server with Paul Randal and Kimberly Tripp this Spring in Boston.

SQL Saturday #39 - New York City
Come to this great one day training event in New York, New York. SQL Saturday comes to the Big Apple and is a great way to get free training on all aspects of SQL Server.

Procedural, Semi-Procedural and Declarative Programming in SQL
A lot of the time, the key to making SQL databases perform well is to take a break from the keyboard and rethink the way of approaching the problem; and rethinking in terms of a set-based declarative approach. Joe takes a simple discussion abut a problem with a UDF to illustrate the point that ingrained procedural reflexes can often prevent us from seeing simpler set-based techniques.

Converting Access Queries with iff() and DLookup() to SQL Server
This article gives a description of the iff() and DLookup() functions in Access 2007, and a method to converting them to SQL.

TSQL Challenge 25 - Appointments and Recurring Schedules
The task is to look at the appointments and the recurrence of schedules to come up with a list of meetings for a given period.
SQL Response Too many SQL Servers to keep up with?
Download a free trial of SQL Response to monitor your
SQL Servers in just one intuitive interface."The monitoring
in SQL Response is excellent." Mike Towery.


Database Activity Monitoring Part 1 - An Introduction
We are inundated with new technologies and products designed to help make our organisations safe from hackers and other malcontents. One technology that has gained ground over the past few years is database activity monitoring. It makes sense to protect valuable databases, and by adding an intelligent monitor capable of sniffing out threats an additional level of protection can be gained. But what is database activity monitoring and why should you care?
SQL Response SQL Server monitoring made easy
"Keeping an eye on our many SQL Server instances
is much easier with SQL Response." Mike Lile.
Download a free trial of SQL Response now.


SQL Server 2008 T-SQL Enhancements Part - I
SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes.

Mnesia: A Distributed DBMS Rooted in Concurrency
Find out what makes Mnesia, the Erlang-based database management system, perfect for distribution across a network of computers.

Implementing User-Defined Hierarchies in SQL Server Analysis Services
To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on the database dimensions. Then you'll create the attribute relationships necessary to optimize performance. Analysis Services hierarchies offer plenty of possibilities for displaying the data that your business requires. Rob Sheldon continues his series on SQL Server Analysis Services 2008.

Calculating Moving Averages with T-SQL
How to efficiently calculate moving averages with SQL Server using Stock Market data.

Multiplatform ODBC support for SQLServer
The Microsoft SQL Server Connectivity team has a survey on the need for ODBC support for other platforms. If you use SQL Server from other platforms, let them know.

SQL Server DMVs in Action - Sample Chapter
Read the first chapter of this new book on DMVs.
SQL Response SQL Server monitoring made easy
"Keeping an eye on our many SQL Server instances
is much easier with SQL Response." Mike Lile.
Download a free trial of SQL Response now.


Using The Data Mining Query Task in SSIS
The Data Mining Query Task can be used to run prediction queries based on data mining models built in analysis service.

Fixing DBCC CHECKDB Msg 8992 Errors
Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.

A SQL Evening in London
Spend an evening with Itzik Ben-Gan, Greg Low, Davide Mauri and Bill Vaughn in London on March 16th. Come attend if you can.
SQL Backup Free trial of SQL Backup™
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.


Raw Materials - The Trojan Horse
Excuse me, was that geek or Greek?

SQL Saturday #33
A one day training event in the Charlotte, NC area. Come join MVPs from around the area at another great SQL Saturday.

Efficiently Reuse Gaps in an Identity Column
This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn't be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.

Decoupling in Relational Databases
The process of properly architecting databases via bridge tables

Master Data Services - SSIS MDM Load
The article will provide an overview of Master Data Services and a sample SSIS Package.

A High Level Comparison Between Oracle and SQL Server - Part III

Start-up and Configuration Parameters

When SQL Server is installed, a number of Windows registry keys are also created. These registry keys specify various parameters values required by the instance. For example, one registry key would specify the location of ... [Read Full Article]



A High Level Comparison Between Oracle and SQL Server - Part II

Database Instance Architecture

When an Oracle instance is created, it is nothing but a collection of some structured areas in the server’s memory and some background processes spawned to interact with it. Oracle literature quite extensively describes these memory ... [Read Full Article]



A High Level Comparison Between Oracle and SQL Server

Organisations often employ a number of database platforms in their information system architecture. It is not uncommon to see medium to large sized companies using three to four different RDBMS packages. Consequently the DBAs these companies look for often ... [Read Full Article]



SQL Server 2008 R2 Multi-server Administration - A First Look

One of the most useful new features of SQL 2008 R2 for DBA’s is the ability to manage and administer multiple instances of SQL Server from a central location using the new SQL Server Utility tool.

SQL Server ... [Read Full Article]



An overview of Master Data Services - MDS in SQL Server 2008 R2

The key new features of SQL Server 2008 R2 relate to the management of organizations’ master data (Master Data Services - MDS ), administration of multiple servers (SQL Server Utility), and processing large amounts of data (PowerPivot ... [Read Full Article]



Upgrade SSIS 2005 Packages to SSIS 2008

There are several enhancements in SSIS 2008 such as enhanced lookup transformation, the development environment for Script Task and Script Component changing from VSA to VSTA, etc. If you intend to upgrade your SSIS 2005 packages to SSIS 2008 ... [Read Full Article]



Copy Only Backups for Adhoc Backups
Introduction

In most organizations backup plans are implemented using full differential and transactional log backups. The normal scenario would be take a full backup on Sunday (off peak hours), differential backup daily at mid-night and transactional log backups on hourly basis.

What ... [Read Full Article]



ASP.NET 4.0 - New Features