In this issue:

Tech News : Data Mining/Warehousing

Tech News : General Interest

Tech News : Security

SQL Server News : Bugs/KB

Press Releases

Microsoft News : Patches, Bugs

Blogs : Administration

Blogs : Career

Blogs : Computing in the Cloud

Blogs : Data Mining

Blogs : DMO/SMO/Powershell

Blogs : Events

Blogs : Performance and Tuning

Blogs : Replication

Blogs : SQL Server 2012

Blogs : StreamInsight

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-09-24

SQL Agile Training Learn Agile Database Development Best Practices
Agile database development experts Sebastian Meine and Dennis Lloyd are running day-long classes designed to complement Red Gate’s SQL in the City US tour. Classes will be held in San Francisco, Chicago, Boston and Seattle. Register Now.
SQL Monitor New! SQL Monitor release
Check out the latest features in SQL Monitor 3.2 and take a look at our new custom metrics sharing site. Find out more here.
SQL Source Control Is your SQL Database under Version Control?
SSMS plug-in SQL Source Control connects SVN, TFS, Git, Hg and all others to SQL Server. Learn more.
Editorial - IT is Looking Good

It's only Q4, and it's not a huge increase, but there does appear to be an overall up tick in expected IT hiring. More companies said they were looking to expand IT departments than were contracting them, which is good. However your mileage may vary in your field or company as there are definitely companies that are looking to let people go.

Your career is your responsibility, and while your employer may help with training, you need to make sure that you are managing your own career. Andy Warren (b | t)talks about having a professional development plan, in which you decide what your goals are, how you will achieve them, and what your investment will be. I think that's a great idea, and I encourage all of you to spend some time thinking about where you want to be in your career in a few years time.

Budgets are tight, and one of the things that many companies talk about is the challenge in finding people with the right skills. You can look through job listings, and even respond to some to ask about what levels of talent companies are asking for. Your current company might not want to train you to leave, but there are lots of other opportunities if you keep your eyes open.

We publish regular material at SQLServerCentral and our forums make great reading and give you the chance to practice solving real problems. We're not alone as there are lots of other ways to learn. Last week was 24 Hours of PASS, a chance to learn from your peers all around the world, for free. If you can afford it, SQLskills offers a series of amazing in-person classes each year, and in September they gave away three of their online classes for free with Pluralsight. Those deals come along if you're looking for them, and are worth taking advantage of when they do.

I still think this is an exciting and amazing field to be apart of. Companies need skilled people and they pay well for them. It's up to you to be one of the skilled people that's worth hiring.

» 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 : Data Mining/Warehousing

Enterprise Data World Conference - Enterprise Data World is the business world’s most comprehensive educational event about data and information management. Over the course of five days, EDW presents a diverse schedule of programming that addresses every level of proficiency, including keynotes, workshops, tutorials, case studies, and discussions. The conference includes over 200 hours of cutting-edge content in a vendor-neutral environment, with specialized tracks that allow you to focus on the data management topics most pertinent to your needs, including all-new tracks on Unstructured Data and Data-driven Business. ...(more)

Tech News : General Interest

IT headcount expected to rise in Q4 - More CIOs are planning to expand their IT departments in the coming quarter than were three months ago. But compared to other professions, projected IT hiring in Q4 lags behind fields such as legal, sales, and marketing, according to new data from Robert Half Technology....(more)

Data is the real business model for social - As social media websites gather ever-growing data stores, they might be better served by finding ways to make profitable use of that data instead serving ads as their chief means of raising revenue. While the data might give them the information they need to serve more targeted ads — although in my experience they still have a ways to go with that — the real value in the site could be the data itself. ...(more)

Tech News : Security

Oracle Database suffers from "stealth password cracking vulnerability" - A weakness in an Oracle login system—used in the company's databases which grant access to sensitive information—makes it trivial for attackers to crack user passwords and gain entry without authorization, a researcher has warned....(more)

The NSA and the Risk of Off-the-Shelf Devices - Interesting article on how the NSA is approaching risk in the era of cool consumer devices. There's a discussion of the president's network-disabled iPad, and the classified cell phone that flopped because it took so long to develop and was so clunky. Turns out that everyone wants to use iPhones....(more)

Toyota Falls Victim to Ex-Employee Hack Attack - A computer programmer from central Kentucky who once did contract work for Toyota has been charged with hacking into and damaging computers used by the automobile maker. ...(more)

Man-in-the-Middle Bank Fraud Attack - This sort of attack will become more common as banks require two-factor authentication: Tatanga checks the user account details including the number of accounts, supported currency, balance/limit details. It then chooses the account from which it could steal the highest amount. ...(more)

SQL Server News : Bugs/KB

SQL Server 2012 SP1 CTP4 Now Available - In late July, we released SQL Server 2012 SP1 CTP3, the first public Community Technology Preview (CTP) for SQL Server 2012 Service Pack 1, which contained compatibility features for SQL Server 2012 to support self-service BI capabilities in Office and SharePoint 2013 Preview. Today, we are excited to release SQL Server 2012 SP1 CTP4 which contains additional supportability improvements that have been reported through our customer feedback platforms. The following highlights a few key enhancements in CTP4:...(more)

Press Releases

SSMS Tools Pack 2.5 is out. Added support for SQL Server 2012. - Because I wanted to make SSMS Tools Pack as solid as possible for SSMS 2012 there are no new features only bug fixes and speed improvements. ...(more)

GreenSQL 2.2 Provides Complete Security for Microsoft® SQL Server 2012 and SQL Azure™ - TEL AVIV, Israel – September 19, 2012 –GreenSQL, the database security company, now ensures complete database security for SQL 2012 (“Denali”) and SQL Azurewith GreenSQL 2.2. "Our technologies are aligned with Microsoft, ensuring its SQL Server 2012 customers continue to have the same complete protection we have always provided," says Amir Sadeh, CEO, GreenSQL. "We have also bundled other enhancements to further increase our value to our customers." GreenSQL 2.2 has enhanced performance and added significant business continuity features. The high availability, multi-level fault tolerance, and bypass options ensure clients' databases are always readily available....(more)

Upload Files to Amazon Glacier with CloudBerry Explorer - Newport Beach, California, September 18, 2012 -- CloudBerry Lab, a leading cloud storage tools maker, today released CloudBerry Explorer v.3.6, an application that allows users to manage files in Amazon S3 just as they would on their local computers. In the new release CloudBerry S3 Explorer comes with a full support for Amazon Glacier, the recently introduced extremely low-cost storage. Optimized for data backup and archiving it becomes a supplement to Amazon S3 storage costing as little as $0.01 per gigabyte per month. Amazon claimed Glacier to be as reliable as its original S3 solution but with longer data retrieval time. From the new release CloudBerry S3 Explorer users can access and manage Amazon Glacier storage. Users can create vaults, move data to vaults and request to download them back to their computer. Users can create vaults in any of the available AWS regions. Amazon Glacier is supported by both versions of CloudBerry Explorer: Freeware and PRO. Freeware version offers basic storage management capabilities such as browsing, creating, and deleting files, archives, vaults and uploading content from your PC to Glacier storage and vice versa. CloudBerry Explorer Freeware is available for download at http://www.cloudberrylab.com/free PRO version offers some advanced features over Freeware version. It costs $39.99 per license and available for download at http://www.cloudberrylab.com/pro ...(more)

Microsoft News : Patches, Bugs

Microsoft Issues Urgent Internet Explorer Security Fix - Microsoft is strongly suggesting Internet Explorer users download a temporary patch to bandage a vulnerability that could allow hackers to take remote control of their computers. Some are tracing it back to the now-infamous Oracle Java attackers. ...(more)

Microsoft confirms hackers exploiting critical IE bug, promises patch - crosoft on Monday issued a security advisory that confirmed in-the-wild attacks are exploiting an unpatched bug in Internet Explorer. The software maker is working on a fix....(more)

Blogs : Administration

SQL Server Quickie #3 – Allocation Units - Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I'm talking about Allocation Units in SQL Server. ...(more)

SQL Agent Job Script - I’ve been working on a script for a demo in my upcoming 24 Hours of PASS presentation, which I thought I’d share on my blog. In the presentation, I use this script to demonstrate how to execute one or more queries dynamically against a list of SQL Server instances....(more)

Blogs : Career

How To Turn Your Current Job Into an Online Business - If you’re stuck doing a job you don’t like but are having trouble coming up with a business idea for a website, the answer is probably more obvious than you think. In fact, it’s probably been right under your nose for years....(more)

Blogs : Computing in the Cloud

New SQL Azure Features - FYI, we announced new features on SQL Azure today, including SQL Azure as a distributed query target for SQL Server...(more)

Blogs : Data Mining

Commerce Weekly: Big data in retail - Here are a few stories from the commerce space that caught my attention this week:...(more)

Data for Sale? - I read an interesting article by Stephen Swoyer today on the TWDI site today, about a new Gartner report that suggests that companies should start selling the data they collect for BI purposes to third parties via public data marketplaces. This is a subject I’ve seen discussed a few times over the last year or so – indeed, I remember at the PASS Summit last year I overheard a member of the Windows Azure Marketplace dev team make a similar suggestion – and I couldn’t resist the opportunity to weigh in with my own thoughts on the matter....(more)

Blogs : DMO/SMO/Powershell

The PoSh DBA: Solutions using PowerShell and SQL Server - PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much more than getting information from SQL Server instances via PowerShell; it can also be run from SQL Server as part of a system that helps with adminstrative and monitoring tasks. Laerte explains how. ...(more)

Parsing Windows event logs with PowerShell - Lately I’ve been toying with the idea of using PowerShell to parse the Windows event logs and possibly adding that to my Inventory scripts. I like the idea of pulling out the important errors and messages into a central place for easy viewing/reporting. Depending on what platform you’re running on, there are a couple of options available....(more)

Blogs : Events

MN SQL Saturday 149 Pre-Cons & Main Event Next Week Sept 28 & 29 - Just a quick reminder that next week the MN SQL Saturday 149 takes place. On Friday, September 28 there are two all day pre-con events. There is a Business Intelligence pre-con where Brian Larson and I will be going over Microsoft BI including items such as PowerPivot, SharePoint, Tabular SSAS, and Power View. I also know that there is an added bonus to signing up for our session besides just getting your lunch paid for on Saturday, you will get a copy of our Visualizing Data with Microsoft Power View book! Down below I have included the tentative agenda for the day as well. In addition to our pre-con SQL Server MVP Ted Krueger is doing one on T-SQL performance tuning....(more)

Join Our Networking Dinner in Seattle - This is the third year that Andy Warren and myself are hosting a networking dinner in Seattle, just before the PASS Summit. If you are new to the Summit, or just interested in meeting some new people, we hope you’ll join us on Monday, Nov 5, at Gordon Biersch, located in the Pacific Place mall on Pine St. It’s just a couple blocks from the Convention Center....(more)

SQL in the City – US 2012 Tour - Last year I had the pleasure of speaking at two SQL in the City events: London and Los Angeles. It was a great time and I was hoping we’d do more events this year....(more)

SQL Saturday #171 Pittsburgh, the Schedule is Up! - SQL Saturday #171 Pittsburgh preparations continue, and the schedule has been posted for your review. If you're anywhere in the area on October 6th, please join us at La Roche College for some great free SQL training. ...(more)

SSIS Training 15-19 Oct in Reston Virginia - Early bird registration is now open for Linchpin People ’s SSIS training course From Zero To SSIS scheduled for 15-19 Oct 2012 in Reston Virginia! Register today – the early bird discount ends 28 Sep 2012. Training Description From Zero to SSIS was developed by Andy Leonard to train technology professionals in the fine art of using SQL Server Integration Services (SSIS) to build data integration and Extract-Transform-Load (ETL) solutions....(more)

SQL in the City – US 2012 Tour - Last year I had the pleasure of speaking at two SQL in the City events: London and Los Angeles. It was a great time and I was hoping we’d do more events this year....(more)

Blogs : Performance and Tuning

T-SQL Update Takes Much Longer Than The Matching Select Statement - I realize the title is generic and that is because the problem is generic. On the surface it would not surprise me that an update takes longer than a select. (A little bit anyway.)...(more)

Blogs : Replication

Max Text Replication Size – When you might have to care about this number ! - One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common one. In most of cases the default value is not changed....(more)

Blogs : SQL Server 2012

The Case for Core - SQL Server 2012 was the first version of SQL Server to support being installed on Windows Server Core Edition (Windows without a GUI to the rest of the world). With the impending release of Windows Server 2012 there are a lot of people who are excited about running SQL Server 2012 on Windows Server 2012 in their data center. Let’s look at what you’ll need to do to become fluent and productive with Windows Server Core....(more)

Blogs : StreamInsight

Getting Started with StreamInsight 2.1 - If you're just beginning to get familiar with StreamInsight, you may be looking for a way to get started. What are the basics? How can I get my first StreamInsight application running so I can see how it works? Where is the 'front door' that will get me going?...(more)

Blogs : T-SQL

SSMS Automatically Generates TOP (100) PERCENT in Query Designer - Earlier this week, I was surfing various SQL forums to see what kind of help developer need in the SQL Server world. One of the question indeed caught my attention. I am here regenerating complete question as well scenario to illustrate the point in a precise manner. Additionally, I have added added second part of the question to give completeness....(more)


Administrative