Importing data in a MySQL database into a SQL Server database

Let me start by saying this did not turn out to be as easy as I originally thought. I started with a giant assumption that I think many may have in the past: With SSIS, Microsoft’s integration tool shipped with

Tagged with: , ,
Posted in SQL Server, SSIS

Implement explicit installation and uninstallation options for xp_cmdshell

Implement explicit installation and uninstallation options for xp_cmdshell Up-vote this Connect item if you would like to be able to control the availability of xp_cmdshell on your instances more than simply enabling or disabling it via sp_configure.

Tagged with: ,
Posted in Uncategorized

SQL Training

I had the pleasure of attending a 5 day SQL Server 2012 Internals and Query Tuning class led by Kalen Delaney the week before last. I had a head start going into the class because I had already read SQL

Tagged with: ,
Posted in Uncategorized

Article Published on SQL Server Central

My sixth article was published on SQLServerCentral.com yesterday: Loginless Database Users and Dynamic SQL

Posted in Uncategorized

Article Published on SQL Server Central

My fifth article was published on SQLServerCentral.com yesterday: Loginless In Seattle

Posted in Database Security, SQL Server

Iterate Over Databases Using SSIS – Part 2

In Part 1 of 2 I showed how to iterate over the databases in any given SQL Server Instance using SSIS. In Part 2 I’ll show how to extend the SSIS Package created in Part 1 to iterate over all

Tagged with: ,
Posted in SQL Server, SSIS

Iterate Over Databases Using SSIS – Part 1

In Part 1 of 2 I’ll show how to iterate over the databases in any given SQL Server Instance using SSIS. In Part 2 I’ll show how to extend the SSIS Package created in Part 1 to iterate over all

Tagged with: ,
Posted in SQL Server, SSIS
Follow

Get every new post delivered to your Inbox.