Video/Voice conferencing and Microsoft Lync
Since I work mostly from home, video/voice conferencing and IM are of major importance to me, and using the right...
2012-01-11
1,025 reads
James Serra's Blog
Houston Area SQL Server User Group Presentation
Thanks for everyone who attended my presentation “How To Make a LOT More Money as a Consultant” at HASSUG.
Here is...
2012-01-11
606 reads
Surrogate Keys
When building a data warehouse, it is important that primary keys of dimension tables remain stable. To accomplish this, it...
2012-01-09
3,971 reads
Normalizing Your Database
If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process...
2012-01-11 (first published: 2012-01-06)
5,085 reads
Difference between ETL and ELT
ETL is the most common method used when transferring data from a source system to a data warehouse. But there...
2012-01-04
7,594 reads
SSIS Community Tasks and Components
Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent...
2012-01-04 (first published: 2011-12-30)
3,093 reads
SQL Server 2012 (“Denali”): Master Data Services
SQL Server Master Data Services (MDS) has a number of enhancements in SQL Server 2012:
Improved web user interface – If you...
2011-12-28
1,837 reads
SQL Server 2012 (“Denali”): New Security Features
SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups,...
2011-12-23
1,967 reads
SQL Server 2012 (“Denali”): AlwaysOn
AlwaysOn is a new integrated high availability (HA) and disaster recovery (DR) solution that provides redundancy within a datacenter and across datacenters...
2011-12-21
1,579 reads
Junk dimensions
Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators. When designing a data warehouse, you might...
2011-12-19
1,381 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers