(Hannes Du Preez) I don’t need to tell most of you how important serialization is in your programs. If today is the first time you come across the term Serialization, I’d suggest reading here before continuing.
Author: SSWUG Research
Pie Charts on SSRS Map Reports
(Jason Thomas) Ok, I think I am getting a few puzzled looks now. All of you must be wondering why I am talking about pie charts (isn’t pie chart the untouchable outcast in the family of visualization techniques?). Also, you must be thinking that there is no possible way you can make pie charts in SS
Writing Dynamic SQL (A how to)
(Kenneth Fisher) A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions for good habits when writing dynamic SQL. Along the same lines, this is my methodology for writing Dynamic SQL. Again this has nothing to do with when it is a good
SQL Server: How Important Are Index Statistics
(Gregory Larsen) Have you ever heard these kinds of comments before? “How come my TSQL statement is running slow today, when just last week it was running fine?” “I have a process that as I add more rows to my table it gets slower and slower?”
Manage CORS policy dynamically
(Xueyuan Dai) We introduced CORS support in ASP.NET Web API a few months ago. Out of the box it supports configuring CORS policy by attributes. It is a very intuitive and powerful way but lacks flexibility at runtime. Imaging your service allows a 3rd party to consume your service. You need the capa
How To Check If A Query Returns Data In ASP.NET Web Pages
(Mike Brind) If you execute a query against a database, you need to know if any data was returned. But what is the best way to test for the presence of data when using the Web Pages Database helper?
Oracle Database 12c: PL/SQL package UTL_CALL_STACK for programmatically inspecting the PL/SQL Call Stack
(Lucas Jellema) Oracle Database 12c ships with a brand new supplied package called UTL_CALL_STACK. This package provides an API for inspecting the PL/SQL Callstack. The package complements the DBMS_ UTILITY.FORMAT_CALL_STACK that returns a pretty print human readable overview of the callstack.
Change VARCHAR2 to 32K – 12c Edition
(Bobby Curtis) Oracle has made a few changes to the database to allow organizations to reduce the cost of migrating to Oracle 12c. One of these changes is with the size limits that have been placed on the VARCHAR2, NVARCHAR2 and RAW data types. In past versions of Oracle database the maximum size
Oracle Database 12c Multitenant Option and Application Express
(Jason Straub) As you probably know by now, Oracle Database 12c was made generally available on Tuesday, June 25th. We will be publishing a detailed page about Application Express in 12c on our OTN page but I wanted to make a couple of points about Application Express in the new multitenant architec
DB2 for z/OS Business Analytics: Moving the Queries to the Data
(Robert Catterall) In the world of business, data has become the coin of the realm. Organizations that effectively leverage their informational assets tend to outperform peers and rivals. Given the value of data in today’s marketplace, it’s no wonder that companies are keenly focused on data securit