In this issue:

Tech News : General Interest

Tech News : Security

Hardware News

Blogs : Administration

Blogs : Analysis Services / BI

Blogs : Career

Blogs : Computing in the Cloud

Blogs : Events

Blogs : Excel

Blogs : High Availability/Disaster Recovery

Blogs : Integration Services/ETL

Blogs : Reporting Services

Blogs : Security and Auditing

Blogs : Software Development

Blogs : SQL Server 2000

Blogs : T-SQL

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 2012-08-27

SQl Storage Compress Compress live data by 73% 
Red Gate's SQL Storage Compress reduces the size of live SQL Server databases, saving you disk space and storage costs. Learn more.
SQL Connect Develop seamlessly between Management Studio and Visual Studio
SQL Connect is a Visual Studio add-in that makes it easy to keep your database and Visual Studio project in sync. Find out more.
SQL Backup Pro Have you tried SQL Backup Pro 7 yet?
Get faster, smaller, fully verified backups today. Try SQL Backup Pro 7's automated DBCC CHECKDB and be prepared when you need to restore. Download free trial.
Editorial - Outsourcing Jobs

It seems that these days any number of people have some level of uncertainty about their employment. The days of working for one company for your entire 40 year career seem to be over for most people, at least in technology. If you can do it, great, but for most of us, that's not something that's likely to occur. 

Some of the reasons might be that people in technology are easily bored and like change, but some is also because employers view us as replaceable units and are less hesitant to change employees if they perceive some value. Those changes might be simply terminating one employee and hiring another, or they could be outsourcing the position to another company.

I ran across this piece in InfoWorld about the hottest outsourced jobs in US companies. The piece talks mostly about development and UI/UX jobs, including QA positions, being the ones that are most likely to be outsourced. On top of those jobs, however, it seems that there's no shortage of companies looking to take advantage of cloud-based services and reduce their infrastructure costs. They aren't moving all their IT services to the cloud, but they are considering some of them.

There are some data jobs listed, including architects, developers, analysts, and data warehouse data jobs. I don't know how many companies really want to eliminate DBAs, but if they do, there will still be data jobs with the outsourcing providers.

The one good thing I saw in the report is only a small percentage of companies are looking to offshore the work. It doesn't help if your company is one of that percentage, and if that's the case, I hope you can find something else.

In any case, there will be constant changes in technology over the next few years. you should continue to work on your own professional development and be aware of the environment in which you work. It is important you recognize that you are responsible for finding the opportunities as you move forward in your career.

» 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

From developers to DBAs: The hottest outsourced IT jobs - Companies are outsourcing fewer IT jobs overseas, but workers still have to compete against cloud-based services...(more)

Amazon Web Services launches low-cost storage service - Amazon Web Services has announced Glacier, a low-cost storage service that has been customized for data archiving and backup, the company said on Monday. Areas that are a good fit for Glacier include media archives, financial and health care records, raw genomic sequence data, long-term database backups, and information that has to be retained for regulatory compliance, it said....(more)

Kickstarter Project Offers Big Solar Energy On The Go - Kickstarter project hopes to create portable, efficient solar generator....(more)

Tech News : Security

Crisis malware infects VMware virtual machines, researchers say - The Windows version of Crisis, a piece of malware discovered in July, is capable of infecting VMware virtual machine images, Windows Mobile devices, and removable USB drives, according to researchers from antivirus vendor Symantec. Crisis is a computer Trojan program that targets Mac OS and Windows users. ...(more)

Why passwords have never been weaker—and crackers have never been stronger - Thanks to real-world data, the keys to your digital kingdom are under assault....(more)

Hardware News

Logitech Launches Fully Water-Washable Keyboard K310 - Yes, you can wash this keyboard without causing damage. It can even be submerged in up to 11 inches of water -- just don't include the USB plug....(more)

PNY Launches New Line-Up of Consumer, Enterprise SSDs - PNY has introduced new SSDs for the consumer and enterprise sectors....(more)

Microsoft Hardware Introduces New Artsy Mice - Looking for a little style and splash of color on your desktop? Microsoft has batch of new mice that should please even the pickiest of art students....(more)

Blogs : Administration

Tips For Minimizing Deadlocks in SQL Server - Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases the likelihood of conflicts because multiple processes can request access to same resources at the same time. This type of conflict is also known as block or blocking. Blocking usually resolves itself after the locking process releases the resource for waiting process. Sometimes, blocking creates a more serious condition, called a deadlock or fatal embrace, which occurs when the first process is waiting for the resource that is locked by the second process and the second process, is waiting for the resource that is locked by the first process....(more)

SQL Server 2005 Diagnostic Information Queries (August 2012) - Here is the August 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements. To go with it is an updated, blank results spreadsheet, where the tabs in the spreadsheet are labeled and in the same order as the queries. ...(more)

Disabling DDL Triggers - Suppose you want to stop using a DDL trigger for a short period of time, such as the login trigger I created recently. If you want to disable an index, you use ...(more)

Restore Database In SQL 2012 - In the post below I mentioned a store procedure which can generate the database restore script based on the msdb history table...(more)

SQL Server:Understanding the Data Record Structure - In our last post, we have gone through the data page structure and we have noticed that there is an overhead of 7 bytes in each records. Let us try to understand how SQL Server stores the records in a data pages....(more)

Potential Problems with Partitioning - Getting started with table partitioning is difficult; there are many decisions to make after you’ve decided to partition data. Correctly configuring partitioning is critical to the long term performance and stability of the database from both a querying and data modification standpoint. There are three key considerations that database architects should devote time to before embarking on a partitioning implementation: the design of the partitioning key, a thorough study of querying practices, and an examination of data modification practices....(more)

Most common latch classes and what they mean - Back in May I kicked off a survey about prevalent latches on SQL Server instances across the world (see here). It's taken me quite a while to get around to collating and blogging about the results, but here they are at last! ...(more)

Change Management: The Question You’re Not Asking - I work with clients with a variety of change management practices— everything from, “I just email the team when I’m going to change something” to “I need to submit formal changes each Tuesday by 2pm for weekly review for the next approved change window.” And occasionally, “Just Do It.”...(more)

Isolation levels in SQL Server - ation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved with the help of locks but what locks are needed and how they can be established is decided on the isolation level set on the database level. If low level of Isolation is set, it allows multiple users to access the resources concurrently but it may result in many concurrency related problems like phantom reads, dirty reads etc. If higher levels of Isolation is set then it eliminate the concurrency related problem but it results in less number of concurrent access and it may result in data blocking...(more)

Blogs : Analysis Services / BI

Three kinds of big data - In the past couple of years, marketers and pundits have spent a lot of time labeling everything ”big data.” The reasoning goes something like this:...(more)

Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element. - If you have done a lot of work with SQL Server Analysis Services (SSAS) you may have seen this message:...(more)

Blogs : Career

Final “Be The Next Microsoft Employee” Episode Recap - It has been a run ride for the Microsoft Reality show “Be the Next Microsoft Employee,” and it’s hard to believe that the final challenge is here and the show concluded today! As you no doubt have been following the show, you can recall that last week Microsoft Judge Buck Woody dropped in unexpectedly on the contestants and gave them their final challenge early. But what exactly was it?...(more)

PASS Summit Code of Conduct – my thoughts - The big furor today is over PASS‘s new written Code of Conduct. I’m going to crib unashamedly from Nic Cain’s blog post “Mind Your P’s and Q’s” to get this started, because he’s a friend and won’t mind (especially with the link), and because it’s a busy day, so I’m going to shortcut this....(more)

Paying it Forward - My company has recently put forth an effort to hire fresh college graduates and interns. I think this is a great thing. A long time ago, in a galaxy far far away, I was a fresh graduate, with no real world experience and my first employer took a big chance in hiring me. I was really lucky with my first employer, I had a couple of fabulous mentors that taught me not just technical skills, but life skills, that I still use today. Employers are getting in on the ground floor and it’s in their best interest to invest resources in what will hopefully be a long, successful and rewarding career. “Paying it forward”, as it were....(more)

Survival Tips For DBAs: How To Talk To Your Developers - ast week I made a sincere effort to help build some bridges. Since that post was published I have received many requests for a similar chart in the other direction: teaching a DBA on how to talk to a developer. Well, here it is....(more)

Rant: Applying Common Sense in IT - I was watching a training video last night and the instructor made the statement we hear all the time:...(more)

Would You Listen To The Steve & Andy Radio Show? - My friend Steve Jones and I have talked every week for a long time, close to ten years now. On any given week we might talk about work, life, politics, woodworking, family, gardening, SQL Server, professional development, news about friends. Last week we were talking about some other stuff and Steve says to me that we should do a radio show....(more)

Meme15: Top 5 Reasons I Like My Job - This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’. A little over a year ago, I started working as a Business Intelligence developer at Trek Bikes. Working at Trek has been a great experience and I feel very fortunate to have the opportunity, so I thought I’d share a few of the things I like best. ...(more)

Blogs : Computing in the Cloud

Cost Comparison: Amazon Glacier vs S3 - Experiment results: AWS Glacier storage is around 90% cheaper than S3 and a good long term data-archive option ...(more)

Windows Azure Host Updates: Why, When, and How - Windows Azure’s compute platform, which includes Web Roles, Worker Roles, and Virtual Machines, is based on machine virtualization. It’s the deep access to the underlying operating system that makes Windows Azure’s Platform-as-a-Service (PaaS) uniquely compatible with many existing software components, runtimes and languages, and of course, without that deep access – including the ability to bring your own operating system images – Windows Azure’s Virtual Machines couldn’t be classified as Infrastructure-as-a-Service (IaaS). ...(more)

Blogs : Events

Amazing Margaritas in Austin – SQL in the City US Tour - The last time I was in Austin was last year, for a weekend trip with my wife to see Stevie Wonder and Kanye West (on separate days) at the Austin Music Festival. My wife and I have been trying to see Stevie Wonder for over ten years, and we finally got the chance and thoroughly enjoyed the experience. It’s something I’ll never forget, and I’d be tempted to go down there again for the ACL Festival weekend....(more)

Got A Pal in Kalamazoo (#SQLSat160) - It’s been a year already and it’s time to head back to Kalamazoo for their SQL Saturday. We’re heading back to the same location on September 22 for another day of free training on SQL Server. Not only is the training free but it is also an opportunity to meet and network with local professionals and speakers from around the country. If you are looking for a good way to spend a Saturday learning about SQL Server for free – this is the Michigan event to do just that. ...(more)

SQL in the City - Seattle 2012 - Just before the PASS Summit, SQL in the City comes to Seattle on Monday, Nov 5. Join us for a free day of training....(more)

SQL in the City - Boston 2012 - SQL in the City comes to Boston, MA on Oct 8, 2012. Come attend a free day of training with us....(more)

SQL in the City - Chicago 2012 - SQL in the City comes to Chicago, IL on Oct 5, 2012. Join us for a free day of training....(more)

SQL in the City - San Francisco 2012 - SQL in the City comes to San Francisco, CA on Oct 3, 2012. Join us for a free day of training....(more)

SQL in the City - Austin 2012 - On Monday, Oct 1, 2012, SQL in the City comes to Austin, TX. Register today for a free day of SQL Server training....(more)

SQL in the City - New York 2012 - On Friday, Sept 28, 2012, SQL in the City comes to New York City. Register today for a free day of SQL Server training....(more)

Join me for SSIS Training in London 12-14 Sep 2012 - We still have a few seats available in the Learning SQL Server 2012 Integration Services class in London in mid-September. You can learn details here and register for the course here ...(more)

Presenting at DevLink 2012 29-31 Aug! - I am honored to present three sessions next week at DevLink 2012 – 29-31 Aug! My sessions are: Loading SQL Server 2012 Data Warehouse Partitions at 1:00 PM 29 Aug Designing an SSIS Framework at 4:00 PM 30 Aug Using BIML as an SSIS Design Patterns Engine at 8:00 AM 31 Aug...(more)

Windows Server 2012 IT camps - I have been out in the US for the past four weeks, and during my absence the rest of the UK TechNet team have filled my diary with various events including the next series of IT camps. These camps will all be on Windows Server 2012 specifically around how virtualisation changes in this release not just with Hyper-V but other supporting technologies such as SMB 3, Networking, Active Directory and of course Powershell....(more)

Upcoming Chicago Events! - Wanted to make sure everyone knew about upcoming events:...(more)

Blogs : Excel

Introduction to the Data Model and Relationships in Excel 2013 - I am very happy to be writing this blog post today. Not just because I will be showing you another way Excel can make your data analysis easier but also because I will be introducing the new Data Model and Relationships features that will hopefully change the way you use Excel for data analysis forever. ...(more)

Blogs : High Availability/Disaster Recovery

Transparent Data Encryption (TDE) with Database Mirroring - Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain sensitive and confidential information about their customers. The organisation working in such sectors also falls under the boundaries of data regulatory and compliance requirements (such as HIPAA, PCI-DSS, SSAE16 etc.) which require the encryption of sensitive data inside databases and at operating system level. SQL Server offers a variety of options for encryption which includes Transparent Data Encryption (TDE). This feature is available in since the release of SQL Server 2008 and provides us the real-time encryption of data and log files. The Transparent Dat Encryption (TDE) also encrypts backups, snapshots and transaction logs of the database....(more)

Home Backup for the DBA - I’ve been giving a Prepare for When Disaster Strikes talk at SQL in the City this year, and it’s designed to get you to think about problems before they happen and take steps to mitigate issues. It’s important at work, but it’s also important at home....(more)

Blogs : Integration Services/ETL

Exporting Data Using BCP - BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way to export large quantities of data very quickly from SQL Server. It can be used to export entire tables or even a custom query. In this post we will focus on doing some simple commands to export data. This is by no means a complete and comprehensive look at BCP. My only intention with this post is to get you started and maybe provide a quick syntax reference for doing BCP in the future....(more)

SQL Server CDC: Remember It's Not Free - Someone recently recommended that a developer use SQL Server's CDC (Change Data Capture) to create a history record for a transactional table because doing that work in a stored procedure "makes this stored procedure slow". Remember that there is no magic in CDC; it's not free....(more)

Installing Data Quality Services (DQS) on SQL Server 2012 - Data Quality Services is very interesting enhancements in SQL Server 2012. My friend and SQL Server Expert Govind Kanshi have written an excellent article on this subject earlier on his blog. Yesterday I stumbled upon his blog one more time and decided to experiment myself with DQS. I have basic understanding of DQS and MDS so I knew I need to start with DQS Client. However, when I tried to find DQS Client I was not able to find it under SQL Server 2012 installation....(more)

Blogs : Reporting Services

Implementing the SSRS 2012 Service Application in a SharePoint 2010 Cross-Farm Environment - Part 2 of 2 - or Part 2 of this article we will discuss what is needed on the Publishing Farm in order to publish the Reporting Services service application, what is needed on the Consuming Farm in order to connect to the published service application and how to setup a Report Viewer web part on the Consuming Farm to view a published report....(more)

Visualisation to convert times to other time zones - Lately PASS as an organisation has been positioning itself as a truly global representative of the SQL Server community. As part of that push the BI Virtual Chapter has been scheduling live sessions that run at times all across the world and giving opportunities for local speakers to showcase their talents....(more)

Blogs : Security and Auditing

Resources for Those Dealing with Security Patches - It's been a while since I was in the day-to-day business of security patches. However, I still keep up with vulnerabilities and fixes as I expect every Microsoft SQL Server DBA should. Here are some resources I recommend to do the job right:...(more)

Blogs : Software Development

Nine months of pair programming - I’ve paired off and on throughout my programming career, but for the last nine months, I’ve had a chance to pair nearly full time. I’m not much of a drink-the-koolaid dogmatist, so I’ll try to give my honest opinion about what’s wonderful and not so wonderful about pair programming....(more)

Blogs : SQL Server 2000

SQLAuthority News – 2 Security Updates for SQL Server 2000 SP 4 Users - If you are using SQL Server 2000 still today my very first recommendation to you is to upgrade to SQL Server 2012. SQL Server 2000 is now 12 years old product and since then many new enhancements as well features which are relevant to current growth and progress in Informational Industry. Now is the time to catch up with the latest trends. Here is one more point for you to notice if this helps you consider to upgrade to the latest version. One can’t upgrade directly from SQL Server 2000 to SQL Server 2012. You need to first upgrade to either SQL Server 2005/2008/R2 and then further plan to upgrade to SQL Server 2012. There is no direct upgrade path for SQL Server 2000 to SQL Server 2012. I strongly believe this is the time to upgrade to the latest version....(more)

Blogs : T-SQL

SELECT INTO is faster than INSERT SELECT - I had heard that SELECT INTO is faster than INSERT SELECT, so I wanted to prove it. Here are the results of testing in both FULL and SIMPLE recover models. Each test was run twice, once with INSERT-SELECT first and once with SELECT-INTO first....(more)

Another Execution Plan… In the Cloud! - A couple of weeks ago I posted about how different execution plans look when using the Azure Management Portal. I promised to look at a more complex plan and here we are. The query looks like this:...(more)


Administrative