ETL from Oracle to SQL Server
I was recently asked to provide some performance tuning recommendations for an ETL process that extracts data from Oracle using...
2011-12-21
8,001 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
Explaining SQLSaturday
I wrote a while back about my coffee cup from SQLSaturday #100. I took it to work (where I usually...
2011-12-21
638 reads
VirtualBox – Cannot Register the Hard Drive Because a Hard Drive with UUID Already Exists
Virtualization is awesome! It really helps when you are a developer. On my laptop I don’t even have SQL Server...
2011-12-21
5,404 reads
Routing OSPF and Network Team
After a server move to the failover Data Centre – a file copy between the two sites slowed down by 6x. ...
2011-12-21
663 reads
2011 PASS Board Elections Notes
As I write this the final hours for the 2011 PASS Board of Directors elections are ticking away. Before the...
2011-12-20
950 reads
How I Got Started in Software Development-A Tribute to Ed
A tribute is an expression of gratitude or praise. As I head into this holiday season I wanted to express...
2011-12-20
512 reads
Modifying SQL Server Synonyms
One task that often needs to be done when migrating a database to production for the first time is to...
2011-12-20
1,399 reads
SQLSaturday Goes International
Looking at 2011 and the planned events so far for 2012 it’s easy to see that SQLSaturday is starting to...
2011-12-20
658 reads
Mark a Disk Partition as Inactive
If you are like me then you like to reinstall Windows on your laptop every few months to keep things...
2011-12-20
907 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