TSQL Challenge 30 - A Matrix Transposition challenge in TSQL
This is a matrix transposition challenge. Your job is to change the position of the numbres in a 5x5 matrix.
2010-05-17
2,132 reads
Articles
Generating Insert Statements
This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.
2010-05-14 (first published: 2009-07-01)
31,306 reads
Business Intelligence is a Growing Field
How do you, as a database administrator, display the wealth of knowledge in your Database to the organization in a meaningful way -- Business Intelligence.
2010-05-14
4,902 reads
Backup SQL Server to Amazon S3 with CloudBerry Backup
In this sponsored article from Cloudberry, learn how you can backup your SQL Server data to the Amazon EC3 cloud.
2010-05-13
2,323 reads
SSIS object search using T-SQL
Easily determining what objects are located in all your SSIS packages can be a challenging endeavor. James Greaves brings us a technique that can help you determine which packages might need to be changed based on objects you alter in your database.
2010-05-13
12,835 reads
Working with Spatial Data Part II - Plotting Shapes and Storing Geocoded Data
Continuing from Part I of the Spatial Data series we model an in-memory/persistent data repository for storing geocoded data and plot the data.
2010-05-13
1,908 reads
Efficient SQL Server Indexing by Design
Having a good set of indexes on your SQL Server database is critical to performance. Efficient indexes don't happen by accident; they are designed to be efficient. Greg Larsen discusses whether primary keys should be clustered, when to use filtered indexes and what to consider when using the Fill Factor.
2010-05-12
6,106 reads
No SFTP Task Component in SSIS 2005/2008? No Problem!
SSIS 2005 and 2008 have an FTP Task component, but no SFTP (SSH/TLS-encrypted FTP) Task component. This tutorial explains how to overcome this omission.
2010-05-11
14,468 reads
How to enable SSIS as data source type on SQL Server Reporing Services SSRS 2008 R2
when you create a data source in SSRS 2008 R2 (Nov CTP), you won't be able to get SSIS listed as a data source type. Therefore applications that are already using it as a data source or applications that require it as a data source get stuck. Let's learn how to enable and get SSIS listed back as a data source in SSRS 2008 R2.
2010-05-11
3,031 reads
Repair Corruption Using the Mirror Database in SQL 2005
Explanation of how to repair a database in SQL 2005 Enterprise which is mirrored.
2010-05-10
4,433 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
10 Reasons the 2CT Engagement Ring Is the Most Popular Proposal Choice Right Now
Walk into any jewelry consultation these days and you’ll hear a familiar request: “Something...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers