(Mike Chapple) Tables serve as the basic unit of organization for any database, including those managed by SQL Server 2012. Designing appropriate tables to store your data is an essential responsibility of a database developer and both designers and administrators must be familiar with the process o
Author: SSWUG Research
SSIS: Update & Insert to same table in Data Flow task causing ‘This operation conflicts with another pending operation on this transaction. The operation failed.’
(Dilkush) Consider below SSIS Package, Single Data Flow task which has
How to Use Microsoft’s AMR Tool
(Greg Larsen) In order to help DBAs determine which tables and stored procedures might be good to take advantage of using the new In-Memory OLTP tables in SQL Server 2014, Microsoft introduced the AMR Utility. AMR stands for Analyze, Migrate, and Report. In this article I will be exploring how to
SQL Server 2014 Backup to URL
(Grant Fritchey) I’m absolutely in love with the concept of being able to create a backup directly to a protected, off-site location. Yeah, you can spend all sorts of money on terribly wonderful technology to enable that within your enterprise. And if you have that kind of money, great. But, what if
Killing memory usage with dynamically generated assemblies
(Ben Emmett) There’s a nasty memory leak which the .NET Framework can suffer from when using certain classes.
Using Triggers to Mitigate Some SQL Injection Effects
(K. Brian Kelley) I support a web application and we’ve determined is vulnerable to SQL injection. Unfortunately, there’s no real ability to modify the application in a timely manner and we can’t take it down. Is there anything within SQL Server I can do to help mitigate some of the SQL injection at
Copying Rows Between PostgreSQL Databases
(Szymon Guz) A recurring question is: ‘how can I copy a couple of rows from one database to another’? People try to set up some replication, or dump entire database, however the solution is pretty simple.
Tool Options: Detailing Oracle Process CPU Consumption
(Craig Shallahamer) Detailing an Oracle Database process’s CPU consumption is amazing, a lot of fun, and can lead to some “ah ha” moments. To make this posting daily digestible, I’m breaking it up into a multi-part series. Today I’m posting the second part entitle, Tools Options. Here we go…
Web API With AJAX: Various Parameters of jQuery Ajax() Function
(Sourav Kayal) In this article we will learn various parameters of the success callback function in the ajax() function of jQuery.
What’s new with the DB2 11 for z/OS optimizer?
(Willie Favero) This is the webinar many of you have been waiting for. I know I have. On January 28, 2014 at 11:00 AM EST (4:00 PM GMT) it will be time for Terry Prucell’s to tell us all about the query performance improvements being brought about by DB2 11 for z/OS. Whether you’re a programmin