OK, so I’ll admit this is a bit cheeky: this entry should almost certainly be .NET Oddities #2a because it’s so closely related to #2, but there. You may have noticed, and in fact I already knew this, that OutOfMemoryException (like StackOverflowException) has a null value for its StackTrace property. Again, this can be a … Read more
When developing a COM based application sometimes it’s sometimes useful to register all the DLLs/OCX at once.From a command prompt This will try to register all dll’s even if they are not COM dlls. This is fine as the registration will fail silently.You can change the above command to register COM servers eg… Read more
Check out John Robbins November 05 Bugslayer article.. He has ported his excellent SUPERASSRT code from native C++ into C#. Part of his solution uses CDB.(a command line version of WinDBG)I have previously found producing minidump files very useful in tracking down native code problems, so I will be trying out his new C# implementation … Read more
I must admit that creating a nice type safe collection for a new feature in one of our products took me a little time. There are some very good resources online on how to setup your own type safe collection so I thought I’d contribute a little to that resource. The key to all this … Read more
Occasionally when developing software you come across really absurd or bizarre bugs. The user interface for the application I’m currently developing recently exhibited one of these: a propensity for beeping periodically, for no readily explicable reason. To be precise, not so much a beeping as a “ding”ing. Now like most software developers, I work in … Read more
In case you haven’t come across this before you can actually compare two views in SQL Data Compare. The only pre-requisite is that the view has an index defined on it. As an example lets create and compare an indexed view on pubs. First we must create the view with the schema binding option: We … Read more
Phew… on November 15th an email went out to a select group of SQL Server DBA’s, Developers and other potential SQL Backup users to let them know of the SQL Backup version 4.0 beta program. The beta version is pretty much feature complete. It’s a major upgrade from version 3.2. The final release is scheduled for 16th … Read more
How many of us have developed some code only to find the compiler outputs some warnings such as unused parameter, or unreachable code and just thought “yup, I’ll fix it tomorrow”. Unfortunately tomorrow never comes and the warning just get left in. Before you know it when you build a project there are hundreds of … Read more
It’s that time again. Time to leave the comfy confines of the office, brave the real world and meet the most important people who work for Red Gate: our users. With a bunch of design ideas stashed on a laptop, we venture off to learn exactly how wrong we’ve got it. I have to admit, … Read more
This is the first post in my Red Gate Blog so I think I’d better introduce myself a little bit. I’m the main programmmer on the SQL Data Compare engine one of our suite of best selling SQL Bundle tools, currently I’m working on the latest version which will support the new data types in … Read more
While reading through the excellent http://blogs.msdn.com/ I noticed this post by Todd Carter talking abount ASP.NET and SQL Server Performance, in it he talks about compiler locks slowing down stored proceedure execution. Aparently this occurs when The user that runs the stored procedure is not the owner of the procedure AND The stored procedure name is not fully qualified … Read more
David C sent me an interesting link about the breaking changes between Beta 2 and the RTM, you can find the original summary at The Server Side.NET and Microsoft’s in-depth document here [.doc… Read more
Last week I found out that sometimes XP SP1 dlls are labelled as xpsp2. A client had DLLs that were labelled xpsp2 for example comctl32.dll 6.0 (xpsp2.050831-1533) c:windowswinsxsx86_microsoft.windows .common-controls_6595b64144ccf1df_6.0.2600. 1740_x-ww_7cb8ab44comctl32.dll However just because the DLLs are labelled xpsp2 this does not mean that they are Service Packl 2.Infact they are late XP Service Pack 1 DLLs!… Read more
Category: SQL Server internalsSQL Server versions: 7, 2000, 2005Level: Advanced Well, this week I spent some time playing with defaults, and here is just a small taster of what SQL Compare version 4 does for you. Defaults are a nice thing in SQL. One can assign defaults to table columns, and when one does not … Read more
Here is a list of some of the windows key board short cuts (thanks to Tilman): Keyboard Meaning Windows key Start menu Windows key + D Minimize all windows to Desktop Windows key + D Restore minimized windows Windows key + E Windows Explorer Windows key + L Lock Desktop Windows key … Read more
Thursday 3rd November is World Usability Day. A day that is hugely anticipated. Millions will take to the streets, trying to catch a glimpse of their favourite usability guru, sagely administering sermons on the woes of unusable products. I can see it now – it’ll generate almost as much fervour as the results for the … Read more
It occasionally strikes me as hilarious that in the 21st millenium with Windows Vista near on the horizon with all kinds of spangly UI likely to result, we’re not only still using some of the oldest Windows UI primitives every day, but encountering problems using them. You’d think that we might have got it all … Read more
Ever heard of NEDS? It’s another handy acronym in a world full of HIMPERs (An acronym I just made up, but it looks pretty convincing if you ask me). So NEDS stands for: New Economy Depression Syndrome and it’s something that is apparently increasing in the hectic lives we lead. Gone are the days when … Read more
I had a feeling I’d be writing quite a few entries like this, but I must confess that even I would have been surprised if you’d told me I’d be writing #2 a mere two days after #1. So what is it this time? Well, it’s StackOverflowException. Jeff Richter has this to say about StackOverflowException … Read more
We’ve been working on a new version of our DTS Compare tool for a couple of months now, and it’s starting to look quite good. I’ve been working on the snapshot functionality today, which allows a user to take a snapshot of the state of all the DTS packages on a given instance of SQL … Read more
Simple Talk Bloggers
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
