(jarneil) Sometimes things never quite go according to plan. You can test, and test in a UAT or dev environment, but just sometimes, something comes out of left field when you come to roll it into production. Just such an issue appeared when I was really rolling a patch into production.
Other News
Oracle ADF 11g Table Insert with Empty Insert Row
(Andrejus Baranovskis) Guess what ADF topic remains most popular over the years – CRUD. I have several blogs on this topic, for example – CRUD Operations in Oracle ADF 11g Table Without Auto PPR. Today I will describe one more scenario – how to maintain empty row, which can be used to insert new rec
SQL Server Database Growth and Autogrowth Settings
(Greg Larsen) It’s easy to create a database nowadays with point-‘n-click, but if you’ve left your database’s autogrowth settings at their default, you may hit problems in the future. Why? What do I do about it? Read on!
SQL Server Security: Objects (Securables)
(Buck Woody) I’m continuing a previous discussion of SQL Server Security in this series, where I’ve already described security in general, on the specific platform, as well as a graphical step-by-step tutorial on how to create users and groups of users called “roles” in the last tutorial.
SQL Server – Profiler – Part 3 – Trace execution options – Save trace to file or a table, Auto-scroll and keyboard shortcuts
(Nakul Vachhrajani) Based on popular demand from my colleagues and you, the kind reader, I am currently writing a series of posts on the SQL Server Profiler. The first part was an introduction attempting to answer the question – What is a SQL Trace? Permissions, space requirements and launching the
Using jQuery’s Pipe() Method To Chain Asynchronous Validation Requests
(Ben Nadel) The other day, I looked at using Stripe.com to accept PCI-compliant online payments without a merchant account. In that experiment, I performed a cross-domain AJAX request to validate the credit card (using Stripe.com’s API) followed by a local AJAX request to validate the rest of the fo
Table Valued Parameter in SqlServer 2008
(Rahul Pratap Singh) Table Values Parameter (TVP) is one of the most useful features of SqlServer. We can create a user defined TVP and can use this as parameter in any procedure. When we worked on the large projects we need to create number of procedures to insert the data means one procedure for e
Managing database connections with the IBM Data Studio web console
(Loic Julien, Kevin McBride and Quddus Chong) Learn how to use the web console of IBM Data Studio to manage and share database connection information. This feature helps increase productivity among Data Studio users and reduce the overhead of tooling configuration.
Version Does Matter
Version Does Matter I received an Email from Michelle Poolet today. Michelle has a business providing support for SQL Server databases. As a result, she works with many different customers, each with unique problems and solutions. They also have many of the different versions of SQL Server available from Microsoft today. Michelle writes: Let me tell you about an incident […]
Has Dot Net Remoting Been Replaced by WCF?
SSWUG TV – Interviews with Bob Zurek from Endeca and SSWUG.ORG Presenter Laura Rose. We also have the latest news on SQL Server 2012, product features from Sanbolic and insights on cloud computing from SQL Server MVP Stephen Wynkoop. [Watch the Show] SSWUG TV – Interview with Denny Cherry, SQL Server MVP and SSWUG.ORG Class Presenter. We also have the […]