Resources for Learning SQL Server In this edition of the SSWUG newsletter I respond to a question from Tim regarding learning resources. Tim writes: I’m enjoying your newsletter. I’ve been an oracle DBA for over 10 years and am just now being introduced to the SQL Server world. Your newsletter is a huge help in my transition. You sign off […]
Other News
Try MONREPORT to generate monitoring reports
(Henrik Loeser) DB2 includes several system-defined modules that can come in handy. One that I would like to point you to is MONREPORT.
More about REST: File upload download service with ASP.NET Web API and Windows Phone background file transfer
(Yi-Lun Luo) Last week we discussed RESTful services, as well as how to create a REST service using WCF Web API. I’d like to remind you what’s really important is the concepts, not how to implement the services using a particular technology.
The Big Market for Big Data Professionals
(Angela Guess) Semantic web professionals looking for work might want to consider tweaking their resumes to include the words “data scientist.”
Release 2 of the Altova MissionKit 2012
(Erin Cavanaugh) It’s an exciting week here at Altova! We have several new offerings to tell you about, including Release 2 of the Version 2012 Altova MissionKit and entire product line, a new Altova Online Training course on XSLT Technology, and a new service called Altova Product Consulting.
Oracle’s Ever Increasing Index
(David Fitzjarrell) Indexes are interesting objects — they can dramatically improve performance but their management can be, well, tricky. Depending upon how data is inserted into and deleted from a table the size an index can attain could be surprising to the DBA. How can the size be surprising?
Multi-page forms with the SharePoint Scenario framework
(Waldek Mastykarz) Splitting long forms into multiple pages is a great idea from the usability point of view. The downside is that it requires you to create some sort of mechanism of persisting the data between the pages. The good news is that SharePoint 2010 provides you with a framework for that p
SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’ as the user is currently logged in.
(Pinal Dave) Yesterday I wrote a blog post discussing how guest user can become security threat. The script which was demonstrated for the example had a small T-SQL query which creates a new user.
An Introduction to Microsoft Roslyn
(Arun Karthick) Microsoft Roslyn has been released as CTP (Community Technology Preview) and can be downloaded from here. It can be installed on top of Microsoft Visual Studio 2010. Once Roslyn is installed you will find a few project templates available as shown in Fig 1.0.
Synchronization with Microsoft SQL Server Analysis Services
(Baya Dewald) Analysis Services databases must serve a large population of users, and it is best to exploit a scale-out approach: distribute the querying load across multiple hosts, each of which has a copy of the same database.