Troubleshooting SQL Server with PowerShell - Virtual Chapter Meeting
Come join Laerte Junior on Wednesday ,July 18th 12 noon EDT (GMT -4), for a virtual meeting on Powershell and
2012-07-10
843 reads
Articles
Views and Dependencies
Be sure to understand the consequences of modifying underlying tables and the affects they can have on Views
2012-07-10
5,363 reads
Handling Constraint Violations and Errors in SQL Server
The database developer can, of course, throw all errors back to the application developer to deal with, but this is neither kind nor necessary. How errors are dealt with is dependent on the application, but the process itself isn't entirely obvious.
2012-07-10
3,666 reads
Turbocharge Your Database Maintenance With Service Broker: Part 1
Are your maintenance windows too wide? Find out how to shrink them with Service Broker.
2012-07-09
8,880 reads
Software Developer Survey
We'd like to grow our understanding of the software you create and how you get it to your users. This survey should only take a few minutes and we really appreciate your input!
2012-07-09
2,000 reads
SQL Server 2012 Integration Services- Using Environments in Package Execution
SQL Server 2012 Integration Services offers several different options for deploying and storing SSIS packages along with their associated projects, two of which are directly related to two deployment models available in SQL Server Data Tools console. Marcin Policht presents one of these methods, which deals with packages deployed using Project Deployment Model and leverages newly introduced Environments.
2012-07-09
2,715 reads
Introduction to Indexes: Part 2 – The clustered index
In the second part of her series on indexing, MVP Gail Shaw examines clustered indexes. Learn what this index is, how it differs from a heap, and how it can help your queries.
2012-07-06 (first published: 2009-11-11)
63,458 reads
Trash Destination Adapter
The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement. You often want run a package part way through development, or just add a path so you can set a Data Viewer. There are stock tasks that can be used, but with the Trash Destination all columns are treated as selected automatically (usage type of read-only), so the pipeline knows they are required.
2012-07-06
2,532 reads
Advanced SSIS Fuzzy Matching via Record Linkage Methodology
Greatly improve SSIS Fuzzy Grouping performance by using a Conditional Split and Multi Cast.
2012-07-05
7,915 reads
Steps to clean up orphaned replication settings in SQL Server
Learn how to clean up your orphaned replication settings.
2012-07-05
3,518 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers