Another BI & Programming Blog - Jason Yousef

Hi, Today I will be talking about the SQL Server Import and Export Wizard, which is one of the easiest ways to develop your first SQL Server Integration Services (SSIS)  package, and it so useful to export and import data from multiple sources to a various destinations, varies from relational database tables to text files. Through the demo I will be using SQL Server 2012 on top of a Windows 2008 Sever, but the wizard is exactly the same as it was in erlier versions. You start by learning the different ways to get the wizard up, and it is straight forward and can be launched from various locations 1-from the run commend or the command prompt, you might type "DTSWizard.exe" and hit enter, which will get the wizard up and running..  2-By right click on your database---> Tasks--->"Import Data" or "Export Data"  3-From SQL Server Data Tools (SSDT) , right click on "SSIS Packages" and select "SSIS Import and Export Wizard...

Today's post will take us back almost 14 years, back to SQL server 7! I often see that question in forums, and some people are confused it with BIDS or don't know what its usage. SSMS stands for SQL Server Management Studio, lets you connect to your database servers to explore ,edit and create data, tables, views, stored procedure and such database objects. where you write your T-SQL. Also allows you to configure your server's properties, do your backups, connect to the SQL agent, and it gets installed as part of the client tools installation, using the SQL server CD or DVD. It was introduced in SQL 2005 and above, prior to 2005 for example in SQL 2000 it used to be called enterprise manager. SQL server 7 Enterprise Manager SQL server 2000 Enterprise Manager SQL server 2008 SSMS   SQL server 2012 SSMS You can read more about it here... http://en.wikipedia.org/wiki/SQL_Server_Management_Studio http://msdn.microsoft.com/...

I'm excited to write my first blog post in 2012 with a new year resolution, 99% of the times when I create a SQL agent job I forget to set the category of the job to a meaning category instead of the default [ Uncategorized - (Local) ] Does your jobs looks like this? Make it a habit and add the category.. To add more categories to the list...(Right-click Jobs , select Manage Job Categories, then Add) Hope that helps you to get your server more organized !

Introduction This is a review of a great utility that I evaluated as a possible solution for replacing the Intellisense in SQL server management studio named dbForge SQL Complete which could be found at http://www.devart.com/dbforge/sql/sqlcomplete/ . I was surfing the SQL Server newsgroups for help with some T-SQL issues and I saw a post with a link to that utility. I went to their website and downloaded a free evaluation for 30 days. I could not believe how simple it was to use and how thoroughly it solved my code writing problems. I am still a fan and hooked and it's one of the tools that I need to install on each machine that I’m working on, wherever I go! The Environment The evaluation was done on various operating systems and various SQL server versions, windows vista 32 BIT with SQL server 2008, windows 7 enterprise 64Bit with SQL server 2008R2 and windows 7 enterprise 64Bit with SQL server 2005. Download The best thing ever that companies could offer a free trial of their p...

I had hard time today trying to find out where Microsoft hed the Activity monitor in SQL 2008, it's in the tool bar itself, as a graph icon, dispite it's old location in 2005 under the tools menu.

Arabic_CI_AS is the test collation, and being used in my work environment. This white paper is helps a lot .. http://technet.microsoft.com/en-us/library/cc295829%28SQL.90%29.aspx Gives you a detailed overview of the Arabic collation.

SQL Server has 3 recovery model types which control types of backups so let’s discuss in more details all recovery types when you do these operation sequential right click any database—> properties –> select Pages –> options you will see the dialog bellow as you see in fig above you have 3 types the relationship between backup types(Rows Headers) and Recovery Models(Columns Header) are   Full Bulk-logged Simple Full Backup Yes Yes Yes Differential Backup Yes Yes Yes Transaction Backup Yes Yes No it’s very clear that you can’t make trasaction log backup in simple mode. so what is the Differential between Full mode and Bulk-Logged mode? Full mode log any transaction in Transaction log file but Bulk-logged can’t log huge transaction to log file like bulk insert or create index in huge tables you can use Bulk logged for more performance to insert bulk data to database because in this mode you will not log in...