SQL Saturday #161 - East Iowa
A free day of SQL training in Iowa City o Aug 11. Come meet other SQL Server professionals in the area.
2012-08-01
1,358 reads
Articles
Set Up Grouping Intervals for Excel (SQL Spackle)
So you want to group your data for charting in Excel? Here's how, the easy way!
2012-07-31
5,380 reads
Implement Continuous Integration In Your Software Project
Continuous integration, or CI, brings developers closer to delivering error-free software flawlessly. Find out how to implement it.
2012-07-31
2,538 reads
Track source dates when loading a data warehouse
A primer on how to reduce network and source system load when reading a relational source into the data warehouse.
2012-07-30
5,842 reads
An Introduction to SQL Server Service Broker
Service Broker is a technology built into SQL Server and utilized by the engine for its internal asynchronous processing. The great thing about Service Broker is that its functionality is exposed so we can build our own custom data integrations. Deanna Dicken introduces you to the concepts needed to create a service broker integration.
2012-07-30
3,492 reads
Summarizing Imported Data
This article shows a few simple techniques to summarize table data using T-SQL.
2012-07-27
2,034 reads
Data Generator Source Adapter
This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline. You specify how many columns of each you would like and for any string columns you pass a fixed length value. You then need to specify how many rows in total you require to be generated. This component is used by us to do testing of the pipeline and components downstream.
2012-07-27
2,236 reads
Using SMO 2012 to trouble shoot support issues
SMO can be a valuable tool for working with SQL Server when you don't have access to all the tools that come with the platform. In this article, SMO helps solve an issue with a SQL Server.
2012-07-26
709 reads
NULL-Friendly: Using Sparse Columns and Column Sets in SQL Server
Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always proved to be tricky for the relational model. They can be used very effectively where the attributes are sparse for any given entity and very numerous across all entities. Seth Delconte shows how to use them.
2012-07-26
1,410 reads
SQL Saturday #158 - New York City
Free training in New York. Come learn about SQL Server, meet other pros, and then enjoy a night in the city.
2012-07-26
1,402 reads
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