SqlServerKudos

database

1
kudos

Kudos

Master SQL chef series: Designing a best practice approach - Upgrading SQL Server data platform #sql #sql2k8r2cookbook

published 28 days, 21 hours, 10 minutes ago posted by

sa 32 days, 21 hours, 50 minutes ago

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

Kudos

Perform SQL Server Upgrade with the help of tools, best practices too #sqlbpa #upgrade

published 111 days, 4 hours, 32 minutes ago posted by

sa 120 days, 5 hours, 23 minutes ago

Perform SQL Server Upgrade with the help of tools, best practices too #sqlbpa #upgrade

SQL Server upgrade is no small task, no big task either when you have perfectly planned and tested the process! Since last 2 years the most popular topic and talk that I presented in various conferences, usergroup meetings and consulting projects is upgrade of SQL Server platform. Having said that for any task or process you need a trusted and proven set of commands, statements and tools irrespective of hardware configuration or support arrangements (ISV or Managed Services). Whenever I engage with...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners, best practice analyzer, Best Practices, database, DBA, download, SQL Server, Tools, upgrade advisor, upgrade assistant

1
kudos

Kudos

SQL Server Migration Assistant (SSMA) tools to migrate non-MSSQL databases

published 491 days, 8 hours, 12 minutes ago posted by

sa 500 days, 10 hours, 9 minutes ago

SQL Server Migration Assistant (SSMA) tools to migrate non-MSSQL databases

SQL Server Migration Assistant in short SSMA is the migration toolkit that can be used to migrate the databases from Oracle, Sybase, Access and now MySQL too. The recent announcement of SSMA for MySQL is available for download, SSMA reduces the manual process within a database migration and it is not a regular job that every DBA to worry. To avoid any problems you can even use SSMA within your test environment to see whether any compelling issues for data check and other database objects will be...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: code examples, database, database objects, migration, mysql, oracle, power builder, SQL Server, ssma, sybase, Tools

2
kudos

Kudos

Windows IT Pro 2010 Community Choice Awards - Vote for SQLCentric

published 505 days, 9 hours, 9 minutes ago posted by

sa 513 days, 10 hours, 36 minutes ago

Windows IT Pro 2010 Community Choice Awards - Vote for SQLCentric

Windows Magazine network is conducting another series of community choice awards, which is your chance to vote for your favourite product that helped you before and promoting to the community. If you are a DBA then you will know the best results of such community product solutions, I'm not referring about paid third party tools. The tools which are freely available to use. For SQL Server specific you can choose any of the following that appeals to your work: IT Pros: Submit your choices here . Database..... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: community, database, DBA, free tools, performance monitoring, SQL Server, sqlcentric, third party

1
kudos

Kudos

XQuery Lab 57 – Getting Started with OPENXML

published 587 days, 14 hours, 59 minutes ago posted by

sa 596 days, 16 hours, 3 minutes ago

XQuery Lab 57 – Getting Started with OPENXML

This post intends to help you get started with OPENXML() function. OPENXML() lets you shred an XML document or fragment into a result set. Though OPENXML() has got no direct relationship with XQuery, I thought of including it in the XQuery Labs series Read More......(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: #XML, #XQUERY, database, DBA, OPENXML, sp_xml_preparedocument, sp_xml_removedocument, SQLServer, TSQL, XML, xquery, xquery labs

1
kudos

Kudos

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

published 589 days, 15 hours, 9 minutes ago posted by

jacobsebastian 597 days, 17 hours, 14 minutes ago

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

SQL Server uses GUID values to name the FILESTREAM folders and you might find it really hard to relate a folder to a table or column. This post explains how you can do it. (more)

category: Query | clicked: 0 | comment | | source: beyondrelational.com

tags: BLOB, DAC, database, DBA, filestream, SQLServer

2
kudos

Kudos

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

published 590 days, 15 hours, 14 minutes ago posted by

jacobsebastian 599 days, 14 hours, 51 minutes ago

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

In this post, Jason provides a quick overview of SSAS Dimension Attribute properties and provides a wonderful explanation of each property. (more)

category: Warehousing | clicked: 2 | comment | | source: beyondrelational.com

tags: analysis, Cube, Data Mining, Data Warehousing, database, Dimension, SQLServer, SSAS

1
kudos

Kudos

XQuery Lab 56 – Inserting elements with UNICODE values - Jacob's Blog

published 591 days, 15 hours, 19 minutes ago posted by

jacobsebastian 600 days, 14 hours, 52 minutes ago

XQuery Lab 56 – Inserting elements with UNICODE values - Jacob's Blog

This post explains how to write XML DML queries uisng XQuery in TSQL that deals with UNICODE character strings. (more)

category: Query | clicked: 0 | comment | | source: beyondrelational.com

tags: database, SQLServer, unicode, XML, xml dml, xquery

1
kudos

Kudos

T-SQL Enhancements in SQL 2008

published 594 days, 15 hours, 33 minutes ago posted by

jacobsebastian 603 days, 18 hours, 1 minute ago

Seth Phelabaum explains his favorite TSQL programmability enhancements added in SQL Server 2008. (more)

category: Query | clicked: 3 | comment | | source: beyondrelational.com

tags: database, Developer, Programmability, SQL Server, TSQL

1
kudos

Kudos

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

published 596 days, 15 hours, 43 minutes ago posted by

jacobsebastian 605 days, 22 hours, 56 minutes ago

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings. (more)

category: Query | clicked: 1 | comment | | source: beyondrelational.com

tags: Challenge, database, Developer, Puzzle, SQL Server, TSQL

1
kudos

Kudos

Building Products and Building Materials Information Resource - ASC Info

published 613 days, 17 hours ago posted by

building-products 621 days, 18 hours, 29 minutes ago

Building Products and Building Materials Information Resource - ASC Info

The ASC Info database contains more than 30,000 companies and 70,000 products, making it one of the largest sources of building product information worldwide. (more)

category: News | clicked: 0 | comment | | source: www.ascinfo.co.uk

tags: aec, architect, architectural, architecture, ASC, building, catalog, companies, company, construction, database, directory, manufacturer, manufacturers, materials, online, ProductCenter, products, supplier, suppliers

1
kudos

Kudos

SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available

published 617 days, 17 hours, 16 minutes ago posted by

sa 625 days, 16 hours, 34 minutes ago

SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available

Self-Service Business Intelligence is the new solution from SQL Server 2008 R2 that enables the end users to access, analyze and share data across the enterprise in an IT managed environment using Excel 2010 and SharePoint Sever 2010, no need for complex coding techniques. Data Platform Insider blog announces that volume licensing downloads for SQL Server 2008 R2 are available today in all languages, including the public availability of the much anticipated PowerPivot functionality, delivering on...(read... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: business intelligence, database, Excel, powerpivot, powerpoint, self-service, SQL Server, SQL Server 2008 R2, Tools

1
kudos

Kudos

SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download

published 632 days, 18 hours, 23 minutes ago posted by

sa 641 days, 20 hours, 50 minutes ago

SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download

IN contintuation to SQL Server 2008 R2 announcement here is the good news for MSDN & Technet subscribers, see SQL Server 2008 R2 is now available to MSDN and TechNet subscribers go to your relevant subscriptions to download. Don't forget to uninstall the previous & current SQL Server 2008 R2 CTP releases (by taking database backups) and install afresh for further testing. Good luck.... more to come on R2 here!...(read more) (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: backups, best practice, Blocking, database, Installation, r2, SQL Server

1
kudos

Kudos

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

published 706 days, 22 hours, 49 minutes ago posted by

pinaldave 716 days, 19 hours, 20 minutes ago

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra i... (more)

category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: database, pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!

published 746 days, 4 hours, 54 minutes ago posted by

sa 752 days, 8 hours, 34 minutes ago

Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!

Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions! It is quite common scenario that few of Enterprises may not have gone to upto date service pack on SQL Server 2005 which is SP3 & SQL Server 2008 which is SP1. So here is the reminder for you to ensure to upgrade the 2005 & 2008 instances to upto date service packs, by testing them thoroughly which is a best practice....(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, database, rtm, service pack, sp2, SQL Server, Version, year

Welcome!

database

Master SQL chef series: Designing a best practice approach - Upgrading SQL Server data platform #sql #sql2k8r2cookbook

Perform SQL Server Upgrade with the help of tools, best practices too #sqlbpa #upgrade

SQL Server Migration Assistant (SSMA) tools to migrate non-MSSQL databases

Windows IT Pro 2010 Community Choice Awards - Vote for SQLCentric

XQuery Lab 57 – Getting Started with OPENXML

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

XQuery Lab 56 – Inserting elements with UNICODE values - Jacob's Blog

T-SQL Enhancements in SQL 2008

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

Building Products and Building Materials Information Resource - ASC Info

SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available

SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!

Open ID Login

Standard Login

Forgot Password?

Sign up