Guest post by Txomin Barturen, Senior Consultant – CTO Office, EMC Corporation
SQL Server provides customers with a vast array of technology options to address a diverse range of data and reporting requirements including extremely high throughput OLTP environments to bandwidth and time-sensitive reporting and DSS systems. With choice comes the inevitable complexity of defining and building solutions. Customer IT teams are invariably dealing with Service Level Agreements (SLAs) from their in internal customers. Time and financial constraints often limit the ability of internal IT teams to spend significant amounts of time in defining, testing and implementing the broad range of environments that they need to deploy.
Jointly, Cisco and EMC have partnered with Microsoft to deliver a set of solutions that are pre-validated to deliver the requirements for customer SQL Server environments. These solutions implement the collective best practices for server, network and storage, ensuring that customers implement a known valid configuration without the guesswork.
Fast Track Data Warehouse
Dealing with data warehouse requirements requires that solutions be designed to meet the ideal balance between performance, DW size, and cost. Design guidance from the SQL Server team dictates that the total data warehouse size be finely balanced by storage system configuration, server system consumption rate (how fast the CPUs are able to process the data) as well as the interconnectivity between server and storage to deliver at the required rate. To match server configuration, the interconnectivity (including HBAs) and the storage infrastructure requires much design, calculation and testing across a number of disciplines.
Guest blog by Frank Cicalese, a Technical Solutions Architect with Cisco, who assists customers with optimizing their SQL Server workloads on the Cisco Unified Computing System. Before joining Cisco, Frank worked at Microsoft Corporation for 10 years, excelling in several positions, including as a Database TSP.
The Cisco Data Center team is looking forward to engaging with the SQL Server community next week in Charlotte at the PASS Summit 2013. Whether you implement SQL Server on blade or rack servers, Cisco’s Unified Computing System (UCS), with its integrated architecture and centralized management model, can greatly simplify server deployments and improve operational efficiencies.
I’ll be doing a deep dive on the advantages of SQL Server on UCS, in my presentation at the PASS Summit 2013: SQL Server Reference Architectures on Cisco Unified Computing System [DBA-211]. I’ll be providing the details on two important reference architectures for SQL Server including: Microsoft SQL Server 2012 Fast Track for Data Warehouse and SQL Server Consolidation Using Cisco Unified Computing System and Microsoft Hyper-V. My session will be on Thursday, October 17th, at 1:30 PM in room 202 A-B.
Cisco UCS provides unique benefits and advantages as you plan to deploy, manage, and scale your Microsoft SQL Server workloads, including: Read More »
Cisco is proud to be a Platinum sponsor and exhibitor at PASS Summit this year. If you aren’t familiar with PASS Summit, it “is the world’s largest, most-focused, and most-intensive conference for Microsoft SQL Server and BI professionals.”
Gary Serda has done an excellent job in detailing what the Cisco UCS team will be sharing with attendees in his blog post Guide to Cisco at the PASS Summit, so I wanted to highlight our 3D, interactive vRack of our Unified Computing System which is always a highlight at trade shows and will be on display at PASS Summit.
More than 5,000 Microsoft SQL Server and Business Intelligence professionals will be convening in Charlotte, NC, for the PASS Summit 2013. Cisco is proud to support the SQL Server community as a Platinum Sponsor of the PASS Summit. We have an action-packed agenda of activities and hope to connect with you, to discuss how the Cisco Unified Computing System (UCS), with Intel Xeon Processers, integrates with Microsoft technologies to provide the optimal SQL Server platform, – and a bit of fun.
Let’s start with the fun! Cisco is pleased to join with Microsoft as the co-sponsor of the Welcome Reception on October 15th. We’re looking forward to meeting everyone at this festive event. The reception will feature a surprise signature Cisco beverage, in case you get thirsty.
Of course, the Cisco data center team also has fun speaking about our integrated solutions for SQL Server and Microsoft oriented data centers. Please join us in booth 300 to pick up your Cisco UCS cap and speak with a Cisco expert about: Read More »
Detours is a library offered by Microsoft Research for interception of functions on x86 and x64 platforms. It is sold for commercial use to various vendors that build products ranging from security to gaming applications.
Detours is often injected into most or all of the processes, either system-wide or in the context of the logged in user. The most common way this is done is through the AppInit_Dlls registry value. Because the injection is typically applied to a large number of processes running under various permissions, extra care must be taken to ensure the library and its usage are very carefully reviewed by engineers with a strong understanding of the implications of such wide hooking.
We have used this library in our own security products at Cisco (both CSA and AnyConnect) to provide certain security functions on the system. During one of our research projects earlier this year, we noticed a peculiar pattern on Windows systems where processes we were hooking had a change in the in-memory permissions, which marked the headers of the modules from the normal READ/EXECUTE to now include WRITE as well.
This was quite alarming to us, because a dll should not be writeable when loaded into memory. What was interesting, and led to clues of what might be the cause, was that it was only the dlls that had functions we were actively trying to hook. They were the common Win32 dlls that one would typically intercept methods for, such as Kernel32.dll.