SqlServerKudos

News

1
kudos

Kudos

Using the XMLTable() Function

published 687 days, 3 hours, 31 minutes ago posted by

sa 696 days, 5 hours, 6 minutes ago

A few weeks back, I published a function named XMLTable() that helps to query XML documents easily. The idea behind the function is to be able to blindly query XML documents just like you do a ‘SELECT *’ on a relational table. Not only that this function Read More......(read more) (more)

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

tags: SQLAuthority, SQLServer, TSQL, XML, xquery

1
kudos

Kudos

SSD drives - Oh my goodness

published 687 days, 3 hours, 31 minutes ago posted by

sa 696 days, 6 hours, 11 minutes ago

I just bought my second set of SSD drives. I bought a set a few years ago but didn’t really use them and I tend to think they degraded over time. The new ones I’ve bought are OCZ Vertex 2 240GB versions. http://www.overclockers.co.uk/showproduct.php?prodid...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

1
kudos

Kudos

SQL Server 2008 R2 Update for Developers Training Kit get June 2010 Update

published 689 days, 3 hours, 41 minutes ago posted by

sa 697 days, 3 hours, 31 minutes ago

SQL Server 2008 R2 Update for Developers Training Kit get June 2010 Update

Are you interested to obtain a training kit to update your SQL Server 2008 R2 knowledge? Then here is the elegant way to obtain such resources from Developer & Platform Evangelism team, there are array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008...(read more) (more)

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

tags: beginners, best practice, demos, developer training kit, hands-on, learning, presentation, SQL Server, Training, version 2008, Video

1
kudos

Kudos

Developer training kits to download for your learning upgrade

published 689 days, 3 hours, 41 minutes ago posted by

sa 697 days, 4 hours, 36 minutes ago

Developer training kits to download for your learning upgrade

Here is an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008, Visual Studio 2010, .NET framework 4, Windows Server 2008 R2 & Windows Azure platform. Microsoft's Developer & Platform Evangelism team has brought good resources for you to downlod the content and upgrade your knowledge at your own pace: Visual Studio 2010 and .NET Framework 4 Training Kit Windows Server 2008 R2 Developer Training Silverlight 4 Training Hands-On Labs...(read more) (more)

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

tags: .net framework 4, Best Practices, kit, learning, microsoft, SQL Server, SQL Server 2008 R2, training course, Upgrade, visual studio 2010

1
kudos

Kudos

SQL Server Hardware Checklist - a primer for DBA

published 689 days, 3 hours, 41 minutes ago posted by

sa 697 days, 5 hours, 41 minutes ago

SQL Server Hardware Checklist - a primer for DBA

Every once in a while you might get into complexity in managing a process, even though it is a simple one! So this is where a checklist will come handy to ensure you do not commit any 'blunders' on your day-to-day business.You may relate the DBA checklist to Airline pilot's checklist who will always perform the drill without having any miss of list of chores when they fly. For every DBA a checklist to manage the platform is very helpful, I do have a list of points that I form as a checklist whenever...(r... (more)

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

tags: Best Practices, checklist, compatability, configuration, DBA, Hardware, SAN, setup, SQL Server

1
kudos

Kudos

SQL Server 2008 Best Practices Analyzer (BPA) available for download

published 689 days, 3 hours, 41 minutes ago posted by

sa 698 days, 4 hours, 41 minutes ago

SQL Server 2008 Best Practices Analyzer (BPA) available for download

In followup to the SQL Server 2008 Best Practices Analyzer - keep an eye for the release post here, CSS SQL Server Engineers from PSSQL blog have announced that final development and testing were completed on the tool and it is now available for you to download at this location . The BPA tool gone through an overhaul from CSS SQL team on rules logic, design and guidance for known configuration settings, so it is nothing but scanning and getting most of real-world review of your environment. Also...(read ... (more)

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

tags: best practice analyzer, bpa, Compatibility, DBA, Documentation, download, policy based framework, rules, Security, SQL Server, Tool

1
kudos

Kudos

SQL HA: Quick troubleshooting technique review of ENDPOINT within Database Mirroring partners

published 689 days, 3 hours, 41 minutes ago posted by

sa 698 days, 5 hours, 46 minutes ago

SQL HA: Quick troubleshooting technique review of ENDPOINT within Database Mirroring partners

Thanks for the feedback and followup questions from the SQL Server HA: Quick view of Database Mirroring session between partners post here. From the majority of the followup questions the main topic is to asking process on how quickly you can find the issue within the SQL Server database mirroring environment. Here is a quick notes on what you need to go through if there is a problem reported within the database mirroring partners. Database Mirroring monitor is the first hand tool to see the status...(re... (more)

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

tags: Best Practices, database mirroring, endpoint, firewall, ports, service account, SQL Server, tcp, Troubleshooting

1
kudos

Kudos

SQL Server managability on performance: Tackle Deadlock issues when using JDBC drivers

published 691 days, 3 hours, 46 minutes ago posted by

sa 701 days, 2 hours, 46 minutes ago

SQL Server managability on performance: Tackle Deadlock issues when using JDBC drivers

In the recent times I had been through a peculiar performance issue where the application has been designed with Jave & Websphere application has been used having SQL Server as backend to store data. The problem is a mixture of performance and deadlock issues within SQL Server causing more chaos, going back to basics the deadlock is a condition that occurs on the system with multiple threads and database systems are no stranger. During this time the system resources are used heavily and sometimes...(read... (more)

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

tags: Collation, deadlock, driver, Java, JDBC, lock down, performance monitoring, SQL Server

1
kudos

Kudos

FILESTREAM directory structure - where do the GUIDs come from?

published 692 days, 3 hours, 51 minutes ago posted by

sa 701 days, 3 hours, 51 minutes ago

FILESTREAM directory structure - where do the GUIDs come from?

One of the questions that might come to your mind while getting started with FILESTREAM is the way FILESTREAM directories and files are named. Within the FILESTREAM Data Container, SQL Server creates a root folder per FILESTREAM enabled table. If the Read More......(read more) (more)

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

tags: DAC, filestream, SQLServer, TSQL

1
kudos

Kudos

XQuery Lab 57 – Getting Started with OPENXML

published 692 days, 3 hours, 51 minutes ago posted by

sa 701 days, 4 hours, 56 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

Understanding Datetime column - Part II

published 693 days, 3 hours, 56 minutes ago posted by

sa 701 days, 6 hours, 1 minute ago

This post follows my blog post Understanding datetime column part I Date Formats Unambiguous formats YYYYMMDD HH:MM:SS YYYY-MM-DDTHH:MM:SS Ambiguous formats DD/MM/YYYY MM/DD/YYYY DD-MM-YYYY MM-DD-YYYY YYYY-MM-DD etc Someone wants to input dates in DD/MM/YYYY Read More......(read more) (more)

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

tags: BRH, DataTypes, date, DateTime, SQL Server, time, TSQL

1
kudos

Kudos

SQL Server HA: Quick view of Database Mirroring session between partners

published 694 days, 4 hours, 1 minute ago posted by

sa 702 days, 5 hours, 6 minutes ago

SQL Server HA: Quick view of Database Mirroring session between partners

From SQL Server 2005 version onwards database mirroring has been a good resource to provide High Availablity for the systems without having special hardware requirement. While I was assisting at the SME lounge within Database Platform area in Tech-Ed North America conference, I had few interesting questions from the users asking about various methods to monitor database mirroring environment. Database Mirroring Monitor is the tool which is a first hand resource to see what is happening within the...(read... (more)

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

tags: database mirroring, DBA, endpoint, instances, Monitoring, Performance, SQL Server, Troubleshooting

1
kudos

Kudos

Understanding Datetime column - Part II

published 695 days, 4 hours, 6 minutes ago posted by

sa 702 days, 6 hours, 11 minutes ago

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

tags: BRH, DataTypes, date, DateTime, SQL Server, time, TSQL

1
kudos

Kudos

Control database management tasks from command line - SQLCMD

published 695 days, 4 hours, 6 minutes ago posted by

sa 703 days, 6 hours, 20 minutes ago

Control database management tasks from command line - SQLCMD

If you remember ISQL or OSQL then you should continue using SQLCmd from SQL Server 2005 onwards, an useful utility lets you enter TSQL statements, system procedures, and script files at the command prompt. Not only as a command line from outside of SQL process, you can run this tool from SSMS Query Editor in SQLCMD mode, in a Windows script file or even in an operating system (Cmd.exe) job step of a SQL Server Agent job. In the recent connection with a client about Database upgrade project, it has...(rea... (more)

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

tags: behaviour changes, Best Practices, code, command prompt, execution, SQL Server, sqlcmd, TSQL

1
kudos

Kudos

What are events SQL profiler eventclass numbers 65527,65528,65533,65534

published 699 days, 4 hours, 26 minutes ago posted by

sa 708 days, 4 hours, 57 minutes ago

What are events SQL profiler eventclass numbers 65527,65528,65533,65534

I’ve been trying to use RML to process some files and couldn’t figure out why the numbers where all so much smaller than they should be. I then found a line in the RML output “Found [TRACE_STOP] event indicating the end of the trace files” This causes...(read more) (more)

category: News | clicked: 1 | comment | | source: sqlblogcasts.com

1
kudos

Kudos

Slipstream and StreamInsight - SQL Server new features for your advantage

published 699 days, 4 hours, 26 minutes ago posted by

sa 708 days, 6 hours, 2 minutes ago

Slipstream and StreamInsight - SQL Server new features for your advantage

Slipstream and StreamInsight, for a second both of them sound similar and you may think they are same too. For my session at Microsoft Tech-Ed North America 2010 - SQL Server Upgrade, 2000 - 2005 - 2008: Notes and Best Practices from the Field we had a good feedback from the users, waiting to get answer for their questions (after the session) and clarifying their doubts from the Database Platform booth at Tech-Ed Exhibition hall. Keeping that aside I had that embarassing moment (for a second) when...(rea... (more)

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

tags: Best Practices, downgrade, installallation, merge drop, slipstream, SQL Server, support

1
kudos

Kudos

StreamInsight is in all editions (except express)

published 699 days, 4 hours, 26 minutes ago posted by

sa 708 days, 7 hours, 7 minutes ago

StreamInsight is in all editions (except express)

Contrary to many posts and even press releases from Microsoft StreamInsight is not just for Data Center edition. It is available in all paid for editions. If you read the license terms http://go.microsoft.com/fwlink/?LinkID=186261&clcid=0x409 you...(read more) (more)

category: News | clicked: 4 | comment | | source: sqlblogcasts.com

tags: SQL Server 2008 R2, streaminsight

1
kudos

Kudos

StreamInsight SQL Social Followup

published 700 days, 4 hours, 31 minutes ago posted by

sa 709 days, 7 hours, 12 minutes ago

Thank you for those that attended the SQL Social last night I hope you enjoyed it. When I get presentation details from the team I will pass them on, meanwhile have a look at their blog http://blogs.msdn.com/b/streaminsight/ which has details of most...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

1
kudos

Kudos

Microsoft Security Bulletin Summary for June 2010 - Bulletin MS10-033

published 701 days, 4 hours, 36 minutes ago posted by

sa 710 days, 5 hours, 7 minutes ago

Microsoft Security Bulletin Summary for June 2010 - Bulletin MS10-033

This bulletin summary lists security bulletins released for June 2010. The full version of the Microsoft Security Bulletin Summary for June 2010 can be found at http://www.microsoft.com/technet/security/bulletin/ms10-jun.mspx . With the release of the bulletins for June 2010, this bulletin summary replaces the bulletin advance notification originally issued on June 3, 2010. For more information about the bulletin advance notification service, see http://www.microsoft.com/technet/security/Bulletin/advance... (more)

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

tags: bulletin, download, microsoft, notification, search, Security, team, technical, update

1
kudos

Kudos

Replication and SQL Server Upgrades :: Scottish Area SQL Server User Group Meeting, Edinburgh - Monday 28th June

published 701 days, 4 hours, 36 minutes ago posted by

sa 710 days, 6 hours, 12 minutes ago

Replication and SQL Server Upgrades :: Scottish Area SQL Server User Group Meeting, Edinburgh - Monday 28th June

Register for Event LiveMeeting Attendee URL Click here to join Meeting Time Starts (UK time) at 18:00 , Finishes 21:00 Cost Free Organiser UK SQL Server User Group Address Microsoft Edinburgh, Waverley Gate, 2-4 Waterloo Place, Edinburgh, EH1 3EG Directions to Event Agenda 18:15 - 18:45 - Introduction, Networking and Food 18:45 - 19:45 – This presentation on Replication will start with an overview of the various SQL Server replication models: Snapshot, Transactional, Merge with Peer-Peer added in...(read... (more)

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

tags: Conference, replication, reporting, sassug, scotland, SQL Server, Upgrade, usergroup

Welcome!

News

Using the XMLTable() Function

SSD drives - Oh my goodness

SQL Server 2008 R2 Update for Developers Training Kit get June 2010 Update

Developer training kits to download for your learning upgrade

SQL Server Hardware Checklist - a primer for DBA

SQL Server 2008 Best Practices Analyzer (BPA) available for download

SQL HA: Quick troubleshooting technique review of ENDPOINT within Database Mirroring partners

SQL Server managability on performance: Tackle Deadlock issues when using JDBC drivers

FILESTREAM directory structure - where do the GUIDs come from?

XQuery Lab 57 – Getting Started with OPENXML

Understanding Datetime column - Part II

SQL Server HA: Quick view of Database Mirroring session between partners

Understanding Datetime column - Part II

Control database management tasks from command line - SQLCMD

What are events SQL profiler eventclass numbers 65527,65528,65533,65534

Slipstream and StreamInsight - SQL Server new features for your advantage

StreamInsight is in all editions (except express)

StreamInsight SQL Social Followup

Microsoft Security Bulletin Summary for June 2010 - Bulletin MS10-033

Replication and SQL Server Upgrades :: Scottish Area SQL Server User Group Meeting, Edinburgh - Monday 28th June

Open ID Login

Standard Login

Forgot Password?

Sign up