In this issue:

Tech News : General Interest

Tech News : The Lighter Side

SQL Server News

Microsoft News : General Interest

Blogs : Administration

Blogs

Blogs : Career

Blogs : Computing in the Cloud

Blogs : Data Access / ORMs

Blogs : Database Design, Theory and Development

Blogs : DMO/SMO/Powershell

Blogs : Events

Blogs : Hardware

Blogs : Performance and Tuning

Blogs : Performance Point

Blogs : Software Development

Blogs : SQL Server Compact Edition

Blogs : T-SQL

Articles

Articles : Development

Database Weekly - www.databaseweekly.com

The Complete Weekly Roundup of SQL Server News

Hand-picked content to sharpen your professional edge

SQL Server News for 2010-09-13

SQL Source Control Do you source control your database?
SQL Source Control provides database source control within SSMS. Try it out now.
SQL Virtual Restore Backup verification with DBCC CHECKDB
Use SQL Virtual Restore to mount your backup as a live database - without the time or space needed for a physical restore - and run DBCC CHECKDB against it to verify that your backup is good. Download a free trial.
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.


Editorial - Getting Fired from an Unpaid Job.

I generally don’t get too bothered when I lose my job.  I shrug, shake the dust from my sandals, and move on. However, I must admit to some irritation when it was a part-time job I was doing for free in my spare time just to help out.

A lot of database people do free work for charities and societies, even when they’re working. When you’re unemployed, the value of doing this sort of thing is even greater. It keeps your hand in, and forces you to keep up with the technologies. I enjoy it because I use such tools as C# that I don’t have time for in my day job, and it broadens my experience.

When my indignation subsided from getting the sack, it began to dawn on me how irritating I must have been for them. Because my own working life swings wildly from busy to ridiculous, I sometimes don’t deliver unpaid work to dates. These organizations don’t appreciate that your priorities don’t coincide with theirs, especially when other people are giving their time for free. I can’t do much about it. When my paid work makes extra demands on my time, then it has to come first.

Arnie Rowland’s excellent Project Phoenix initiative to provide tools and training for twenty-four unemployed, or underemployed, developers in the USA and Canada is worthy of all our support. It’s a great idea which Arnie has pursued with energy. I’m hoping that it will provide valuable experience for subsequent projects.

Project Phoenix provides a good measure of support and mentoring into the projects that are adopted. It is a good idea to  ‘open-source’  the projects to allow any of us to chip in help, and to involve the MVPs .  if this idea catches on as I hope it will,  it will be great to try to develop more ways of ensuring the continuity of the development by providing backup developer-time in case the developers aren’t able to provide the work that they committed to. Maybe, we could work out structured ways of providing voluntary ongoing support for live projects. Organizations like these are entitled to as good a service as commercial ones, since their workforce is also expected to do the same.  I feel stupid about having to learn the lesson the hard way.

» Join the debate, and respond to today's editorial on the forums


The Weekly News

All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. These headlines are gathered throughout the week and are posted in real time at the website. Check there for information throughout the week or enjoy this weekly summary of the SQL Server world.


Tech News : General Interest

BI firm opts for iPads over laptops - MicroStrategy, a business intelligence software maker, has deployed 1,100 Apple iPads to executives and sales personnel to conduct critical job-related tasks. The company said it expects 700 more iPads to be deployed soon....(more)

30 Brilliant examples of JavaScript and HTML5 Uses - I thought it would be a good idea to look into some interesting uses of the Javascript language. Though none of these examples are really JavaScript only, most put HTML and CSS, to be more exact HTML5, and possibly a few different languages and APIs....(more)

Watch out Java, here comes JavaScript - Any developer with half a clue knows that Java and JavaScript have almost nothing to do with each other. Netscape was originally going to call its browser-based scripting language LiveScript, but Sun Microsystems convinced it to go with JavaScript instead -- the idea being that JavaScript would act as a kind of bridge between HTML and Sun's fuller-featured Java...(more)

Tech News : The Lighter Side

Is Your Database “Web-Scale”? - It’s not safe for work (NSFW), so be sure that you’ve implemented a cone of silence as appropriate for your environment. It’s a parody of the Evo v iPhone video (also NSFW), this time looking at NoSQL and MongoDB v RDBMS systems....(more)

Consultant, Superstar - Does success in one field transfer to another?...(more)

SQL Server News

SQL Server 2008 R2 for the Developer - Version R2 leaves the core database engine of SQL Server 2008 almost completely untouched, but adds a slew of new features that can dramatically expand the role of SQL Server in managing an enterprise's data. ...(more)

New Management, Scalability Features Offered in SQL Server 2008 R2 - Don Kiely explains that the R2 release leaves the core engine untouched from the previous version. He then describes the new SQL Server editions with the R2 release: Datacenter for the biggest and most heavily used enterprise databases, and Parallel Data Warehouse with massively parallel processing to support intensively used data warehouses....(more)

Microsoft News : General Interest

Microsoft apologizes for recurring service outages - On three occasions over the past few weeks, enterprises have had trouble accessing Microsoft's hosted services...(more)

Blogs : Administration

Power of 2 - Installing SQL Server 2005 on an odd number of processors. - I knew of this problem because it happened to my team not more than 3 weeks back when we had a new system with an odd number of cores. The workaround and full discussion of the problem exists. It can be tricky and frustrating if you have not experienced this before....(more)

Create a SQL Server Database on a network shared drive - In SQL 2008 and SQL 2005, By default, you cannot create a new database on a network share drive. This restriction is primarily due to fact that, On a network file share, there is always a risk on network errors compromising database integrity, along with I/O performance issues which might partial or total data loss or corruption. ...(more)

Blogs

Why we got so heavily involved in the Subversion project.. - Subversion had a couple of key features that were missing from CVS including Atomic Commits, efficient binary diff storage, versioning of symbolic links, web access via Apache and the open source license was not restrictive (unlike CVS), meaning vendors could take it and pretty much do what they wanted....(more)

Agile Ruined My Life - Making good software is hard, and anyone claiming to have a magical process that guarantees good software is selling snake oil. I can appreciate your wanting to make a buck, but would also seriously appreciate it if you could find some other industry besides software development to go screw up...(more)

Blogs : Career

Career Best Practices? - This week I ran into an issue where a team member was not able to be at work. The more and more that I looked at it I realized that I am in the mountains every weekend. Then it hit me, if they can’t reach me who will cover what I do. I am the only DBA on the team and well the end result is I could leave them in a real jam if I was sick or if I was out of town like I will be a lot of this fall. I wanted to take this time and remind you that there are a few things that you need to keep in mind....(more)

Where Have All The Good Managers Gone? - Over the past two weeks I have seen and heard more than a handful of people ask a very simple question: Where are all the SQL Server experts? Many people have offered an answer as to why there is a “shortage” of experts to be found, but none of the explanations I have read seem to get to the root cause of the problem....(more)

A Better DBA Job Description For Everyone - Here is a typical job description that you can find online just about anywhere. It lists almost everything possible and imaginable. And it, well…I’ll just let you read it all for yourself and make up your own mind. Enjoy....(more)

Blogs : Computing in the Cloud

ITIL & the Private Cloud - Although the Private Cloud has many advantages for organizations, there is a learning and growing phase that is frequently omitted. When building out a Private Cloud, many stress points in an organization start to become prevalent. Many of these same organizations had, or were in the process of implementing, the OGC ITIL framework of best practices in IT Service Management. Nonetheless, critical areas of the service management regime had to be reinforced in order to support the transition to the Private Cloud....(more)

Brute Force Migration of Existing SQL Server Databases to SQL Azure - This post is intended for those who are already familiar with SQL Server and want to get started working with SQL Azure. One of the best ways to get up and running quickly is to migrate an existing SQL Server database to SQL Azure. I chose the AdventureWorksDW2008R2 database because it’s optimized for building sample queries and reports....(more)

Brute Force Migration of Existing SQL Server Databases to SQL Azure - This post is intended for those who are already familiar with SQL Server and want to get started working with SQL Azure. One of the best ways to get up and running quickly is to migrate an existing SQL Server database to SQL Azure. I chose the AdventureWorksDW2008R2 database because it’s optimized for building sample queries and reports....(more)

Houston there is a database - Microsoft recently released a CTP of the cloud based SQL Azure management tool, code named “Houston”. Houston was announced last year at the PDC and is a web based version of SQL Management Studio (written in Silverlight 4.0.) If you are using SQL Management Studio, there really is no reason to use Houston, however, having the ability to do web based management is great....(more)

Blogs : Data Access / ORMs

HTML5 - Web SQL Database - The Web SQL Database API isn't actually part of the HTML5 specification but it is a separate specification which introduces a set of APIs to manipulate client-side databases using SQL....(more)

Blogs : Database Design, Theory and Development

Building a Data Warehouse Part V: Application Development Options - In Part I we looked at the advantages of building a data warehouse independent of cubes/a BI system and in Part II we looked at how to architect a data warehouse’s table schema. In Part III, we looked at where to put the data warehouse tables. In Part IV, we are going to look at how to populate those tables and keep them in sync with your OLTP system. Today, our last part in this series, we will take a quick look at the benefits of building the data warehouse before we need it for cubes and BI by exploring our reporting and other options....(more)

Building a Data Warehouse Part II: Building a new schema - In Part I we looked at when you should build your data warehouse and concluded that you should build it sooner rather than later to take advantage of reporting and view optimization. Today we will look at your options to build your data warehouse schema....(more)

Blogs : DMO/SMO/Powershell

Mastering PowerShell – Free EBook - Someone who I follow on twitter posted a tweet recently with a link to a free eBook on PowerShell. I have forgotten who posted the link, sorry. I followed the link and downloaded the book. I have been ‘learning’ PowerShell for a little while, from various sources and I thought I would try out this eBook too. It is written by Dr Tobias Weltner a PowerShell MVP. I’ve only read a couple of chapters but I think it is well worth a read if you are looking to use and learn PowerShell....(more)

Blogs : Events

Register for SQLBits in England – Space Running Out! - If you deal with VMware, Hyper-V, SANs, and SQL Server, come check out my pre-conference session at SQLBits in York, England on Thursday, September 30th. My all-day session is called, “Virtualization, SAN, and SQL Server: The Perfect Storm....(more)

Why #SQLSaturday Matters - I remember when I got out of the academia scene(physics) and started working for the federal government. My position was one that required me to be an active member of the military so part of the gig was that you had 2 weeks worth of training that you had to complete each yea...(more)

Blogs : Hardware

SQL Server infrastructure considerations - build effective storage solutions - Best storage placement will provide a solution to obtain optimum performance on a single-instance and/or multiple instances, so when we talk about Storage Solutions then SAN comes into mind. Having the storage cost as cheaper it is very easy to obtain a SAN to host the data platform....(more)

Blogs : Performance and Tuning

SQL Server DBA Scripts: How to Find Slow SQL Server Queries - SQL Server database administrators need to be able to quickly find out what queries and stored procedures are running slow. Microsoft includes sp_who and sp_who2 in SQL Server 2005 and 2008, but there’s a much better tool, and it’s completely free....(more)

Tuning Tip: Identifying Overlapping Statistics - Statistics are used by SQL Server's query optimizer to help determine the most efficient execution plan for a query. When the option to automatically create statistics is enabled (which it is by default) SQL Server will create statistics on columns used in a query's predicate as necessary, which usually means when statistics don't already exist for the column in question....(more)

TSQL to monitor the I/O pending for each database and I/O writes, sizes- DMV - he primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. Every applicaton is a memory hungry and SQL Server is no exceptional to that which builds a buffer pool in memory to hold pages read from the database. This is where the performance is hampered if the specific code or TSQL must be written in minimizing the number of physical reads and writes between the disk and the buffer pool. ...(more)

SQL Server Redundancy - SQL Server clustering is built on Windows Server clustering, which use a number of servers (nodes) and shared storage to automatically recover a service from a server failure. The service doesn’t have to be SQL Server it could be IIS, or Hyper-V for example. ...(more)

Come and gone - These should occur a lot less often than the CacheHit and CacheMiss events. If they are occurring very frequently it may indicate that the SQL Server is not reusing plans efficiently....(more)

Blogs : Performance Point

PerformancePoint 2010 - PerformancePoint? Is it still around? It is (in SharePoint 2010), and it should peak your interest if you are serious about dashboarding. The planning component is of course gone and I have to admit I never had too much faith in it. When comes to dashboards, Microsoft gives you two implementation options:...(more)

Importing SSAS KPIs in PerformancePoint - Forging ahead through the unchartered land of PerformancePoint 2010, I ran into a snag today. Attempting to import Analysis Services KPIs resulting in the following error:...(more)

Blogs : Software Development

Links for Patterns and Practices for the Data Professional - I spoke at a meeting last evening in Richmond, Virginia (thanks everyone there for being such a great group) about "Patterns and Practices for the Data Professional". Here are the links I mentioned in that class:...(more)

Blogs : SQL Server Compact Edition

A Simple guide to SQL Compact 4 - There has been quite a lot of interest building up recently around SQL Compact 4. Now, if you are not familiar with SQL compact, it's basically a database engine that is free and totally embedded. You don't need to install a database anywhere on your server. Not only that, but it works with existing .NET based data API's (Entity Framework, NHibernate)...(more)

Blogs : T-SQL

Rename a SQL Server column - I've had to do a bit of column renaming lately, so I figured it was worth writing a little blog post about it. Often times, columns that are legacy columns can be recycled for another purpose. The main value in doing this is for those columns that do not allow NULL values and the table is relatively large....(more)

rand vs. crypt_gen_random - Many applications need to generate random data, and in order to help in this task they typically rely on pseudorandom number generators (PRNG). Typical PRNGs are deterministic in nature and therefore they are not cryptographically suitable, this is the case of the built-in RAND (http://msdn.microsoft.com/en-us/library/ms177610(SQL.105).aspx) in SQL Server....(more)

SQL SERVER – Find Automatically Created Statistics – T-SQL - When I was there, I also looked at the statistics and found something that I would like to bring into the limelight. As the developers ran many non-production queries on the production server, many statistics were automatically created on the table. These stats were not useful as they were created by several queries which ran one-time or ad-hoc. Because of this, we really had to identify all the useless statistics and drop them off in order to clean up the statement....(more)

When should you store @@ROWCOUNT into a variable? - There was a question I answered the other day where someone complained that the rowcount was always 0. Below is a simplified version of the query, can you tell why @SomeCount will be 0?...(more)

Multi-value LIKE parameters in SQL - Learning about recursive common table expressions made me change the way I queried hierarchial data. Table valued functions had a similar impact particularly when using CROSS APPLY . However sometimes it is just the combination of simple features that produce something interesting....(more)

Deleting sequential duplicates with TSQL - I was recently given a du-duping task which was much more difficult than I anticipated and taxed my SQL brain to its limits. I thought of using a CTE to do this but all of the examples I could find for deleting records with a CTE wouldn’t have worked in my situation....(more)

Passing Arrays to Stored Procedures - XML is the answer - I wanted the parameters to the stored procedures work something like passing an array or like MethodName(params int[] parameterName) One of the ways which this can be done, which I found really convenient is passing in XML as parameter to the stored procedure and then using "IN" in the SELECT statement....(more)

Articles

Inside the Optimizer: Constructing a Plan - Part 1 - This series of articles looks at how the optimizer builds up an executable query plan using rules. To illustrate the process performed by the optimizer, we'll configure it to produce incrementally better plans by progressively applying its internal exploration rules....(more)

Articles : Development

Common mistakes made when measuring the speed of code - During times I have seen problematic ways how developers measure the speed and performance of their code. There are some easy tricks that help you make your measurements way better and accurate comparing to measurements made not so well. In this posting I will give you some hints how to get more accurate results when measuring the speed of your code....(more)

The Stock Exchange Order Book State problem - Stock exchanges receive high volumes of buy and sell orders. These are either executed immediately or placed in order books. When in the order books they can be executed or cancelled partially or in whole. The stock exchanges are an auctioning system, so that the highest buy orders and lowest sell orders are the most likely to get executed....(more)

Minesweeper in T-SQL - Whatever happened to the idea that programming in TSQL can be fun? A Simple-Talk reader contributes an article to remind us all that there is more to TSQL than wrestling with DMVs and pummelling recalcitrant correlated subqueries. ...(more)

The MERGE Statement in SQL Server 2008 - When the SQL MERGE statement was introduced in SQL Server 2008, it allowed database programmers to replace reams of messy code with something quick, simple and maintainable. The MERGE syntax just takes a bit of explaining, and Rob Sheldon is, as always, on hand to explain with plenty of examples....(more)


Administrative