A Fun Poll
Since I've spent most of the week at the PASS Summit, and have been busy meeting with people there instead of working on this site, I opted for a more fun, less thought-requiring poll.
Working with Datetime
Datetime data in SQL Server can be a little confusing to work with, especially as many front end languages do not combine the date and time into a single datatype. As a result, T-SQL is sometimes used to manipulate and convert datetime data into more useable formats. Author Leo Peysakhovich has written about some tricks that he uses to reformat and work with datetime data.
Changing Service Credentials
One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.
Strategies for Testing Data Warehouse Applications
This article presents a strategy for testing ETL applications that perform data movement and populate data warehouses. It is useful information for the testing community as well as designers and managers charged with planning a data warehousing implementation.
Experiences from a Real World Project
SQL Server 2005 Integration Services changed the ETL paradigm for SQL Server developers and DBAs. SSIS expert Jamie Thomson has been working with this platform for a few years and brings us some real world knowledge based on a large project he completed in 2006. (Reprinted from the SQL Server Standard).
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.
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Preserving Data
Comments posted to this topic are about the item Preserving Data
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers