SQL Server 2012 Integration Services introduces an innovative approach to deploying SSIS projects, known as Project Deployment Model. However, the traditional, package-based methodology remains available and supported, and, in some scenarios, it might be considered more viable, since it allows for separation of SQL Server Database Engine and SQL Server Integration Services.
2013-07-05
2,205 reads
Fifty years after starting the 'Art of Computer Programming', Don Knuth is still working hard at the project. It is considered amongst the "hundred or so books that shaped a century of science”. Richard Morris asks him how things are going, and to find out more about his many achievements.
2013-07-04
4,357 reads
In this article, Arshad Ali goes intp detail about how a data warehouse is different from operational data store and the different design methodologies for a data warehouse.
2013-07-03
6,374 reads
Database Administrators must now deal with large volumes of data and new forms of high-speed data analysis. If your responsibility includes performance tuning, here are the areas to focus on that will become more and more important in the age of Big Data.
2013-07-02
3,463 reads
Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams.
2013-07-01
4,367 reads
There may be times when you want to allow non-System Admin logins to be able to execute the xp_cmdshell extended stored procedure. In this articleGreg Larson will show you how to setup xp_cmdshell so non-System Admins can use this extended stored procedure.
2013-07-01
3,252 reads
To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted a solution and comes up with several practical tips for getting the most out of any automated database deployment framework.
2013-06-28
4,648 reads
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.
2013-06-27
3,831 reads
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.
2013-06-25
5,071 reads
What is SQL Server Reporting Services 2012 (SSRS) ReportItems collection and how do I use it? Are there any restrictions on its use? Check out this tip to learn more.
2013-06-24
5,847 reads
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Comments posted to this topic are about the item When the Token Meter is...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers