SqlServerKudos - Stories tagged with SQL Server

SQL Server

atom rss
1
kudos
spam Kudos Remove

SQL Server 2012 releases RTM and Evaluation edition, don't missing virtual event launch 07th March 2012
published 76 days, 19 hours, 13 minutes ago posted by sasa 77 days, 19 hours, 28 minutes ago
Thursday, March 08, 2012 11:03:35 AM GMT Wednesday, March 07, 2012 10:48:41 AM GMT
SQL Server 2012 releases RTM and Evaluation edition, don't missing virtual event launch 07th March 2012
SQL Server 2012 released – out there still organization in process to upgrade to SQL Server 2008 version the next release of product is ready now! In Microsoft's words: The world’s most widely deployed data platform, Microsoft SQL Server 2012, has released to manufacturing (RTM), with an evaluation version available today . General availability will start on April 1. If you want to know more about whats in there with this new release don't forget to register and attend Virtual Launch on 07th March...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: #sql2012, #sqlfamily, beginners, Documentation, new features, SQL Server, sql server 2012, Version, virtual launch
1
kudos
spam Kudos Remove

How to keep a track of list of SQL Server versions and builds releases?
published 117 days, 22 hours, 6 minutes ago posted by sasa 126 days, 22 hours, 36 minutes ago
Friday, January 27, 2012 8:11:09 AM GMT Wednesday, January 18, 2012 7:40:54 AM GMT
How to keep a track of list of SQL Server versions and builds releases?
I believe until SQL Server 2000 (or even SQL 2005) it was easy to remember the release version of your SQL Server instance. Since the changes affected from SQL Server Release Services and inception of Cumulative Update packages it is hard to keep a track of list of builds and version releases. Let it be a controlled installation of service packs and cumulative update packages, you must know the information in order to check what is fixed in the release.In general the best practice is to apply only...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: blogger, cumulative update, database maintenance, DBA, release, service pack, SQL Server, Version
2
kudos
spam Kudos Remove

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook
published 118 days, 22 hours, 11 minutes ago posted by sasa 127 days, 23 hours, 12 minutes ago
Thursday, January 26, 2012 8:06:12 AM GMT Tuesday, January 17, 2012 7:05:16 AM GMT
Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook
Managing multiple instances of SQL Servers and databases is a challenging task, having a third party tool is not a problem however it is always BEST to manage the show using SQL Server Management Studio (SSMS). SQL Server tools are easy to use and help to manage multi-server management through automated multi-server jobs, event forwarding and the ability to manage multiple instances from a single-machine console. Since SQL Server 2008 R2 version (and SQL Server 2008 SP2) onwards the SSMS tool has...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: #sql2k8r2cookbook, beginners, best practice, cookbook, data tier, DBA, management, SQL Server, SSMS, ucp, utility control point
1
kudos
spam Kudos Remove

Cut cost on SQL Server Certified Master lab exam - use remote delivery option, for limited time only! #sqlmcm
published 126 days, 22 hours, 46 minutes ago posted by sasa 131 days, 23 hours, 32 minutes ago
Wednesday, January 18, 2012 7:30:54 AM GMT Friday, January 13, 2012 6:45:28 AM GMT
Cut cost on SQL Server Certified Master lab exam - use remote delivery option, for limited time only! #sqlmcm
The Master blog from Technet announces a wonderful (new year gift) news to the Pros who are willing to attempt the SQLMCM certification exams. If you are taking SQL Server Certified Master lab exam then for a limited time only Microsoft Learning is offering remote delivery of the SQL Certified Master lab exam for a reduced price of US$2000. Altogether Remote Delivery option will cut the costs and better option to take the exam from a quiet location that you desire. The only pre-requisite is you must...(r... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: beginners, bes practice, Certification, cost, microsoft learning, SQL Azure, SQL Server, sqlmcm
1
kudos
spam Kudos Remove

SQL Server Opertional practices: Support ended for SQL Server 2005 Service Pack 3 and its time to upgrade too!
published 131 days, 23 hours, 7 minutes ago posted by sasa 133 days, 23 hours, 37 minutes ago
Friday, January 13, 2012 7:10:26 AM GMT Wednesday, January 11, 2012 6:39:50 AM GMT
SQL Server Opertional practices: Support ended for SQL Server 2005 Service Pack 3 and its time to upgrade too!
As of today the support for SQL Server 2005 Service Pack 3 ends, though the mainstream support for SQL Server 2005 was ended on 12th April 2011. This means only extended support is available for this version until 12th April 2016. Though there is a differnt set of support policy for service pack releases on every Microsoft product, which is nothing but support ends 12 months after next service pack releases or at the end of product's support lifecycle, whichever comes first. You can find more information... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: #sql2k8r2cookbook, administrator, Best Practices, DBA, lifecycle, sp_configure, sp3, SQL Server, support life cycle, Upgrade, upgrade advisor
1
kudos
spam Kudos Remove

Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook
published 131 days, 23 hours, 7 minutes ago posted by sasa 134 days, 23 hours, 42 minutes ago
Friday, January 13, 2012 7:10:26 AM GMT Tuesday, January 10, 2012 6:34:53 AM GMT
Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook
When we talk about availability the key step in providing the feature is to ensure such feature is available and easily implemented. High Availability is purely dependant on hardware and software that will activate the failover or failback whenever the system is affected with the problem. Similarly, more complex and larger a database application, the more important it is to automate administrative tasks with proactive maintenance tasks to ensure data is available. The key factors for hardware and...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: #sql2k8r2cookbook, cookbook, database mirroring, high availability, key, Performance, solution accelerator, SQL Server
1
kudos
spam Kudos Remove

Master SQL Chef series: Implementing Security features #sql #sql2k8r2cookbook
posted by sasa 137 days, 23 hours, 57 minutes ago
Saturday, January 07, 2012 6:20:03 AM GMT
Master SQL Chef series: Implementing Security features #sql #sql2k8r2cookbook
Security is key aspect to restrict access to your data, any platform or database that stores information needs a robuts infrastructure to control the access. The process to access the data will need a secure process or setup the system as 'secure-by-default'. Windows Server 2008 operating system has several configurable features such as platform, architecture and access layer. Similarly SQL Server 2008 also consist similar configurable features such as services, architecture, database objects and...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Best Practices, cookbook, feature, Master Data Management, operating system, policy based framework, Security, SQL Server, windows server
1
kudos
spam Kudos Remove

Master SQL Chef series: Designing automated administration #sql #sql2k8r2cookbook
published 137 days, 23 hours, 32 minutes ago posted by sasa 140 days, 7 minutes ago
Saturday, January 07, 2012 6:45:01 AM GMT Thursday, January 05, 2012 6:10:10 AM GMT
Master SQL Chef series: Designing automated administration #sql #sql2k8r2cookbook
The administrative tasks such as managing backups, jobs, alerts and database maintenance activites are essential for every DBA. The tasks will be more complex and larger when the data platform is spread across the Enterprise, key task is to be able to automate the routine tasks and develop proactive maintenance to ensure that data availability and integrity is maintained without any interruption. The management of automated processes is a different topic and in order to accomplish part of the task...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: automated administration, Best Practices, builtin, cookbook, Jobs, policy based framework, schedule, Security, SQL Server, system
1
kudos
spam Kudos Remove

Master SQL chef series: Designing a best practice approach - Upgrading SQL Server data platform #sql #sql2k8r2cookbook
published 137 days, 23 hours, 32 minutes ago posted by sasa 142 days, 12 minutes ago
Saturday, January 07, 2012 6:45:01 AM GMT Tuesday, January 03, 2012 6:04:32 AM GMT
Master SQL chef series: Designing a best practice approach - Upgrading SQL Server data platform #sql #sql2k8r2cookbook
There is no doubt that SQL Server users have been keeping up their knowledge up to the level since last few years (at least since 2008 version release). In this regard the Upgrade of SQL Server data platform has taken utmost priority that can offer advantage of new features and enhancements/automation to existing processes that will keep up the availability & scalability. The initial and important aspect of SQL Server platform upgrade is to manage the steps with a prior planning, to prepare for...(read m... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: #sql2k8r2cookbook, best practice, cookbook, database, deprecated features, discontinued featuers, platform, SQL Server, Updates, upgrade advisor
1
kudos
spam Kudos Remove

Cumulative Update package 11 for SQL Server 2008 R2 is available for download
published 148 days, 13 minutes ago posted by sasa 155 days, 1 hour, 8 minutes ago
Wednesday, December 28, 2011 6:04:06 AM GMT Wednesday, December 21, 2011 5:08:47 AM GMT
Cumulative Update package 11 for SQL Server 2008 R2 is available for download
The latest instalment of Cumulative Update package for SQL Server 2008 R2 is available for download, before implement it on production make sure you test the installation. Build 10.50.1809.0 (cumulative update) and the parent build of this build is 10.50.1807.0. The list of issues are as follows with their KBA: VSTS bug number KB article number Description 834627 955850 (http://support.microsoft.com/kb/955850/ ) Error message when you try to use the binaries from the SQL Server System CLR Types package..... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: access, Best Practices, cumulative update, Documentation, downgrade, download, linked server, SQL Server
1
kudos
spam Kudos Remove

Microsoft Assessment and Planning Toolkit 6.5 Now Available for Download
published 160 days, 1 hour, 8 minutes ago posted by sasa 167 days, 2 hours, 3 minutes ago
Friday, December 16, 2011 5:09:02 AM GMT Friday, December 09, 2011 4:13:43 AM GMT
Microsoft Assessment and Planning Toolkit 6.5 Now Available for Download
Microsoft Assessment and Planning (MAP) toolkit helps the migration of your IT environment, in specific I use this product whenever a database and instance upgrade projct is planned. The MAP 6.5 adds the cloud migration planning too, that confirms journey to the cloud is now smoother than ever with the MAP Toolkit 6.5. The new features include securely assess the enviornment while enabling the workload evaluation for migration to private or public 'cloud' platforms. For me the most interesting part...(re... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: accleration, Azure, Best Practices, enterprise, map, planning, SQL Server, toolkit
1
kudos
spam Kudos Remove

SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory
published 177 days, 2 hours, 19 minutes ago posted by sasa 180 days, 3 hours, 4 minutes ago
Tuesday, November 29, 2011 3:57:46 AM GMT Saturday, November 26, 2011 3:12:58 AM GMT
SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory
A discussion about trace flags 845 lead to explain the information about the requirement and necessity in case of 32 bit and 64 bit environments. The Lock Pages in Memory has gained importance since version 2005 due to the fact that 32-bit and 64-bit environments are managed. As you may be aware it was only available in Enterprise and Developer editions, since CU4 for SQL Server 2005 SP3 and CU2 for SQL Server 2008 SP1 it is enabled as a trace flag 845 for Standard Edition environment too. Lock Pages...(... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: benchmarking, Best Practices, configuration, cumulative update, lock down, lock pages in memory, performance monitoring, Security, SQL Server, Version
1
kudos
spam Kudos Remove

Super save promotion: Get 40% off on all e-books from Packt Publishers, grab it for world class SQL Server books
published 177 days, 2 hours, 19 minutes ago posted by sasa 182 days, 2 hours, 34 minutes ago
Tuesday, November 29, 2011 3:57:46 AM GMT Thursday, November 24, 2011 3:43:04 AM GMT
Super save promotion: Get 40% off on all e-books from Packt Publishers, grab it for world class SQL Server books
As a part of Super save promotion you have a golden choice to grab 40% discount straight on all e-books that are available from Packt Publishers . So browse through the library of eBooks and choose your favourite ones to get 40% off on the price, to get it enter the code APMD40 at 'Enter promotion code' field or click on 'Add promotion code' where the discount will be applied. Not to mention you can get my book too, titled: SQL Server 2008 R2 Administration cookbook and browse through list of books...(re... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: architects, beginners in sql serever, bes practice, books, code, cookbook, DBA, devloper, disaster recovery, ebook, packt, SQL Server
1
kudos
spam Kudos Remove

Cumulative Update #7 for SQL Server 2008 Service Pack 2 is available for download
published 178 days, 2 hours, 24 minutes ago posted by sasa 183 days, 2 hours, 15 minutes ago
Monday, November 28, 2011 3:52:49 AM GMT Wednesday, November 23, 2011 4:02:23 AM GMT
Cumulative Update #7 for SQL Server 2008 Service Pack 2 is available for download
The next instalment of Cumulative Update package for SQL Server 2008 Service Pack 2 is availabel for download, the build number for this CU7 will be 10.00.4323. Further the cumulative update package includes updates for all the component packages. However, a cumulative update package updates only those components that are installed on a system. You cannot apply this CU7 straight away, the pre-requisite is SQL 2008 SP2. Here is the big list of bugs and issues fixed with this CU7 for SQL2008 SP2: VSTS...(r... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: .dll, access violation, catalogs, cumulative update, downgrade, downloadl, full-text, oledb, packages, sp2, SQL Server
1
kudos
spam Kudos Remove

Cumulative Update #2 for SQL Server 2008 Service Pack 3 available for download
published 178 days, 2 hours, 24 minutes ago posted by sasa 183 days, 3 hours, 20 minutes ago
Monday, November 28, 2011 3:52:49 AM GMT Wednesday, November 23, 2011 2:57:24 AM GMT
Cumulative Update #2 for SQL Server 2008 Service Pack 3 available for download
Another instalment of Cumulative Update package for SQL Server 2008 SP3 is available now, which is CU2 and the build number is known as 10.00.5768.00. As usual this CU2 for SQL2008 SP3 contains hotfixes for issues that were fixed after the release of SQL Server 2008 Service Pack 3 (SP3). KBA2633143 list the following article numbers about more information on the fixes: VSTS bug number KB article number Description 794387 2522893 (http://support.microsoft.com/kb/2522893/ ) FIX: A backup operation...(read ... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: access denied, access violation, Backup, Best Practices, CLR, cu2, cumulative update, downgrade, incremental service, sp3, SQL Server, stored procedure
1
kudos
spam Kudos Remove

Microsoft SQL Server 2012 RC0 available for download
published 182 days, 2 hours, 44 minutes ago posted by sasa 188 days, 3 hours, 44 minutes ago
Thursday, November 24, 2011 3:33:03 AM GMT Friday, November 18, 2011 2:32:41 AM GMT
Microsoft SQL Server 2012 RC0 available for download
Well here it is the next version of SQL Server is getting out step by step, few months ago CTP3 and now Release Candidation 0 is available for download. The version number will be 11.0.1750.32, make a note of it. Microsoft SQL Server 2012 RC0 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization. Quick details Version: 11.0.1750.32 Date Published: 11/17/2011 Change Language: Chinese (Simplified) Chinese (Traditional) English French...... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: cloud, Documentation, download, index hint, Master Data Management, rc0, relationship, release candidate, SQL Server, sql server 2012, SSIS
1
kudos
spam Kudos Remove

SQL Server Days 2011 – Last Chance to Register
published 191 days, 3 hours, 20 minutes ago posted by sasa 197 days, 3 hours, 23 minutes ago
Tuesday, November 15, 2011 2:57:06 AM GMT Wednesday, November 09, 2011 2:54:05 AM GMT
SQL Server Days 2011 – Last Chance to Register
. SQL Server Days 2011 – Last Chance to Register One more week before the SQL Server Days. The team at SQLUG.be together with our partners and speakers are ready to deliver another spectacular edition. We have over 250 people registered so far, so don't hesitate and register now if you want to be part of this two-day event. Join us on 14/15 November 2011 at San Marco Village in Schelle to learn all about best practices for SQL Server 2008 R2 and all about the upcoming SQL Server 2012. With four tracks...... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: 2012, Conference, DBA, learning, mvp, new features, SQL Server, sqlug
1
kudos
spam Kudos Remove

SQL Server 2012 Developer Training Kit Web Installer Preview
published 192 days, 3 hours, 25 minutes ago posted by sasa 197 days, 4 hours, 28 minutes ago
Monday, November 14, 2011 2:52:09 AM GMT Wednesday, November 09, 2011 1:49:06 AM GMT
SQL Server 2012 Developer Training Kit Web Installer Preview
The product guide and Developer trianing kit are very usefl to get to know on the new product features. In this regard we got a SQL Server 2012 Developer training kit that is designed to learn about 2012 solutions and features, as a web installer preview which mean its an on-demand download to use with web installer preview. Download SQL 2012 Developer Training kit web-installer preview and also Microsoft® SQL Server® code name 'Denali', Community Technology Preview 3 (CTP 3) Product Guide › Microsoft®..... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: ctp, developer training kit, product release, SQL Server, sql2012, standard
1
kudos
spam Kudos Remove

SQL Server 2012 editions licensing overview - changes, good and great
published 197 days, 4 hours, 13 minutes ago posted by sasa 202 days, 4 hours, 48 minutes ago
Wednesday, November 09, 2011 2:04:04 AM GMT Friday, November 04, 2011 1:29:22 AM GMT
SQL Server 2012 editions licensing overview - changes, good and great
SQL Server 2012 is a big release compared to what we have seen from 2005 to 2008, though R2 has been an additional release with BI capabilities. Now SQL 2012 equipped with much more enhancements and new features to manage your data platform. In specific to this release its good to know about new edition in SQL Server 2012 Business Intelligence, so it keeps 3 core editions Enterprise, Business Intelligence and Standard. The new licensing method from 2012 version will be as follows: Licensing by computing.... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: cal, editions, faq, licensing, new features, processor, software assurance, SQL Server, sql server 2012
1
kudos
spam Kudos Remove

SQL Server 2008 R2: OLE DB provider "SQLNCLI10" for linked server "x" reported a change in schema version between compile time and run time
published 197 days, 4 hours, 13 minutes ago posted by sasa 202 days, 5 hours, 53 minutes ago
Wednesday, November 09, 2011 2:04:04 AM GMT Friday, November 04, 2011 12:24:23 AM GMT
SQL Server 2008 R2: OLE DB provider "SQLNCLI10" for linked server "x" reported a change in schema version between compile time and run time
The OLEDB provider for the linked server reported a change in schema version between compile time and execution time. For a moment the error throws out spanner in works, application stalls and complaints about timeout issues. A search on forums reveals its a real problem when you perform changes to table schema with REORG or column change in an object. A REORG is quite common on a production environment but not that schema changes, which is managed as a seperate implementation. See this SQLConnect...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: compile time, cumulative update, driver, execution time, kba, linked server, maintenance plan, oledb, schema changes, service pack, SQL Server
Previous 1 2 3 4 5 6 7 8 9 10 ... 19 20 Next