Another BI & Programming Blog - Jason Yousef

Hi, this month's T-SQL Tuesday is hosted by Chris Shaw, and the topic is around the DBA's ethics at the work place... The database administrator (DBA) is the person whose responsible for managing the relational database and its access permissions. Well, first of all I am not a DBA and never been one, But I am a developer, and I must admit that I share the same ethics and responsibilities towards the data that I deal with.  The ethics here are cross all  database professionals whose has access to the back end of the company's data, whom can access sensitive information about patients in health care organizations, or sensitive financial information about clients in financial organizations. Every database professional should be striving for technical excellence to the best of his/her knowledge. they should and constantly invest in their career by learning and gain new skills. Privacy and confidentiality is the most important.  Obtaining permiss...

Well, this is my first time to participate in the T-SQL Tuesday, and I'm honored to talk about a new SQL server 2012 feature, and I hope I can do it more often.  SQL 2012 is really a major release and rich full of features, but as an ETL developer I'll pick SSIS as my candidate to demo and share my happiness about one new feature. It really saved me headache and made me say 'Thanks Microsoft' when I heard that it's finally here!  it might sounds simple but it was really a big deal in SSIS. The feature is the new and improved Flat File Source , it now can support ragged uneven number of columns!! yes! finally they thought about it..... Before if you had a flat file that has uneven column numbers, you're out of luck!! you need to use a script task, or read it as one line and do some monkey work or even use bulk insert with the annoying format file to skip a column!! Or use a community task such the " Delimited File Source " oh my god! I remember...

I was one of the first fortunate people to take the 071-467 beta exam (Design Business Intelligence Solutions w/MS SQL Server 2012), using the free SQL 2012 Beta vouchers. Check this link to see what's covered in the exam and get idea of what I'll be talking about http://www.microsoft.com/learning/en/us/exam.aspx?id=70-467 As the name of the exam states, Design Business Intelligence Solutions w/MS SQL Server 2012, it was mostly about every business intelligence product that Microsoft has, you need to be familiar with a variety of tools, starting down from Excel SSRS, SSIS, SharePoint, PerformancePoint and up to SSAS (Analysis Services) BISM and Tubular modes. I must admit that exam was hard and I didn't had the wide knowledge for all these tools and not even much experience about SSAS tubular mode.  It uses a totally different approach than any other SQL server exam that I've taken in the past, it consists of 3 separate cases and 31 multiple choices questions. ...

70-433 is the Microsoft® SQL Server® 2008 Database Development exam code, basically it is the necessarily basic skills for any database professional.  If you are a database administrator, developer or a business intelligence developer, you will need to master these basic skills to understand queries and how the basic T-SQL language is all about. So you are invited to join the SQL 70-433 Developer track study group, If you're studying for the 70-433 or need to be a SQL developer or even if you need to contribute to our study group. Each week a new topic will be hosted by a community member, a link and a discussion will be opened for that topic. Please download the "Skills being measured by topic Cheat Sheet" LINK We'll be using the MCTS 70-433 "Self-paced Training Kit" book from Microsoft Press, the book could be purchased from LINK Also we'll be using the Adventure Works database for SQL server 2008, throughout the demos and examples, it co...

Ms just released 2 days ago the SQL Server 2012 Developer Training Kit includes technical content designed to help you learn how to develop SQL Server 2012 database and BI solutions. You'll need to have the Microsoft Web Platform Installer 3.0 installed before downloading http://www.microsoft.com/web/downloads/platform.aspx Then download the KIT from here... it'll need 269 MB space to download all the sets of LABS, Presentations and Demos. http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27721 In the system requirments, they listed windows 7, windows server 2008. During the installation, it'll give you an options t odownload and install VS2010,SQL 2012 and such required S/W.

Aperantly MS has some goodies for the new year, I posted before a link to the new E-book, and now I just discovered this new GEM... Microsoft Virtual Academy Improve your IT skill set and help advance your career with a free, easy to access training portal. Learn at your own pace, focusing on Microsoft technologies, gain points and get recognition.

Microsoft Press Today, via their Twitter  account, Tossed a link to their new E-book Introducing Microsoft SQL Server Code Name “Denali”. http://blogs.msdn.com/b/microsoft_press/archive/2011/10/11/free-ebook-introducing-microsoft-sql-server-code-name-denali-draft-preview.aspx?CommentPosted=true#commentmessage 

Jen McCown ( Twitter | Blog  ) is calling all the unpublished SQL Server folk and non MVPs! She has this brilliant idea about a community-written book of tribal SQL Server knowledge. http://www.midnightdba.com/Jen/2011/11/sql-tribal-knowledge/ Anyway I've managed to contact her and she was generous to accpet my 3 abstracts after she closed the submition timeline. I'm So excited that I could write for the SQL community and share the knowledge,These are actually what came to my mind back then, but really regret not sending anything about SQL 2012 as it would be more suitable. Title: SSIS notifications, using “SEND MAIL TASK”. Category: Advanced SSIS Level: 300 Goal: Learn about the various ways and the capabilities of SSIS notifications. Abstract: Examining the common and the possible ways to send e-mail notifications for various scenarios, on error, on success using the built in “Send Mail Task” and learning abut it’s limitations, the way...