SQL Server 2008 R2 Integration Services includes a number of predefined tasks that implement common administrative actions to help with data extraction, transformation and loading (ETL). While in a majority of cases they are sufficient to deliver required functionality, there might be situations where an extra level of flexibility is desired.
The thing that I most enjoy about going to conferences, SQLSaturdays, and user group meetings is the people I get...
I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when...
How is your IT relationship with "the business"? Andy Warren asks today if there is a real client relationship between the implementers of technology and the consumers.
Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim.
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
SQL Connections, part of Dev Connections, is coming in a few weeks. Now is the time to register and get the chance to learn in a sunny location.
How can I change the collation of SQL Server 2008? Learn how in this short tutorial.
Once again SQLServerCentral is sponsoring a track at SQL Connections in Orlando this March. Read about the event and our speakers and join us for SQL Server training in Florida.
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
The DBA life is fraught with pain. Those battles that we endure are mostly...
hi, im not a dba. For a couple of years our dev sql server...
Hello, I would like to ask whether it is technically possible to redirect a...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Can I set Accelerated Database Recovery on tempdb?
See possible answers