Hi SQL Geeks, if you are looking for SQL Server 2012 feature pack; we blogged about it here: http://www.sqlservergeeks.com/blogs/QuickTip/sql-server-bi/523/sql-server-2012-feature-pack But if you are interested in the older versions of feature packs for SQL Server 2008 R2 & SQL Server 2008; follow these links: SQL Server 2008 R2 SP1 feature pack: http://www.microsoft.com/download/en/details.aspx?id=26728 SQL Server 2008 SP3 feature pack: http://www.microsoft.com/download/en/details.aspx?id=2...
Read More
IDC WHITE PAPER - Microsoft SQL Server 2012: Potential Game Changer Hi Friends, The launch of SQL Server 2012 has revealed a major new release with many feature enhancements as well as a new software licensing and pricing approach. For further information, click on this Link: http://services.social.microsoft.com/feeds/FeedItem?feedId=9ad12ff4-34cc-4f25-b933-b349de6fca5c&itemId=4b89b2a2-e00e-47d0-9485-050bd3a31a02&title=IDC+WHITE+PAPER+-+Microsoft+SQL+Server+2012%3a+Potential+Game+Changer...
Microsoft earns Leader ranking in two Gartner 2012 Magic Quadrants Hi Friends, Microsoft has earned the Leader ranking in two Gartner 2012 Magic Quadrants, they are: • Business Intelligence Platforms • Data Warehouse Database Management Systems For further information, refer to these Links: Magic Quadrant for Business Intelligence Platforms (Gartner Research, February 6, 2012) Gartner has positioned Microsoft in the Leaders Quadrant in the 2012 Magic Quadrant for Business Intelligence ...
Many times we use “Execute Package Task” to execute a child package from a parent/wrapper package and we use “Parent Package Variables” as means of configuration for child package. Do you know that we have to keep “ExecuteOutOfProcess” to “False” in order to use parent variables in child package? If we set “ExecuteOutOfProcess” to “True” than parent variables are not visible in child package and configured child’s vari...
This is documented in Microsoft KB article 958004. When you restore a database from 2000 version of SQL Server to ver 2005 (specific builds being SQL Server 2005 build 2191 or later builds of SQL Server 2005 Service Pack 1, SQL Server 2005 Service Pack 2 or later builds), you find inconsistent file growth settings. Read more on this here: http://support.microsoft.com/kb/958004 @SQLServerGeeks
Many of you know that SQL Server 2008 R2 can be installed side-by-side with SQL Server 2008. SQL Server 2008 R2 is a minor release. Since both the versions share the same major version, R2 installation will automatically upgrade the shared components between the two versions. In case you are planning to install R2 along with 2008, you should check out this link: http://msdn.microsoft.com/en-us/library/ee210714.aspx
Want to try out Denali (SQL Server 2012) without installing it? A HyperV image of SQL Server Denali CTP3 in action, including fully configured services and integration with SharePoint 2010 and Office 2010 is available at http://www.microsoft.com/download/en/details.aspx?id=27740 The following software is configured on the virtual machine: SQL Server "Denali" CTP3 SharePoint 2010 Office 2010 Enjoy ! @SQLServerGeeks http://www.FaceBook.com/SQLServerGeeks
The default instance, by default, listens on port 1433. SQL Server can listen on multiple ports on the same IP address. For this you can list the ports separated by commas. For example: 1433,1533,1633. (Note: There is a limitation of 2047 characters.) You can do this from Configuration Manager. To configure SQL Server to listen on multiple ports, the Listen All parameter must also be set to No, on the Protocols Tab of the TCP/IP Properties dialog box.
Did you know that apart from system catalogs, you can also use System Functions like DATABASEPROPERTYEX to extract metadata about a database. For example to find out whether AutoShrink is ON or OFF, you can use the function this way: SELECT DATABASEPROPERTYEX ('AdventureWorks','IsAutoShrink') The function takes in the name of the database and the property name: another example; to find out the status of the database, you can use the function this way: SELECT DATABASEPROPERTYEX ('AdventureWorks',...
Did you know that INFORMATION SCHEMA VIEWS are one of many ways in which you can view SQL Server metadata. INFORMATION SCHEMA VIEWS are included in SQL Server to comply with ISO & ANSI standards. All views are under INFORMATION_SCHEMA schema. For example, if you want to see all the tables in your database, you run the following script: select * from INFORMATION_SCHEMA.TABLES Other ways of browsing meta data are catalog views, compatibility views, etc. Regards Did-You-Know from SQLServerGeeks...
Did you know that Data Mining platform on SQL Server was first released with SQL Server 2000. There were only 2 algorithms at that time. Since the release of SQL Server 2005, there are 9 built-in algorithms now: Microsoft Association Algorithm Microsoft Clustering Algorithm Microsoft Decision Trees Algorithm Microsoft Linear Regression Algorithm Microsoft Logistic Regression Algorithm Microsoft Naive Bayes Algorithm Microsoft Neural Network Algorithm Microsoft Sequence Clustering Algorithm Micro...