Summarizing Imported Data
This article shows a few simple techniques to summarize table data using T-SQL.
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.
Leaving Some Headroom
Dropbox has grown tremendously in the last few years and Steve Jones talks about a concept of running with less headroom as a way to cope with that rapid growth. Is it something you'd be interested in with a SQL Server?
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.
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.
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.
A Really Good Job
Today Steve Jones talks about how you can find a really good job. And how you can make changes in your life to get you there.
Help Red Gate create a new monitoring tool
Red Gate Software is looking to offer a new monitoring service and is looking for opinions and ideas in making it happen.
Managing SQL Server Extended Events in Management Studio
We’ve all heard about Extended Events and how they can help troubleshoot SQL Server performance, connectivity, and locking problems, but they seem so difficult to implement using T-SQL. Isn’t there a better way to implement SQL Server Extended Events?
PASS Data Architecture VC presents Ami Levin on Where Are My (Primary) Keys?
On Thursday July 26th 12PM noon Central, Ami Levin will revisit some of the fundamental principles of relational databases – normalization rules, key selection and some controversies surrounding these rules.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA Multifinance Cabang Kedoya Hub.0851•8812•0691
BCA Multifinance Cabang Kedoya Hub.0851•8812•0691 Citta Graha, Jl. Panjang, RT.5/RW.1, South Kedoya, Kebonjeruk, West...
BCA Finance Kelapa Gading Layanan Mobil Hub.0851•8812•0691
BCA Finance Kelapa Gading Layanan Mobil Hub.0851•8812•0691 Ruko Mall Of Indonesia Blok B 32-33,...
BCA Finance - Depok Hub.0851•8812•0691
BCA Finance - Depok Hub.0851•8812•0691 Komplek Perkantoran, Ruko Pesona View, Jl. Pesona Khayangan Jl....
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers