(Henrik Loeser) Built-in data encryption is a newly available DB2 feature as of today (see this updated fixpack summary page for fixpack 5). Here is a short report on how I tried and succeeded in setting it up and encrypting a new DB2 database on my Linux box. What I did is more or less to follow th
Other News
A Distributed Application Nightmare
The USA released a comprehensive national health insurance enrollment system within the last year as a method for implementing the new laws and regulations for health insurance. The release was poorly received because the application didn’t work effectively on many fronts. I do not know any specifics about the application. But there is a lot that can be known due […]
SSWUGtv: Re-Platforming
Video Programming for IT Professionals
General facts of SQL SERVER – part 4
General facts of SQL SERVER – Part 4 Common language runtime (CLR) The Common Language Runtime (CLR) is an utmost important module of the .NET framework. It offers a podium for the systems to execute. The Common Language Runtime (CLR) offers services like error or bug controlling, safety, correcting the code plus version sustenance to the systems. A number of...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Power BI Semantic Model Supports Many-to-Many Relationships
(Paul Turley) Is it possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional?
SCHEMA Creation, TRANSFER and DROP
(Chandrika Bandi) I am going to give an overview for SCHEMAs in SQL Server, by explaining CREATE , ALTER, DROP schemas.
Archiving Hierarchical, Deleted Transactions Using XML
(Dwain Camps) When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. This can become somewhat complicated if the transaction you need to delete is in a table that is the parent of a deeply nested hierarchy of dependen
Leveraging a Visual Studio Database Project
(Peter Vogel) In my column last month, “Simplifying Development with Database Projects,” I described how to create a Visual Studio database project and I promised that it would make managing changes to your database easier.
WPF Viewbox and Syncfusion Radial Slider
(Ged Mead) Although I’ve already come to the official end of the ‘First WPF Application’ series last month, I couldn’t resist tweaking it some more. One thing I wanted to try was a third party tool from Syncfusion the user can use to select the word length. As it worked out quite well and was refr
Write Yourself a Query Rewrite Plugin: Part 2
(Martin Hansson) In my last post I covered how to use the query rewrite framework to write your own pre-parse plugin. The interface is simplistic: a string goes in, a string comes out, and the rest is up to your plugin’s internal workings. It doesn’t interact that much with the server.