SQL Server

TwitterFacebook
Get flash to fully experience Pearltrees

Blogs

UPDATE: These steps have been simplified with the release of Visual Studio 2012. Please see: Publishing LightSwitch Apps to Azure with Visual Studio 2012 One of the many features introduced in Visual Studio LightSwitch Beta 2 is the ability to publish your app directly to Windows Azure with storage in SQL Azure. We have condensed many steps one would typically have to go through to deploy an application to the cloud manually. In this tutorial, we will deploy a LightSwitch web application with Forms authentication to Windows Azure and SQL Azure. http://blogs.msdn.com/b/lightswitch/archive/2011/03/18/step-by-step-how-to-publish-to-windows-azure-andy-kung.aspx
http://msdn.microsoft.com/en-us/magazine/ff872379.aspx One of our favorite aspects of technology is that it is constantly evolving and continually changing—there’s always more to learn! As students and followers of cloud computing, we’re tremendously excited about the Windows Azure. As technical evangelists for Microsoft, we have the great fortune to work with customers in the adoption of new technology. As a result, we’ve seen a host of different ways in which to apply Windows Azure. Early on, George had a personal reason for wanting to use Windows Azure. George is involved in many community activities, and the ability to quickly spin up temporary applications and spin them down when no longer needed proved tremendously useful.

Windows Azure - Tips for Migrating Your Applications to the Cloud

In order to keep your SQL Server up and running smoothly you need to constantly be performing routine maintenance and monitoring work. If you do not keep a watchful eye over your SQL Server instances performance and stability might suffer. Or worse yet you might not be able to recover your server should you have a total server melt down. In this article I will be discussing some of the daily tasks a DBA should be performing. Additionally I will be providing a few scripts and suggestions to help minimize the amount of time you have to spend performing these daily tasks. Keep in mind every environment is a little different and requires different sets of daily tasks.

Daily DBA Monitoring Tasks

http://www.databasejournal.com/features/mssql/daily-dba-monitoring-tasks.html
By Garth Wells on 7 May 2001 | 25 Comments | Tags: SELECT Roger writes "Is there a way to retrive a field value from the previously read row in order to use it to calculate a field in the current row . .

Calculating Running Totals

http://www.sqlteam.com/article/calculating-running-totals

T-SQL PIVOT Statement - Pivoting (Crosstab) Data From a Database Table - T-SQL (Transact SQL) Tutorials

Introduction The PIVOT statement is used for changing rows into columns in a SQL Query (Crosstab). The PIVOT Statement is generally written in this form: http://www.tsqltutorials.com/pivot.php

Balanced Data Distributor

A few weeks ago Microsoft quietly released a new Data Flow transformation for SSIS 2008 and 2008 R2: Balanced Data Distributor. This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multi-threading. UPDATE: 2012 version has been released http://microsoft-ssis.blogspot.com/2011/07/balanced-data-distributor.html

SQL Server 2012, cloud, ‘big data’ driving momentum in 2012

Alan R. Earls, Contributor Published: 13 Feb 2012 SQL Server has a lot riding on 2012. For one, Microsoft’s flagship database is due for a major overhaul this year -- and then there are the megatrends, influential forces that may shape the way SQL Server is developed and managed in years to come. http://searchsqlserver.techtarget.com/news/2240115133/SQL-Server-2012-cloud-big-data-driving-momentum-in-2012

Update the view in sql 2005.

http://social.msdn.microsoft.com/Forums/en-US/sqlnetfx/thread/c6ec8b61-4623-4a69-bee0-536c1cbe7236 Let me try to put my problem again. Here is the script of simplified tables and views I am using ---------------------------------------------------------------------------------------------------------------------------------------------- IF EXISTS(Select * From INFORMATION_SCHEMA.TABLES Where Table_Name='view1') Drop View view1 go IF EXISTS(Select * From INFORMATION_SCHEMA.TABLES Where Table_Name='view2') Drop View view2 go

Five cloud-computing takeover stocks

By Nigam Arora In the world of information technology, the megatrend of cloud computing is in its infancy. Cloud computing entails providing software as service. http://www.marketwatch.com/story/five-cloud-computing-takeover-stocks-2012-02-13

Muhammad Shujaat Siddiqi: SSIS Multithreading (Parallel execution in SSIS)

http://www.shujaat.net/2008/10/ssis-multithreading-parallel-execution.html I have always been curious how I could control the parallelism of different flows in Integration Services Packages. But I was not able to find about it earlier. Microsoft gives us enough ability to execute our packages concurrently.

Using Table Valued Functions in SQL Server 2005 to Implement a Spatial Data Library

Gyorgy Fekete and Alex Szalay Johns Hopkins University Jim Gray Microsoft (contact author) November 2005

Database object naming conventions (For SQL Server databases, tables, views, triggers, indexes, primary keys, foreign keys and constraints, cursors, stored procedures, user defined functions [UDFs], columns, defaults, variables): Narayana Vyas Kondreddi's

NEW!!! Subscribe to my newsletter: There exist so many different naming conventions for database objects, none of them is wrong. It's more of a personal preference of the person who designed the naming convention. However, in an organization, one person (or a group) defines the database naming conventions, standardizes it and others will follow it whether they like it or not. I came up with a naming convention which is a mixture of my own ideas and views of SQL experts like Joe Celko! This article references Microsoft SQL Server databases in some examples, but can be used generically with other RDBMSs like Oracle, Sybase etc. too.

SSIS Junkie : SSIS Nugget: Engine Threads

There is a property of each data-flow task called EngineThreads which dictates, quite simply, the number of threads that run in the data-flow pipeline. But what does that mean exactly and how can it affect your data-flow? Well BOL doesn't have much on the subject simply saying "An integer that specifies the number of threads that the data flow task can use during execution" . Well that doesn't help much does it? It doesn't tell you what an engine thread actually is so by way of clarification I set about trying to find out more about them.

SSIS How to Process Data as Fastest,Parallel , Multithreaded or in Very Efficient Way !!! « (B)usiness (I)ntelligence Mentalist

Home > BI Hot , Server , SQL > SSIS How to Process Data as Fastest,Parallel , Multithreaded or in Very Efficient Way !!! I have recently been curious to implement parallelism of different flows in Integration Services Packages in my current project. Where project requirement is to process Data as fast as we can with all parallel, Multithreading or by any other way in very less span of time. After digging in to a lot of things I realize there are n number of ways and n number of post available

Machine Learning (BETA)

Machine Learning (BETA) From HPCC Systems : An extensible set of Machine Learning (ML) and Matrix processing algorithms to assist with business intelligence; covering supervised and unsupervised learning, document and text analysis, statistics and probabilities, and general inductive inference related problems. The ML project is designed to create an extensible library of fully parallel machine learning routines; the early stages of a bottom up implementation of a set of algorithms which are easy to use and efficient to execute. This library leverages the distributed nature of the HPCC Systems architecture, providing for extreme scalability to both, the high level implementation of the machine learning algorithms and the underlying matrix algebra library, extensible to tens of thousands of features on billions of training examples.