(Andrew Reid) A colleague told me about an issue when using export on an Oracle 11.2.0.1 database. He said that if the database contains tables created with segment creation deferred, those tables will not be exported. I decided to check this out.
Author: SSWUG Research
Validating inputs for PATCH requests in ASP.NET WebAPI
(Brock Allen) In ASP.NET WebAPI (with its recent OData additions) there is good support for HTTP PATCH requests via the Delta class. I won’t bother reproducing a tutorial here since there’s already a good one online.
The XML Logger – Revieing the Payload
(Mik) In my last post, I talked about how to capture XML Payloads by splitting large values across a series of DB records. In order to look at the data, we need to reassemble the payloads into a single text blck again.
SQL Server Databases in Recovery Pending state
(Jahith) If you encounter an error database state “Recovery Pending” don’t panic you’re not alone. This is because SQL server has encountered improper shutdown or not mounted properly. Possible reason insufficient permission to the DB file folder may prevent the recovery.
SQL Injection avoidance in SQL Server
(Venkatesan Prabu) The expansion of the Internet has made web applications become a part of everyday life. As a result the numbers of incidents which exploit web application vulnerabilities are increasing. A large percentage of these incidents are SQL Injection attacks which are a serious security t
SSWUGtv: When protecting your data in SQL Server, what are the key things you need to think about? Patrick Townsend offers some great security tips!
Video Programming for IT Professionals
Comparison of Queries Written in T-SQL and SQL Server MDX
(Dallas Snider) Beginning to learn and comprehend SQL Server Analysis Services (SSAS) MDX queries can be difficult after one has spent years writing queries in T-SQL. When trying to write SQL Server MDX queries, oftentimes I would think to myself, “How would I write this query in T-SQL?”
Sign in as a Different User in SharePoint 2013
(Gokan Ozcifci) In Microsoft SharePoint Server 2013, you will notice that the Sign in as Different User menu option is missing. This was a great tool for developers and IT Pro’s who wanted to test their solutions or customizations.
InfoSphere MDM Collaboration Server V10.0 design strategy and implementation, Part 2: A guide to designing and implementing solutions using IBM InfoSphere MDM Collaboration Server v10.0
(Supal Chowdhury and Divakar Maddikera) In Part 1 of this series, a sample business case scenario illustrated the best approach for designing and creating a technical specification of an application using IBM InfoSphere Master Data Management Collaboration Server v10.0. Part 2 examines the implement
N-Tier Architecture and Tips
(Wh5) N-Tier architecture is an industry-proved software architecture model, suitable to support enterprise-level client/server applications by resolving issues like scalability, security, fault tolerance and etc. .NET has many tools and features, but .NET doesn’t have pre-defined ways to guard how