$$SWYNK$$ SQL Tip – SP_Execute_SQL For those rare occasions when you really must build dynamic SQL for your SQL Server instance while using scripts or stored procedures. When doing this you have two options. EXEC(‘SQL Statement’) Or Sp_Execute_SQL There is a big difference between the two. The exec method operates completely as an ad-hoc query. If every command is EXACTLY […]
Other News
Checking for AUTO_INCREMENT capacity with single query
(Shlomi Noach) Darn! This means oak-show-limits becomes redundant. Am I not supposed to speak about it on my coming presentation? Bad timing!
Converting Scripts Between SLAX and XSLT
SLAX is a C-like alternative syntax to XSLT and can be viewed as a preprocessor for XSLT. Before the Junos OS invokes the XSLT processor, the software converts any SLAX constructs in the script (such as if/then/else) to equivalent XSLT constructs (such as and ). For more informa
Top 5 reasons for choosing a managed service for your database
(Laura) In recent years the move to outsource IT or business processes has really taken hold. There are definite benefits to outsourcing all or part of an organisations’ database management systems.
How COLLECT displaced User Defined Aggregates
(Gary Myers) A recent PL/SQL Challenge question focussed on a user defined aggregate. Not a lot of people got it right, and one reason is that they have never been particularly popular.
Check/Uncheck All Checkboxes in Asp.Net Gridview
(Krishna Garad) In this article we will see how to check and uncheck all CheckBoxes present in an ASP.Net GridView control.
Running SQL Server Agent with a least privilege service account
(Nitansh Agarwal) For improved security Microsoft recommends the SQL Server Agent service account should not be a member of the local Administrators group. Being a member of the Administrator group, grants the account super-user privileges which therefore may expose you to more security vulnerabilit
InnoDB Flushing: Theory and solutions
(Vadim Tkachenko) I mentioned problems with InnoDB flushing in a previous post. Before getting to ideas on a solution, let’s define some terms and take a look into theory.
Rebecca Bond: IDUG NA – The Geeky Vacation!
Last week’s blog entry Budgeting for IDUG North America conference as viewed by the DB2 Locksmith by guest Rebecca Bond was very popular, so I’ve asked Rebecca back for a second entry. Actually Rebecca did one for me like this last year as well. I figure that DBAs would benefit more if they hear f
How to understand Merge Replication article processing order
The Merge Agent follows a specific set of rules that govern the order in which the merge process applies changes to articles during the synchronization process.