Thursday, December 27, 2012

Understanding SQL Server Concurrency

Hi,

Hope you all are doing well and had a great christmas.

Hope everyone understand what a concurrency means and what problems it can cause. To understand it better I request everyone to go download & go through this book:

Click here to download the book. Key in your email id and Name to download the book.

Book Name:  SQL Server Concurrency (Locking, Blocking and Row Versioning)
Author: Kalen Delaney

Here is the list of chapters from the book:

Chapter 1: Concurrency and Transactions
Chapter 2: Locking Basics
Chapter 3: Advanced Locking Concepts
Chapter 4: Controlling Locking
Chapter 5: Troubleshooting Pessimistic Concurrency
Chapter 6: Optimistic Concurrency

I am sure you all will find this extremely useful & can make full use of it.

Let me know if you find any problem in downloading the file.

Regards,

Sudhir Chawla

Wednesday, May 30, 2012

Getting Started with SSRS 2012 Webinar

Guys,

In this session Chris will give an introduction to reporting with Microsoft SQL Server Reporting Services (SSRS) 2012. You’ll learn everything you will need to know to get started when creating your first reports using the latest release of SSRS. During this session we will also discuss and review the latest features and updates that have been included such as Power View, Data Alerts, Rendering Formats, and SharePoint integration.


Click here to Register.


Date: Tue, Jul 10, 2012 8:30 PM - 9:30 PM IST


Happy Learning


Sudhir

Data Cleansing with SSIS 2012 Webinar

Guys,

In this session, you’ll learn how to use the Data Profiling Task, Script Transform and Fuzzy logic. Also learn how to use Data Quality Services (DQS) and Master Data Services (MDS) to normalize and cleanse your data.


Click here to Register.


Date: Tue, Jul 31, 2012 8:30 PM - 9:30 PM IST


Happy learning


Sudhir

Creating your first custom SSIS Component Webinar

Guys,


Chris will show you how to create your own custom SSIS data flow transformation. We will cover how to read input data, process the input data and send data to outputs.


Click here to Register.


Date:Tue, Jun 19, 2012 8:30 PM - 9:30 PM IST


Happy Learning


Sudhir

Optimising SQL Server 2012 webinar

Guys,


An "accidental DBA" is a SQL Server administrator who has been thrust into the task without having the experience or know how required to keep SQL running at peak performance. This is not their fault and is purely due to the fact that they have not been exposed to it before. If you are a DBA and find yourself wondering how hardware changes affect performance or have questions relating to the performance implications of partitioning or compression, then this session is for you. I will be exploring topics such as Memory configuration, CPU options and IO considerations.


Click here to Register


Time: Thu, Jun 14, 2012 8:30 PM - 9:30 PM IST


Happy Learning


Sudhir

SSIS ETL for beginners webinar from Pragmatics

Guys,


In this session Brad will show us how to use SSIS to connect to a variety of different data sources and destinations such as Excel, SQL Server, Oracle and Flat Files. He will then discuss some of the DOs and DON’Ts of the SSIS ETL world, including looking at ways to use SSIS to do a simple data dump, keep tables in sync, do incremental loads, deal with very large data sets that we may not be able to handle all in memory, and bring multiple sources into one destination.


Click here to Register.


Time: Tue, Jun 5, 2012 8:30 PM - 9:30 PM IST


Happy Learning


Sudhir

Thursday, May 17, 2012

SQL Server 2012 Developer Training Kit Web Installer

Guys,

As we all know that SQL Server 2012 is already launched. It's time to learn more about it, so here is SQL Server 2012 Developer Training kit Web installer kit.

Click here to download it.

Happy Learning

Sudhir

Essential Guide to SQL Server 2008 R2 for the DBA

Guys,

Here is another book by Allen Hirt on SQL Server 2008 R2 for the DBA.

More than just an update to SQL Server 2008, R2 is a brand new version. This essential guide will cover the major changes in SQL Server 2008 R2 that DBAs need to know about.

Click here to download it.

Happy Learning

Sudhir

Free eBook on SQL Server 2012

Guys,

Here is an ebook on Introducing Microsoft SQL Server 2012 by Ross Mistry & Stacy Misner.

Below are the contents of the book:

  • CHAPTER 1 SQL Server 2012 Editions and Engine Enhancements 
  • CHAPTER 2 High-Availability and Disaster-Recovery Enhancements
  • CHAPTER 3 Performance and Scalability 
  • CHAPTER 4 Security Enhancements 
  • CHAPTER 5 Programmability and Beyond-Relational Enhancements 
  • CHAPTER 6 Integration Services 
  • CHAPTER 7 Data Quality Services
  • CHAPTER 8 Master Data Services
  • CHAPTER 9 Analysis Services and PowerPivot
  • CHAPTER 10 Reporting Services

Click here to download it.

Happy Learning

Sudhir

Perm positions at Credit Suisse Mumbai

New Permanent positions at Credit Suisse Business Analytics India Pvt Ltd

Send your CV with matching requirement(s) to me asap.

Team
Role
Required skills set
Experience Level
PS
Managed Lending Dev Team lead
Sybase
4 - 8 years
PS
Managed Lending developer
.Net C#, Sybase
4 - 8 years
PS
Stockloan Trade management Developer
.Net C#, Sybase
2 - 4 years
PS
Risk & Margin Q1
Perl, Sybase, UNIX, Finacial background
4 - 8 years
CTT
CTT Java Developer
Technical: Java, Unix, Scripting, Level 2 Support
Business: Investment Banking
4 - 8 years
PS
PB - ETL developer
Informatica, Oracle, Unix, perl, sybase
2 - 6 years
PS
PB - PV developer
Sybase, informatica, unix
2 - 6 years
PS
Risk Sharepoint Developer
MS sharepoint, COM
4 - 8 years
PS
Risk developer
Sybase, informatica, unix
2 - 6 years
PS
PF Developer
C#
4 - 8 years
PS
PF Developer
C#
4 - 8 years
PS
PF Developer
C#
4 - 8 years
PS
PF Developer
C#
2 - 4 years
PS
PF Developer
C#
4 - 8 years
GAT
GAT Team Lead
2-4 years of financial application development experience
4 - 8 years
GAT
Replacement Hire 1
Experience on Stata, Matlab, SQL
2 - 4 years
GAT
Replacement Hire 2
Expertise in Risk Management / Quantitative Finance
2 - 4 years
CTT
OTC Clearing Development Lead
Technical: Architecture/Design, Java (Core, Swing, UI), Web Development (Javascript, JSP, Servlets, HTML), Server/GUI/Application Development, Unix, SQL/DB, Scripting, Level 2 Support, Trading System Development, SDLC, Analytical
Business: Investment Banking, Equities/Fixed Income/FX/Derivatives, OTC Clearing, Team Leading, Business Parnership, Vendor Management
4 - 8 years
CTT
OTC Clearing Business Analysis
Technical: Architecture, Trading Systems, SDLC, Business Analysis, MS Office
Business: Investment Banking, Equities/Fixed Income/FX/Derivatives, OTC Clearing
3 - 6 years
CTT
OTC Clearing Development
Technical: Java (Core, Swing, GUI), Web Development (Javascript, JSP, Servlets, HTML), Server/GUI/Application Development, Unix, SQL/DB, Scripting, Level 2 Support, SDLC, Analytical
Business: Finance
3 - 6 years
CTT
OTC Clearing Development
Technical: Java (Core, Swing, GUI), Web Development (Javascript, JSP, Servlets, HTML), Server/GUI/Application Development, Unix, SQL/DB, Scripting, Level 2 Support, SDLC, Analytical
Business: Finance
3 - 6 years
CTT
OTC Clearing Development
Technical: Java (Core, Swing, GUI), Web Development (Javascript, JSP, Servlets, HTML), Server/GUI/Application Development, Unix, SQL/DB, Scripting, Level 2 Support, SDLC, Analytical
Business: Finance
3 - 6 years
CTT
OTC Clearing Development
Technical: Java (Core, Swing, GUI), Web Development (Javascript, JSP, Servlets, HTML), Server/GUI/Application Development, Unix, SQL/DB, Scripting, Level 2 Support, SDLC, Analytical
Business: Finance
3 - 6 years
CTT
OTC Clearing Development
Technical: Java (Core, Swing, GUI), Web Development (Javascript, JSP, Servlets, HTML), Server/GUI/Application Development, Unix, SQL/DB, Scripting, Level 2 Support, SDLC, Analytical
Business: Finance
3 - 6 years
CTT
Service Delivery
Technical: Architecture/Design, Unix, SQL/DB, Level 2 Support, Front/Middle/Back Office Systems, Business Analysis, Application Development, Electronic Trading, SDLC, Project/Program Management, Analytical
Business: Investment Banking (Front/Middle Office), Equities/Listed Derivatives, Business Partnership
4 - 8 years
TT
Analyst Developer
PM/BA
2 - 4 years
PS - PF
PF Developer
Java/J2EE, jms, messaging, hibernate, spring, Oracle, Sybase, JSP, struts, ajax, MQ,

8 + years
GAT
Replacement Hire 3
C# in windows environment
2 - 4 years
PS - PB
Risk & Margin Q1
Windows C++,COM+, SQL Server (2008 knowledge preferred),  C#, .NET
2 - 4 years
Cash IT
AEP Tools developer
.NET C# + Winforms + Multithreading + OO + Design + Databases (Sybase or Oracle)
4 - 8 years
Cash IT
CETS developer
.NET C# + Winforms + Multithreading + OO + Design + Databases (Sybase or Oracle)
4 - 6 years
Cash IT
Program Trading developer
.NET C# + Winforms + WPF + Multithreading
2 - 4 years
Cash IT
Goman developer
.NET C# + Winforms + Multithreading
2 - 4 years
Cash IT
Client Connectivity FIX Engineer
Unix + Databases (Sybase, SQL, Oracle) + FIX protocol
3 - 6 years
Cash IT
AES Support Analyst
Previous production support experience + Databases (pref. Oracle) + prepared to work late/overnight India hours
2 - 4 years
Cash IT
Tick Data Analyst
Unix/Linux + Shell scripting + Databases (Sybase, SQL, Oracle)
2 - 4 years

Happy hunting

Sudhir

Wednesday, March 21, 2012

Twelve Days of SQL Server 2012 Webinar Series - Register Now

Guys,

Pragmatic works is coming with a series of 12 webinars from April to May.

Below are details of all the webinars:

SQL Server 2012 Overview-What's New

, 1 hour

AlwaysOn SQL Server Failover Cluster Instances and Availability Groups

, 1 hour

Power View (SSRS)

, 1 hour

Reporting Builder 3.0 and Reporting Services

, 1 hour

Data Quality Services

, 1 hour

Analysis Services - Tabular Modeling (SSAS)

, 1 hour

PowerPivot 2.0 for SharePoint 2010 (SSAS)

, 1 hour

What's New in Integration Services

, 1 hour

Master Data Services

, 1 hour

Data Mining

, 1 hour

What's New in SQL Server FastTrack 4.0

, 1 hour

Microsoft Data Warehousing — 5 TB to 1 Petabyte Solutions

, 1 hour
Happy Learning
Sudhir

Tuesday, March 6, 2012

Webinar on Database development best practices

Guys,

There is a webinar today on Database development Best Practices.

Developing and maintaining databases is a lot of work. Luckily, you don’t have to reinvent the wheel every time you start a new database. There are a number of best practices for designing, building and deploying databases that you can put to work within your environment. This session will introduce best practices and mechanisms focused on helping you develop and maintain your systems in an easier way. We’re also going to show you some Red Gate tools that can make you even more efficient in getting your work done.

Speakers:

Grant Fritchey is the Product Evangelist for Red Gate Software and a very scary DBA.

Jeremy Kadlec is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com and a SQL Server MVP.


Click here to register.

Happy Learning

Sudhir