(Tibor Nagy) I have to install a new Microsoft SQL Server box and configure it as a production server. I know that there are many security related settings and I do not want anyone to hack the system on the first day on the network. Which are the basic steps to harden the security of my SQL Server?
Author: SSWUG Research
How rows_sent can be more than rows_examined?
(Peter Zaitsev) When looking at queries that are candidates for optimization I often recommend that people look at rows_sent and rows_examined values as available in the slow query log (as well as some other places). If rows_examined is by far larger than rows_sent, say 100 larger, then the query is
XmlSerializer : Serializing list of interfaces
(Sacha Barber) At work I was stuck with a small problem when working with the XmlSerializer which I have not been using that much of late. Anyway I started out with something like this small demo program below
DB2 with BLU Acceleration and Intel – A great partnership!
(Allen Wei) DB2 with BLU Acceleration is a state of art columnar store RDBMS (Relational Database Management System) master piece that combines and exploits some of the best technologies from IBM and Intel. In the video linked below, there is mention of an 88x speedup when compared with the previous
12c MATCH_RECOGNIZE and the ‘start of group’ method
(stewashton) Please don’t think this post is “just” about row pattern matching and MATCH_RECOGNIZE. I am going to present the “start of group” method as demonstrated by Timur Akhmadeev and Solomon Yakobson. This is a powerful use of analytics to group data based on comparisons between adjacent rows.
What’s New in ASP.NET Web API 2.0
(Pravinkumar Dabade) ASP.NET Web API 2.0 is the latest version in the WebAPI stack and contains some cool new features. In this article, we will explore some of these new features introduced in ASP.NET Web API 2.0
Add User Defined Types
(Michael McLaughlin) Somebody asked me if there was a cheaper alternative to using the Embarcadero Data Architect (a data modeling tool). I said sure, you can use the MySQL Workbench. My friend laughed and said, it’s to model Oracle databases and they use different data types.
Understanding MVC, MVP and MVVM Design Patterns
(Shailendra Chauhan) There are three most popular MV-* design patterns: MVC, MVP and MVVM. These are widely used by the various technologies. In this article, I will provide my opinion on these three.
Dropping all tables from a DB2 schema
(Jack Vamvas) Use this query to select and drop all tables of a schema.
Implementing CRUD Activities in a TypeScript ViewModel
(Peter Vogel) In this column I’m going to show how to integrate create, read, update and delete (CRUD) functionality into your client-side application using TypeScript. But first, I need to address how to integrate your entity objects with the requirements that might be imposed by a JavaScript libra