Building a Quality BI Framework Solution Starts with a Quality ETL Sol
Developing an effective solution requires quality within and across all components of the BI architecture.
Handling NULL values in SQL Server 2005
In the simplest terms, a NULL value represents an unknown value. It's unknown in the sense that the value is: missing from the system, may not be applicable in the current situation, or might be added later. NULL values are different than any other value and are sometimes hard to compare and handle.
The Cincinnati SQL Server Users Group
The Cincinnati SQL Server Users group is getting going again with a meeting on Tuesday, September 25th. If you are in the area, check out the details.
XML Workshop VII - Validating values with SCHEMA
This installment of the XML Workshop by Jacob Sebastian continues looking at XML Schemas in SQL Server 2005. Here we learn how the format and range of values can be checked using an XML schema.
SSIS Package Configuration in SQL Server 2005
SQL Server 2005 allows DBAs to set configurations for SSIS packages outside the package to facilitate a smooth transition between different environments.
Stop SQL Injection Attacks Before They Stop You
This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, Using .NET features to prevent attacks, and Importance of handling exceptions
Getting The Most Out of SQL Server 2005 UDTs and UDAs
The CLR integration in SQL Server 2005 greatly expands on the capabilities of the SQL Server platform. One new area is the ability to build user-defined types and user-defined aggregates. Solomon Rutzky brings us a way to get around some of the limitations in this area with his SQL# toolkit.
Opening Day
Today is the opening day for the PASS conference here in Denver and it's kind of exciting. As many of you read this, I've hopefully gotten Simon Galbraith, owner of Red Gate software, and my boss, out here at the ranch shoveling manure. He's anxious to get on the ATV for a ride, so maybe I can work out a deal to reduce my workload 🙂
Close These Loopholes - Testing Database Modifications
In the latest in their popular series on 'Unit Testing' database development work , Alex K and Alex S give some examples of unit testing Database Modifications
Upgrading to SQL Server 2005: A dozen must-have tips
We've compiled a list of our dozen most popular tips in the area of upgrading to SQL Server 2005 and they run the gamut.
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers