Exporting data to XML format using SSIS initially seems like it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in flat file. My solution was to use a script task which worked well.
Download your free copy of SQL Server Transaction Log Management and see why understanding how log files work can make all the difference in a crisis.
Building great culture in a company is hard, and it takes work. Building great engineering culture can be more challenging, given the strong ideas and opinions people have in technology. Steve Jones has a few thoughts today.
The state of data security is getting better in the US, according to the 2013 survey from Symmatec. However we still have issues.
This metric for Red Gate SQL Monitor measures the number of database autogrowth events (data file or log file) in the last hour. Too many autogrowth events causes disk fragmentation which requires a change in the autogrowth settings of a database.
Tables that log a record of what happens in an application can get very large, easpecially if they're growing by half a billion rows a day. You'll very soon need to devise a scheduled routine to remove old records, but the DELETE statement just isn't a realistic option with that volume of data. Hugo Kornelis explains a pain-free technique for SQL Server.
Come join the SQL Server Luxembourg UG for free training and networking on June 27th at 5:30pm. Soren Nielsen will take a Deep Dive into SQL Server 2012’s “Always On” High Availability technology. This will be followed by Vern Rabe of the SQL User Group in Portland, Oregon, presenting “Data Types - Think You Know It All? Think Again”.
Change Data Capture (CDC) records DML operations performed on SQL tables and makes records available with information regarding what changed and when the change happened in a simple way.
We know a lot about how great exponents of the DBA profession work, but the role is changing rapidly. What makes a great Data Scientist? Or a great BI specialist?
Where is the dividing line between work time and personal time? As more and more employees get new phones, such as the Blackberry and iPhone, is the line becoming too blurred? Are there legal implications?
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
When running bcp on Linux, what is the field terminator?
See possible answers