SQL Saturday #159 - Kansas City
BBQ and SQL Server. Come to a free day of training in Kansas City on Aug 4.
2012-07-24
1,479 reads
Articles
Introduction to Indexes: Part 3 – The nonclustered index
Part 3 of a great series on the basics of indexes. Learn the structure, definition, and how to examine the use of these indexes in your queries.
2012-07-23 (first published: 2009-11-18)
53,417 reads
Developing Low-Maintenance Databases
Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.
2012-07-23
3,977 reads
SQL Saturday #150 - Baton Rouge
Baton Rouge, LA. LSU. Free Training. Come visit, learn a few things, and enjoy meeting other SQL Server pros.
2012-07-23
1,167 reads
Map IP Address to a Geographical Location
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
2012-07-20 (first published: 2009-07-09)
55,306 reads
Creating a Custom Report Template in SSRS
Arshad Ali shows you how to create standard/custom report templates in SQL Server Reporting Services (SSRS), to ensure consistency throughout the organization in both the look and feel of reports.
2012-07-20
3,930 reads
Single User Performance of SQLite v. SQL Server
A look at the performance of SQL Server compared to SQLite for single user applications.
2012-07-19
7,098 reads
SSIS Basics: Adding Data Flow to Your Package
Annette continues her popular series for SSIS beginners by showing how a data flow task can be used in a package to move data from a SQL Server database to an Excel file, and insert an additional column into the Excel file that’s based on derived data.
2012-07-19
3,555 reads
Checksum Transformation
The Checksum Transformation computes a hash value, the checksum, across one or more columns, returning the result in the Checksum output column. The transformation provides functionality similar to the T-SQL CHECKSUM function, but is encapsulated within SQL Server Integration Services, for use within the pipeline without code or a SQL Server connection. As featured in The Microsoft Data Warehouse Toolkit by Joy Mundy and Warren Thornthwaite from the Kimbal Group.
2012-07-18
2,729 reads
Implementing SQL Server's Change Data Capture
When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.
2012-07-17
3,616 reads
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
Cara pesan tiket Batik Air di Agoda
Untuk pesan tiket di Agoda Anda bisa melalui WhatsApp resmi CS Agoda di 0823-2461-4949,...
BCA KCP Gading Bukit Indah Telpon. 08388331767
WhatsApp 08388331767 Jl. Raya Gading Kirana Blok D/1, Klp. Gading Bar., Kec. Klp. Gading,...
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