Extract multiple files from multiple directories with a data flow task
This article shows how to extract multiple files from multiple sub-directories into a destination table using a single Data Flow Task created by the Import/Export wizard.
Red Gate Acquires Cerebrata
Red Gate announced today that it has acquired Cerebrata, the maker of user-acclaimed tools for developers building on the Microsoft Windows Azure platform. The agreement brings together two companies that share a user-first philosophy and a passion for tools that transform the way developers work.
Virtualization for Security
This editorial was originally published on Nov 7, 2006. It is being re-run as Steve is at SQL in the City today. Today Steve talks about security using virtualization.
Identify location of the SQL Server Error Log file
How do I find out where the SQL Server Error Log file is located for a specific SQL Server instance? In this tip we look at different ways a DBA can identify the location of the SQL Server Error Log file used by an instance of SQL Server.
Stairway to MDX - Level 9: Member “Family” Functions: .LastSibling and Cousin()
BI Architect Bill Pearson concludes his introduction to the MDX Members functions. In this Level we wrap up our exploration of the “family” group with the .LastSibling, and Cousin() functions.
The Good Job
Today Steve Jones talks about jobs, and how life is too short to stick with a crappy job.
An Easy Way to Monitor SQL Server Replication
In SQL Server, replication is a widely adopted technology for the purpose of real-time data replication between SQL servers. It serves the purpose of keeping data consistent between multiple end points. So the last thing we want to hear from clients is that data is no longer in synch, and as DBA, we don't want to be the last person to realize replication is out of order or broken. Here are some steps you can take to monitor SQL Server replication.
Come see SQLInspireNYC for FREE – Thanks to Red Gate!
SQLInspire, from SQL People, is coming to New York City on Nov. 12, 2011. Win a free admission from Red Gate software to this great event.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers