Other News

Community

Concept of View in SQL Server

(Arun Choudhary) A view is defined by a query and only shows the data which is defined at the time of creation of the view. If you hide particular columns then use the view. A view hides the complexity of the underlying database schema, or customizes the data and schema for a set of users.

Editorials

SQL Azure Federation Sharding

SSWUGtv With Stephen Wynkoop In this episode Paul Zikopoulus with IBM – talking about big data, what it means, why it is important and much more. Watch the Show $$SWYNK$$ SQL Azure Federation Sharding I received a few questions about SQL Azure Federation today. My understanding is strictly through reading documentation materials from Microsoft…so be aware that I may be […]

Editorials Encryption/Data Security

SQL Azure Federations

SQL Azure Federations One of the coolest features in SQL Azure is Database Federations. Federations allow you to grow the power and size of your database in SQL Azure to an much larger scale than the largest single database allowed of 150Gig. For an overview of SQL Azure federations you can watch this into video from Microsoft demonstrating what Federations […]

Community

Running SSIS packages from C#

(Piotr Rodak) Most of the developers and DBAs know about two ways of deploying packages: You can deploy them to database server and run them using SQL Server Agent job or you can deploy the packages to file system and run them using dtexec.exe utility. Both approaches have their pros and cons. Howev