Fabiano Amorim

Query Optimizer and Cartesian Products

In his continuing quest to bring a deeper understanding of Query Optimizer to the world at large, Fabiano takes a...

22 October 2009 5 min read

Database Administration

John Magnabosco in Database Administration

Obfuscating your SQL Server Data

If you are required to use real production data to test applications, any sensitive data should be "disguised" before loading...

21 October 2009 13 min read

Phil Factor

Moving Down in the World of Work

You know how it is, you’re racing to finish a nice software product that you feel sure is going to...

19 October 2009 6 min read

Tony Davis

The SSRS 2008 Minefield

One of the big advances in Microsoft’s “2008 platform”, with regard to Reporting Services, was that there would be a...

16 October 2009 3 min read

Richard Morris

Geek of the Week: Joe Celko

Joe Celko, the Database Developer and writer from Austin Texas, is not a man to mince his words. His encyclopedic...

16 October 2009 12 min read

Anith Sen

Five Simple Database Design Errors You Should Avoid

Anith follows up his highly successful article Facts and Fallacies about First Normal Form with a fascinating discussion of five...

16 October 2009 18 min read

Edward Elliott

.Net Debugging? Don’t give me none of your VS

Visual Studio is fine for most debugging purposes. Just occasionally, it isn't practicable, or there are other quicker ways of...

14 October 2009 23 min read

Fabiano Amorim

Data Correlation Optimization Internals

Having adroitly introduced us, in his previous article, to the Date Correlation ability of the Query Optimizer, Fabiano discusses the...

14 October 2009 10 min read

Louis Davidson

Sixth pillar – Well Performing

I guess eventually I had to admit that performance matters. Whenever I speak, and in all of my books, I...

13 October 2009 7 min read

Laerte Junior

Reducing I/O with the ‘Missing Indexes’ DMVs

Laerte recently experienced an I/O nightmare, which, as a happy accident, gave him an opportunity to test out the 'Missing...

09 October 2009 14 min read

Laila Lotfi

Speeding up AJAX Applications

Microsoft’s recent release of Doloto reminded me of the pain of the AJAX Programmer. Doloto is a tool for optimizing...

08 October 2009 3 min read

Ryan Duclos

Ten Common SQL Server Reporting Services Challenges and Solutions

Many of us who have to develop a Reporting Services (SSRS) application come across various problems, hurdles or 'gotchas' that...

08 October 2009 26 min read

Ben Lye

Using Group Policy to Restrict the use of PST Files

Outlook PST files are a problem for Exchange users, and give no benefits over Exchange mailboxes. You have to use...

08 October 2009 5 min read

Brad McGehee

Mastering SQL Server Profiler – eBook Download

Download Brad McGehee's "from the ground up" guide to SQL Server's most powerful performance diagnostic tool.…

07 October 2009 2 min read

Jacob Sebastian

The Art of XSD – eBook Download

When information is exchanged in XML format, you need an agreement between the sender and receiver about the structure and...

07 October 2009 1 min read

Matteo Slaviero

Beginning with Digital Signatures in .NET Framework

Digital Signatures aren't the most intuitive software devices to explain, but Matteo boldly gives a quick-start account of Asymmetric Cryptography...

07 October 2009 14 min read

Grant Fritchey

SQL Server Execution Plans – eBook Download

Why is my query running slow? Why isn't my index getting used? In order to answer these questions, you have...

07 October 2009 1 min read

Louis Davidson

Fifth pillar – Secure

As I have mentioned in all of the previous posts, basic functionality is the foundation of any system. So it...

06 October 2009 5 min read

Louis Davidson

MVP Award Renewal

On October 1, I received my email stating that I was again renewed as an MVP. One of the greatest...

04 October 2009 3 min read

Bart Read

.NET Reflector Support: Can I edit assemblies I’ve opened in .NET Reflector?

Yes, you can. There are two possible approaches, both of which utilise add-ins to .NET Reflector. The first, assuming that...

02 October 2009 1 min read

Register for Simple Talk

Articles

Query Optimizer and Cartesian Products

Obfuscating your SQL Server Data

Moving Down in the World of Work

The SSRS 2008 Minefield

Geek of the Week: Joe Celko

Five Simple Database Design Errors You Should Avoid

.Net Debugging? Don’t give me none of your VS

Data Correlation Optimization Internals

Sixth pillar – Well Performing

Reducing I/O with the ‘Missing Indexes’ DMVs

Speeding up AJAX Applications

Ten Common SQL Server Reporting Services Challenges and Solutions

Using Group Policy to Restrict the use of PST Files

Mastering SQL Server Profiler – eBook Download

The Art of XSD – eBook Download

Beginning with Digital Signatures in .NET Framework

SQL Server Execution Plans – eBook Download

Fifth pillar – Secure

MVP Award Renewal

.NET Reflector Support: Can I edit assemblies I’ve opened in .NET Reflector?