SSWUGtv With Stephen Wynkoop Do you think Big Data should impact your privacy practices? Find out in this recent edition of SSWUGtv Watch the Show] Usage of TVP Can Fail Table Value Parameters (TVP) are a technique for passing a table as an input value to a stored procedure or a function. They are supported in SQL Server as of […]
Other News
Adding Code Examples to Documentation Comments
(Richard Carr) Documentation for code libraries is generally improved with the addition of sample code that shows how those libraries are used. When using XML documentation comments, three tags can be used to incorporate examples within the compiled help file.
Cleaning up ASP.NET MVC Controllers
(Paul Stovell) I’ve been working with ASP.NET MVC on a few different projects now, and yet I’ve never been happy with my controllers. My view models were normally pretty simple, but my controllers, especially when saving, were starting to feel like spaghetti.
Moving WebSphere Commerce Users From One Database to Another Across Versions
(Ember Crooks) This post is specific to WebSphere Commerce. In my experience, usually when Clients upgrade from one WebSphere Commerce version to another (with 6 to 7 being the current focus), they also upgrade or change DB2, the OS, the Hardware – basically everything. To that end my upgrade experi
RAC/Exadata Shell Aliases
(Martin Nash) I’ve been working on Oracle RAC systems for a while now and the subject of how best to setup shell environment variables and aliases seems to be something that there is a fair range of opinion on.
Automate Database Backups with MySqlDump and PowerShell
(Rob Gravelle) One of the Database Administrator (DBA)’s most important duties is performing regular scheduled database backups. Equally important is the maintenance of the backup files and practicing of the restoration procedure. All in all, it can be a time intensive endeavor.
Benefits of Using Mount Points with SQL Server Clusters
(Dan Quinones) The traditional configuration of a letter assigned for each volume on a Windows Server imposes limitations on our SQL Server cluster design. The primary constraint is the twenty-six letters in the alphabet limiting us to that number of drives that our server can use.
How to validate XML data using XSD in Oracle XML DB
(Frank Zhou) The following XML Schema can be used to validate the XML input data in the XML DB.
How To Disable SELECT COUNT Execution for ADF Table Rendering
(Andrejus Baranovskis) If you analyze SQL execution, you will see there is difference between ADF form and ADF table rendering. When rendering ADF form – there is one SQL statement executed, to retrieve data. Things are a bit different for ADF table – framework executes two SQL statements while rend
Logging and Tracing WCF Soap Messages
(Md. Rashim uddin) Today my team lead shoves me into an R&D to trace and log WCF soap messages. Then I have started reading different blog post and books as well. After reading couple of useful blogs specially my favorite one MSDN I come across the solutions that I want to share with you guys.