PL/SQL Exceptions Propagation during Variable Declaration

It’s always good to know how any language handles and propagates exceptions, Oracle PL/SQL being no different. They’re plenty of...

11 September 2012 1 min read

Chris Lambrou

SQL Monitor’s data repository: Alerts

In my previous post, I introduced the SQL Monitor data repository, and described how the monitored objects are stored in...

11 September 2012 12 min read

Louis Davidson

What Counts For a DBA: Ego

Leaving aside, for a second, Freud’s psychoanalytical definitions, the term “ego” generally refers to a person’s sense of self, and...

11 September 2012 3 min read

Grant Fritchey

Why is that SQL Server Instance under stress?

There are several reliable indications, using SQL Queries, of the what is causing SQL Server performance problems. Some of these...

11 September 2012 14 min read

Dave Green

Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test

The open-source Unit Test framework tSQLt is a great way of writing unit tests in the same language as the...

11 September 2012 12 min read

Michael Sorens

TortoiseSVN and Subversion Cookbook: Part 8: Log Messages

There should always be a reason for a commit to source control, so why not make a log message mandatory...

11 September 2012 18 min read

Grant Fritchey

Databases in Source Control

I’ve been working as a database professional for quite a long time. But originally, I was a developer. And I...

10 September 2012 3 min read

The .NET Team

Content Weighting and Sociology

I’ve had loads of fantastic feedback on the concept and early curation wireframes I posted on the labs, and it’s...

06 September 2012 1 min read

Red Gate Software BI Tools Team

New site – and a special offer

SSAS Compare has a brand new website! The old page was thrown together in the way that most Red Gate...

06 September 2012 2 min read

Gert Poel

Generating XML from SQL and PL/SQL – Part 1: Introduction

From time to time you’ll have to represent your data stored in a database in an XML format, eg. to...

05 September 2012 5 min read

Michael Williamson

Lightning talk: Joachim Cassel – Making Stuff Shiny on the iPhone

In one of last week’s lightning talks, Joachim spent five minutes telling us about graphics and animation on the iPhone,...

03 September 2012 1 min read

Louis Davidson

Utility Queries–Structure of Tables with Identity Column

Edit: At the suggestion of a much knowledgable commenter who shall remain named Aaron, I changed from using schema_name() function...

02 September 2012 17 min read

Grant Fritchey

Introduction to Agile Development

Even though my current job is a little weird, I still consider myself to be a DBA. I didn’t start...

31 August 2012 2 min read

Tony Davis

Aptronyms: fitting the profession to the name

Writing a recent piece on the pains of index fragmentation, I found myself wondering why, in SQL Server, you can’t...

31 August 2012 3 min read

Buck Woody

The Value of Professional Associations

If you're a technical professional, it is a good idea to belong to a professional association. There are several to...

31 August 2012 12 min read

Louis Davidson

SQLPASS DB Design Precon Preview

It is just a few months left before SQLPASS and I am pushing to get my precon prepped for you....

30 August 2012 3 min read

The .NET Team

Web.NET event coming in October

If you’re a web developer in Europe (or would like an excuse to travel to Europe), you should definitely take...

30 August 2012 2 min read

Patrick Barel

Checking for NULL with Oracle SQL

The art of doing mathematics consists in finding that special case which contains all the germs of generality. David Hilbert...

30 August 2012 7 min read

Damon Armstrong

Optionally Running SPSecurity.RunWithElevatedPrivileges with Delgates

I was writing some SharePoint code today where I needed to give people the option of running some code with...

30 August 2012 2 min read

Phil Factor

Registered Servers and Central Management Server Stores

SQL Server Management Studio (SSMS) has many features that make it particularly convenient for the database developer and DBA. Registered...

28 August 2012 14 min read

Register for Simple Talk

Articles

PL/SQL Exceptions Propagation during Variable Declaration

SQL Monitor’s data repository: Alerts

What Counts For a DBA: Ego

Why is that SQL Server Instance under stress?

Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test

TortoiseSVN and Subversion Cookbook: Part 8: Log Messages

Databases in Source Control

Content Weighting and Sociology

New site – and a special offer

Generating XML from SQL and PL/SQL – Part 1: Introduction

Lightning talk: Joachim Cassel – Making Stuff Shiny on the iPhone

Utility Queries–Structure of Tables with Identity Column

Introduction to Agile Development

Aptronyms: fitting the profession to the name

The Value of Professional Associations

SQLPASS DB Design Precon Preview

Web.NET event coming in October

Checking for NULL with Oracle SQL

Optionally Running SPSecurity.RunWithElevatedPrivileges with Delgates

Registered Servers and Central Management Server Stores