Find the Port a Connection is Using
If you have multiple ports, this article from Mark Greenbaum will tell you which port a connection is using
Leanring from Experts
A guest editorial from Andy Warren. Experience helps us do a better job, and one way you can get that is learning from experts.
Data Warehousing Architecture - Designing the Data Staging Area
The staging area tends to be one of the more overlooked components of a data warehouse architecture, and yet it is an integral part of the ETL component design. Learn why it is best to design the staging layer right the first time, enabling support of various ETL processes and related methodology, recoverability and scalability.
Performance Impacts Related to Different Function Types
The July 2010 PASS Performance VC Presentation by Jason Strate on July 6th 12:00 PM EDT (GMT -4).
SSIS Package to Script All SQL Server Jobs to Individual Files
The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.
What if TDE was available in Standard Edition?
Today we have a guest editorial from John Magnabosco that looks at TDE, and the reasons that it ought to be in Standard Edition.
Multi-parameter CLR aggregate in SQL Server 2005
How is it possible to pass multiple parameters to a SQL Server 2005 CLR aggregate?
Should DBAs Be the Protectors of Data?
Brad McGehee wonders whether DBA's should take a more active role in managing their organization's data, even if it means potentially ruffling a few feathers.
Physical Join Operators in SQL Server - Merge Operator
Part II of the Physical Joins series looks at the Merge operator.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers