Pulse » Popular Items from 11/2011
Welcome!
Pulse has a simple goal: to give you a quick view of what's happening in the SQL Server community.
-
Browse
Finding interesting content on Pulse is easy – you can drill down to a specific time period (by clicking on the bars of the chart), toggle different types of content on and off, and sort the results by popularity or recency.
-
Vote
Discovered an informative blog post or a hilarious tweet? Tell the rest of the community about it by voting it up or down. Behind the scenes, our popularity algorithm will make sure it rises to the top of the list.
-
Comment
When a simple up-or-down vote isn't enough, voice your opinions in a comment. Or check out what others are saying about something you posted or tweeted.
-
The process could not read file due to OS error 3
When configuring a subscription to a publication in SQL Server, on initialization it is common to encounter the error: The process could not read file X:\Program Files\Microsoft SQL Server\\MSSQL\repldata\\ due to OS error 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL20016)Get help: http://help/MSSQL_REPL20016The system cannot ...
-
Buffer Size in SSIS
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in memory. The benefit of this in-memory processing is that you do not need to physically copy and stage data at each step of the data integration. Rather, the data flow ...
-
SQLRally 2012 Registration Open
The Professional Association for SQL Server and the North Texas SQL Server User Group have been working hard behind the scenes to bring SQLRally 2012 in Dallas Texas to the SQL Community. We are excited to announce that event registration opens November 30, 2011.Make sure to get registered soon ...
-
SQL Server 2012 Master Data Services Error: The required .svc handler mappings are not installed in IIS.
Microsoft SQL Server 2012 Release Candidate 0 (RC 0) has a confirmed issue with Master Data Services configuration. The following error is raised by the Master Data Services Configuration Manager when launched: Before creating an MDS web application, you must correct the following errors: Internet Information Services (IIS) is not ...
-
SQL University– SSIS 2012: Deploying Projects –Lesson One
Lesson One, where I introduce tons of prerequisite new concepts in preparation for Deploying and Executing in Lesson Two. The main concepts and terms covered in this lesson are: Projects Project Deployment Model Legacy Deployment Model Project Reference reference type –Execute Package Task Ispac files Parameters, subdivided into the two ...
-
SQL Fingertips
They Might Be Giants (TMBG) released an album called Apollo 18. It has 38 tracks and it runs for 42 minutes. It’s an album that will always remind me of my friend and first University roommate (Hey, what’s up Chris!). So the average track is about a minute ...
-
SQL SERVER – Using expressor Composite Types to Enforce Business Rules
One of the features that distinguish the expressor Data Integration Platform from other products in the data integration space is its concept of composite types, which provide an effective and easily reusable way to clearly define the structure and characteristics of data within your application. An important feature of the ...
-
The Current SKU is invalid ?!?! WhataHELL ?!?!
Estou montando um ambiente para fazer uns testes de migração de versão de cluster e me deparei com um erro no mínimo grotesco,,, Antes de falar do erro, meu ambiente de testes é formado por: 1 Windows Server 2008 Std sem Hyper-V (para AD) 2 Windows Server 2008 Ent sem ...
-
New Year New Job?
Are you 100% satisfied with your current job? Of course not! When given serious consideration most people will agree that there are some things that they would like to be different or change in their current role. The Christmas holiday season is a popular time for self reflection. The gift ...
-
PASS Regional Mentor – Western Canada Announcement
Now that I’m back from my fun in the sun (Punta Cana) trip I thought I would write a post about some very crazy/awesome news (for me anyways) I’m so excited to announce that I’m the new PASS Regional Mentor for Western Canada!! PASS.ORG link ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.