(Dave Beulke) It was informative and fun attending the IOD and IDUG conferences over the last couple of weeks. There were some great presentations at the IDUG and IOD conferences and I started to go through all of them while I was traveling back and forth from Prague and traveling for the Thanksgivi
Other News
Activity Monitor in SQL Server
(Suprotim Agarwal) Activity Monitor is a handy tool in SQL Server to quickly see performance hot spots in the server, network and database activity. One of the most commonly performed tasks in Activity Monitor is to kill a stubborn connection that will not release its resources.
SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event)
(Ana) Sort warnings events will rise when sort operation is performed in a query and it doesn’t fit into memory. In this case, SQL Server needs to spill the sort operation into tempdb which can result in a very slow physical operation especially if multiple passes to tempdb is needed for sorting the
Securing SQL Server: Quick, easy, routinely ignored
(Alan R. Earls) Dan Sherman saw it many times before. The information director for security firm Telos Corp. would do a standard vulnerability assessment with a customer and find a SQL Server database no one knew had been installed — often it was bundled in with Web-based software like Microsoft’s
MySQL foreach()
(Shlomi Noach) A new routine is now available in common_schema, which makes for an easier execution syntax for some operations:
Implement custom query transactions for IBM InfoSphere Master Data Management Server
(Catherine Griffin) Learn how to extend IBM InfoSphere Master Data Management Server by implementing new query transactions using the MDM Server Workbench.
Using LINQ to join data from multiple SQL Servers
(Sherlee Dizon) In my project I need to retrieve and join data from two different SQL Server databases on two different SQL Server instances. The data retrieval can only be done via the existing stored procedures that have been created in these databases. In this tip we look at how we can join two
ScaleBase Rocks the TCP Test
ScaleBase Rocks the TCP Test Are you using MySQL for your relational data engine? Have you exhausted the amount of performance available on a single server? Are you thinking you have to find another implementation, and dreading the thought of modifying all your applications for a new engine? Here is some fantastic news just for you! The latest release of […]
WCF .NET 4.0 Console Hosted Json Rest Secure Http Web Service with Authentication and Roles
(jeremylei) The article covers the creation of a SSL secured .NET 4.0 HTTP JSON REST web service hosted in a console application (non IIS dependent).
An Alternative to truncate for pre v9.7
(samkumar) So many a times people have to truncate a table in run time, i.e. while processing a batch or a temp tabel or while flushing a table which stores some periodic stats etc…