- Alder
- You are the balanced query as you manage to simultaneously spike the CPU, swamp the I/O subsystem, saturate the NIC and consume all available memory. A custom resource governor group will be created in honour of your accomplishment.
Showing posts with label meme monday. Show all posts
Showing posts with label meme monday. Show all posts
Monday, July 11, 2011
Meme Monday for July
Creative writing, horoscope style for SQL Server. Sounds good to me. I chose to go with the Celtic Zodiac because I'm weird like that.
Monday, June 6, 2011
Meme Monday for June
This month, Tom LaRock asks dumb sql questions. Even having had a week to think about this, I'm still stumped on what'd be a good dumb question. I've been trying to remember some of the dumb things I thought or did when I first started worked in sets but memory eludes me. Instead, I'll go with a simple one: how do I get SQL Server?
For those starting out, look at the following pricing and feature list and develop to your heart's content. Do understand your licensing conditions however, I might have known a company that was mistakenly using Developer licenses in production and had a very costly conversion to Enterprise when their error was called out.
- Free - Express edition (10GB storage limit, optional SSRS (reporting) support)
- Free - Compact edition (Ultra-light weight, see this SO discussion)
- Free - Trial edition (180 day self-expiring full version)
- $37 - Developer edition (full version, not licensed for production environments)
Love what you've seen above? Buy it and move it to a production license.
- $3743 per proc - Workgroup edition (2CPUs, 4GB memory, 524PB storage, vanilla build, has SSRS, no Analysis services)
- $3500 per proc - Web edition (4CPUs, 64GB memory, similar to Workgroup in other regards)
- $7171 per proc - Standard edition (hardware limitations identical to web edition, basic analysis services, stream insight, fuller version of SSRS )
- $27495 per proc - Enterprise edition (8CPUs, 2TB memory, full versions of SSIS, SSRS, SSAS)
- $54999 per proc - Datacenter edition (Same as Enterprise + fancier StreamInsight)
Fairly obvious disclaimer. I am not a lawyer, licensing expert and the above prices reflect today's published prices on the MS website and are subject to change. Also, Azure isn't listed as the cost depends entirely on usage.
Prime take away? If you don't have your own copy, not work's, of SQL Server, drop a few bucks and make your home machine legal. I kept going to release parties hoping to win a copy until I saw the developer cost is a paltry sum in comparison to Visual Studio. At this point in my career however, I've invested in myself and purchased an MSDN license and now I have an all I can eat buffet of MS software.
Updated 2011-06-09 with information regarding Compact Edition
Monday, May 2, 2011
Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One
Or in my case, 9 SQL (Server Integration Services) problems and the disk ain't one. Since I'm speaking at the Lincoln, NE PASS chapter this Thursday so it seems appropriate I should list my 9 problems with SSIS packages
- Hard coded values
- Log free packages
- EncryptSensitiveWithUserKey
- Sort transformation
- Expressions, this package has none
- Package1.save.dtsx; Package1.latest.dtsx; Package1.newest.dtsx; Package1.newer.dtsx;Package1.new.newest.1.dtsx
- OLE DB Command
- Gratuitous use of script task
- Transactions still set as supported
Want to hear me wax about the above? Spend your Cinco de Mayo 2011 in Lincoln Nebraska at the Nebraska Bookstore.
Monday, April 4, 2011
Meme Monday 2011-04-04
Subscribe to:
Comments (Atom)