SQL 2014 Express edition limitations

Posted by Deepak Kumar | Posted in SQL DBA | Posted on 03-04-2014

0

SQL 2014 Express edition is free and great head start for small applications or learning purposes. SQL 2014 express is available in 5 variants for more flexibility; its self explanatory names are given below. Each has nearly similar features and limitations except followings. Check the references for detailed list.

  1. Express with Advanced Services (SQLEXPRADV) with features like :Reporting Services feature, Full-text and semantic search, Specification of language in query
  2. SQL Server Management Studio Express (SQLManagementStudio)
  3. Express with Tools (SQLEXPRWT)
  4. Express (SQLEXPR)
  5. LocalDB (SqlLocalDB) a very light weighted edition for development purposes.

before considering SQL 2014 express edition installation, you may want to check limitations:-

  • Database Engine, and Analysis Services: Limited to lesser of 1 Socket or 4 cores
  • Max Memory per instance: 1 GB
  • Max Database size: 10GB (data file size only)
  • Max instance per server: 50

Download SQL 2014 Express Edition
References

 

Free Microsoft eBooks for you!

Posted by Deepak Kumar | Posted in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 01-08-2012

2

Its really amazing to find something for free, isnt it? and if its going to make work life easy and more productive then make more sense! Here goes a post from Eric about Large collection of Free Microsoft eBooks for you, including: SharePoint, Visual Studio, Windows Phone, Windows 8, Office 365, Office 2010, SQL Server 2012, Azure, and more.

Happy Reading..

go to: Link 

Microsoft SQL Server 2008 R2 Service Pack 2

Posted by Deepak Kumar | Posted in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 28-07-2012

1

Microsoft on july 26th announced that SQL server 2008 R2 service pack is now available to download. If you apply this service will upgrade SQL build version to 10.50.4000.0; Also visit this link to find what all bugs have been fixed in this service pack.

 

 

Sql server 2012 certification

Posted by Deepak Kumar | Posted in SQL DBA | Posted on 23-06-2012

2

SQL Server exams are now available since June 11, 2012. Its the show time for all who have been planning for SQL Server 2012 certification! All the best..

Microsoft Certified Solutions Associate (MCSA)
– Direct SQL Server 2012 MCSA Path
Exam 70-461: Querying Microsoft SQL Server 2012
Exam 70-462: Administering Microsoft SQL Server 2012 Databases
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

– Upgrade from SQL 2008 MCITP (Developer or Database Administrator)
Exam 70-457: Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 -Part 1
Exam 70-458: Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 -Part 2
Exam 70-459: Transition your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform

Microsoft Certified Solutions Expert (MCSE)

- MCSE: Data Platform
Exam 70-464: Developing Microsoft SQL Server 2012 Databases
Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012

- MCSE: Business Intelligence
Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Click here fore more details: References

 

What are the common SQL DBA mistakes?

Posted by Deepak Kumar | Posted in SQL BI/DW/SSRS, SQL DBA, SQL Dev | Posted on 21-03-2011

4

On any given production environment a SQL DBA must follow set of best practices to ensure smooth and highly optimized databases availability. Here are few common mistakes that I have identified and would recommend to fix if you have encountered or seeing anything similar.

1. Not preparing and validating a reliable backup and recovery policy with backup files retention period for databases as per agreed data loss and application downtime it may cause while recovering databases.

SQL Server Videos

Posted by Deepak Kumar | Posted in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 19-02-2011

3

Got bored reading Books, PDF files, Articles, Web pages, RSS? Need a change in learning resources? Get more learning from SQL Videos & Demos! 100s of High tech videos explaining how to do, deep dives and internals. Must to watch, download for your free time!

image

SQL Server 2008 Videos and Demos Link
SQL Server 2005 Videos and Demos Link
SQL Server 2008 Microsoft Certified Master (MCM) Readiness Videos Link
SQL Server 2008 Demo Videos and Webcasts Link
SQL Server 2005 Express for Beginners Link
SQL Server 2005 Database Administration Link

Please post or comment, If you have more links to be included.

Tips for Backing up User Databases

Posted by Hemantgiri S. Goswami | Posted in Scripts, SQL DBA, Uncategorized | Posted on 31-01-2011

2

We all take a database backup as a first resort to recover from a damage may occur during the disaster, server crash, or for any other reason. To do so, we usually schedule a job or make use of database maintenance plan that perform database backup, be it Full / Differential or Log, and we all take a special care & consideration while designing the backup strategy!!

But what happened if one fine day when you need your database backup file to work well and it doesn’t?? What if it is corrupted!! And you have only a Full backup for that day?

SQL Server 2008 High Availability – A Book by Hemantgiri S. Goswami

Posted by Hemantgiri S. Goswami | Posted in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 25-01-2011

4

I have no words to explain my excitement and happiness to share news with you all – my book on SQL Server 2008 High Availability is published!!

I have started authoring this book in May 2010 and as the time passes and gradually I move to the final chapter of the book, I was feeling like aha finally it is done!!! – Do you think so, it was this easy? No, every publication house has their own set of rules to be followed while authoring a book and a process to be followed before the chapter or entire book is ready to be published i.e. 1st edit, 2nd edit of the chapter until final edit and the Packt Publication is no exception.

Opportunity to write about Microsoft SQL Server

Posted by Deepak Kumar | Posted in SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 21-01-2011

0

Do you have something to write about SQL Server that can help SQL community by your learning, innovation. R&d, research etc. This is an unique opportunity to reach a large group of SQL Server users, gain experience as SQL writer, publicity and much more.

image

Drop an email with your content/summary to dk@sqlknowledge.com I will review and publish your content on SQLKnowledge.com by your name and provide you instant website access to review, modify & answer user comments on website.

Your comments & suggestions are welcome; Feel free to reply if you have any questions

Download SQL Server Training Kit

Posted by Hemantgiri S. Goswami | Posted in SQL DBA | Posted on 20-01-2011

6

Couple of months back I have wrote a blog article about the availability of Microsoft SQL Server Developer Training Kit which is very helpful resource for the SQL Server Developers, trainers and professionals to understand the improvements comes with the release of SQL Server 2008.

Recently, 18th January 2011 Microsoft has released the updated version of Microsoft SQL Server Developer Training Kit which has

© 2010 SQLKnowledge.com Increase your website traffic with Attracta.com