With SQL Server 2014 released, there's the temptation to upgrade for many DBAs. However the licensing costs and debatable improvements in the product will temper the DBA's enthusiasm with the reality of the ROI seen by management. While reading about the licensing changes, I also saw this note from Tom LaRock, where he wrote about the features most of us aren't using. It made me think about upgrades, and perhaps the strategy Microsoft is employing.
As Tom mentioned, the features not being used are Enterprise Edition features. This prevents many of us from upgrading to use them because Enterprise Edition is so expensive. Actually, even Standard Edition is expansive these days, given the per-core licensing, and I suspect lots of companies with SQL Server 2008, 2005, even 2000 are debating whether or not the upgrade is really worth the cost.
The piece also mentions that Azure is much less expensive in the short term, and you should consider it. Of course at some point the money you pay will be more than buying a license and a server, but that assumes you run them for the same length of time. You'll likely upgrade at some point, and if you upgrade both hardware and software, the cloud starts to look more attractive.
It's not simple to move into the cloud, nor is it appropriate for some applications, but it does seem that Microsoft would prefer to have most companies running in Azure, on a single platform they run, they patch, and they support. Many companies might prefer the same thing, though I do worry that we might find the on-premises version of many products becoming second class citizens. Vendors will spend less on development and support if too many customers move to the cloud.
Inevitably, every DBA is eventually asked to delete, merge, or otherwise report on duplicate data. There are many tools at our disposal to make this task both simple and efficient to complete. Read on for simple steps and examples to effectively deal with duplicate data. More »
Test-driven development is often taught using simple examples, such as calculating the scores for a game of ten-pin bowling. Using the same practice effectively on a real code base isn’t as easy. This article covers some of the questions that arise when dealing with larger code bases and changing requirements. More »
Expert Cube Development with SSAS Multidimensional Models will teach you tips and tricks for cube design from some of the most experienced Analysis Services experts in the world. Topics covered include designing dimensions and cubes, implementing common MDX calculations, security and performance tuning. Get your copy from Amazon today.
IT Bootcamp Training from Mercury Solutions
- [b]Bookmybootcamp.com[url=http://bookmybootcamp.com][/url][/b] is the brain child of Mercury Solutions Limited, a leading offshore training provider in India. We offer both open...
- use msdb
(select sysjobs.name as [Job Name], sysjobservers.Last_run_outcome, sysjobservers.last_outcome_message, sysjobservers.last_run_date --sysjobschedules.next_run_date
inner join sysjobservers on sysjobservers.job_id = sysjobs.job_id
where last_outcome_message like...
Left join or not Left join ?
I'm requesting your help for any ideas that could help me to do a better query, I'm trying to match...
update query very slow sql server
- Dear friends,
my table have 100000000 records. i update the data with query like
recursive queries - parent child
- Hi everyone i need to make some parent-child transformation.
here is test input data:
CREATE TABLE #TestTable(
[Code7] [varchar](7) NOT NULL,
[Code1] [varchar](1) NOT...
Insert triggers updating an audit table
Apologies if this is in the incorrect forum.
I have created a trigger using the below code:
CREATE TRIGGER [TriggerName]
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.