(Madhivanan) As you know I have started a new series on “Exploring SSMS” by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to insert code template for creating a table, stored procedure, login etc in th
Other News
SQL Magic Trick: Getting Row Count Without Fetching All Rows
(Jeff Smith) So while hanging out with a bunch of co-workers last week, someone mentioned they had this trick. The challenge is knowing how many rows you have in your result set before you actually read them all. You see, Oracle has no way of telling us how many records are in our data set before we
Using SQL Patch to add hints to a packaged application
(Allison) In my last post, I showed how you can use the BIND_AWARE hint to skip the monitoring phase of adaptive cursor sharing. If you have a packaged application, you might be wondering how you can use this hint if you can’t edit a query directly. In this post I’ll who you how to do just that, f
Oh no! My padding’s invalid!
(Simon Cooper) Recently, I’ve been doing some work involving cryptography, and encountered the standard .NET CryptographicException: ‘Padding is invalid and cannot be removed.’ Searching on StackOverflow produces 57 questions concerning this exception; it’s a very common problem encountered. So I de
MFC Application: Adding Service Mode Support
(Igor Vartanov) Quite often an application has an opportunity to extend its existence on the market but must first meet new requirements, such as being able to run service mode. Imagine that you have developed a huge MFC based server application for years.
Content Negotiation in ASP.NET MVC4 Web API Beta – Part 2
(Kiran Challa) This is the second post in this series related to the Default Content Negotiation that ships as part of ASP.NET MVC4 Beta. I am continuing from where we left off in Part 1.
Statistics and Recompilations, Part II
(Erin Stellato) I recently blogged about an interesting behavior in SQL Server when the database option, Auto Update Statistics, is disabled…and that post requires a sequel. The summary is that when you have the Auto Update Statistics option disabled for a database, query plans for tables are not r
SQL SERVER – Identifying guest User using Policy Based Management
(Pinal Dave) If you are following my recent blog posts, you may have noticed that I’ve been writing a lot about Guest User in SQL Server. Here are all the blog posts which I have written on this subject:
SharePoint: Change the Application Pool for Existing Web Applications
(Octavie van Haaften) There are many articles about SharePoint 2010 and application pool management. One of those topics is the number of application pools to be used by your SharePoint web applications. I like this post by Todd Klindt: Top 10 SharePoint 2010 Configuration Mistakes.
A better SHOW TABLE STATUS
(Ivan Cachicatari) From command line we have the entire MySQL server on hands (if we have privileges too of course) but we don’t have a overall overview, at this point the show table status command is every useful, or not?.