SQL Server

Www.sqljoe.com. Blogs. UPDATE: These steps have been simplified with the release of Visual Studio 2012. Windows Azure - Tips for Migrating Your Applications to the Cloud. 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. Because of the interest many of our corporate customers express­ed in Windows Azure, we decided to hold a set of Windows Azure Migration Labs at the Microsoft Technology Centers.

We weren’t surprised—we already had plenty of experience with Windows Azure and were confident our customers would meet with success. BeyeNETWORK: Global coverage of the business intelligence ecosystem. MSDN Blogs - MSDN Blogs. Daily DBA Monitoring Tasks. 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. Verifying Services Availability You need to make sure your critical SQL Server services are available. Ideally I would implement a monitoring tool that will automatically email you when one of your critical services is not working. Calculating Running Totals. 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 . . .

" For example: day sales cumu_total 1 120 120 2 60 180 3 125 305 4 40 345 In order to calculte the cumulative total I need to know the previous cumulative total (cumulative total could be any other calculation). I did this in MySQL by using variables to temporarily hold values between rows but SQL server doesn't assinging variables in retrieval statements. T-SQL PIVOT Statement - Pivoting (Crosstab) Data From a Database Table - T-SQL (Transact SQL) Tutorials. Introduction.

Balanced Data Distributor. 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. Update the view in sql 2005. 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 view1go IF EXISTS(Select * From INFORMATION_SCHEMA.TABLES Where Table_Name='view2') Drop View view2go IF EXISTS(Select * From INFORMATION_SCHEMA.TABLES Where Table_Name='view3') Drop View view3go.

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. Cloud computing stocks are very expensive, face stiff competition and are subject to rapid technological changes. However, these stocks are being taken over at a rapid clip. For example, Oracle /quotes/zigman/19452757/delayed/quotes/nls/orcl ORCL +0.34% just announced that it will buy Taleo Corporation . Previously SAP /quotes/zigman/126928/delayed/quotes/nls/sap SAP +1.17% announced purchase of SuccessFactors at P/S of about 11.5. Oracle and SAP are the two big software behemoths. Here are five cloud software application stocks that are ripe for a takeover. Muhammad Shujaat Siddiqi: SSIS Multithreading (Parallel execution in SSIS) 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 Applies to: Microsoft SQL Server 2005 Summary: This article explains how to add spatial search functions (point-near-point and point in polygon) to Microsoft SQL Server 2005 using C# and table-valued functions. It is possible to use this library to add spatial search to your application without writing any special code. Join the MSSQLTips SQL Server Community. 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. So I think we can make some simple assumptions. You can see that there are 8 completely independant data paths here right? There are only 5 data paths executing in parallel.

So then I started to wonder if you can have more than 1 thread when the data paths are not independant. Here I've got a single source adapter and a multicast component that splits that into 8 seperate data paths. SSIS How to Process Data as Fastest,Parallel , Multithreaded or in Very Efficient Way !!! « (B)usiness (I)ntelligence Mentalist. Machine Learning (BETA) SQL Server Performance - SQL Server Performance Tuning. SQL Server Central. Microsoft SQL Server tutorials, training & forum.

SQL Server: Covering today's SQL Server topics. SQL Server Tutorials and Tips. SQL Server Journey with SQLAuthority. SSIS Expression Cheat Sheet. SSWUG.ORG.