This code sample programmatically creates a package with an OLE-DB Source and a Flat File Destination, and the resulting package exports data from SQL Server to a CSV file. The finished package just has the one Data Flow Task shown below.
2009-02-10
2,537 reads
Last week I posted Update #3 that discussed my first board meeting, but I didn't have time to cover my goals, so I 'll do that and add some other minor items as well.
2009-02-10
968 reads
SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.
2009-02-10
2,594 reads
I should have put this out earlier, before going to the SQL Server Innovators Guild , but I got too busy. Here are my current speaking / teaching engagements for the first half of the year:
2009-02-10
158 reads
A tour of the new Red Gate Software offices from Steve Jones, looking at how a modern software company has set up it's space.
2009-02-10
665 reads
A tour of the new Red Gate Software offices from Steve Jones, looking at how a modern software company has set up it's space.
2009-02-10
674 reads
A tour of the new Red Gate Software offices from Steve Jones, looking at how a modern software company has set up it's space.
2009-02-10
625 reads
2009-02-09
4,908 reads
DevWeek is Europe’s leading independent conference for software developers, database professionals and IT architects, and features two dedicated tracks of breakout sessions on SQL Server and related topics, plus optional pre- and post-conference workshops.
2009-02-09
412 reads
This tip shows you how to find security holes when aliased users are setup in your databases and also that this feature will be deprecated in SQL Server 2008.
2009-02-09
2,352 reads
Quite the title, so let me set the stage first. You have an Azure...
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers