(Ged Mead) I was looking through some questions I answered a while back and came across this problem where someone wanted to read text from a file, strip out the commas, and then store the individual items in an in-memory List. Here’s the way I did it:
Other News
Restoring a SQL Server Database – A Practical Example
(Satnam Singh) Performing a Database Restore is a part of a DBA’s daily life. A DBA may need to perform a Restore due to various reasons such as recovery, refreshing a database for testing purpose etc. Many times it can be difficult to perform a Restore due to corrupted media, low disk space on the
How MySQL behaves with many schemata, tables and partitions
(Shinguz) Recently a customer claimed that his queries were slow some times and sometimes they were fast.
How to Use Microsoft SQL Server 2012’s Window Functions, Part 1
(Itzik Ben-Gan) SQL Server 2012 (formerly code-named SQL Server Denali) introduces several important T-SQL programmability features; this article focuses on one of those features-window functions. SQL Server 2005 was the first milestone in supporting window functions; it introduced window ranking fu
Binding XML to a WPF DataGrid
(Mamta M) One of the new features in WPF 4 is the DataGrid control. In earlier versions of WPF, developers could only use the DataGrid present in the WPF Toolkit that was available at CodePlex. But now, with WPF 4, developers can make use of DataGrid directly without needing to install the WPF Toolk
Getting a Base Exception
When using a pattern where caught exceptions are wrapped within new exceptions and rethrown, it may be necessary to examine the originating exception object. The Exception class includes a method that makes this simple to achieve.
IBM Cognos Proven Practices: Designing a Successful Performance and Scalability Test for IBM Cognos BI
(Mark Pilon) The purpose of this document is to help guide Performance evaluators with designing a successful Performance, Scalability, and Stability test with IBM Cognos Business Intelligence (BI). It is a very high level approach outlining some key principles of Performance, Scalability, and Stabi
Monitor Your Virtual SQL Server Environment (Part 4 of 5)
(Scott Shaw) Your last tip walked us through the planning stage and now I have a dozen or so virtual SQL Servers under by responsibility. As a DBA do I need to change the way I manage these servers? Is there anything I need to do differently? Check out this tip to learn about monitoring your virtua
Protecting Your Database
SQL Saturday Pre-Conferences (Dec. 8, 2011) SQL Saturday #104 Colorado Springs – Pre-Conference Seminar Opportunity With SolidQ and Confio Software, SSWUG.ORG is proud to partner on sponsoring three pre-conference seminars at the upcoming SQL Saturday #104 in Colorado Springs, Colorado. Enjoy your SQL Server educational options with Glenn Berry’s "Scaling SQL Server," Erik Veerman’s "Data Warehouse Dimensional Design and Architecture […]
Legacy Tools
2012 Class Development Survey – Last Day to Get in When you complete our survey it helps us determine the content areas that are most important to you, as we will develop classes for our Expo next year. In exchange for your time, we are offering 25 free class registrations and/or DVDs at random to those who complete the survey […]