(Lucas Jellema) This very brief article demonstrates how a fairly complex, nested JSON document can be created using a single SQL query. The main features used in the SQL statement are the WITH clause to define the inline views per object (Department, Manager, Employee), Scalar Subquery to retrieve
Other News
Database Mirroring In MS SQL Server – Part I
(Keshav Singh) With this video session I have tried to explain briefly how mirroring can be configured and used as one of the best fail over options for critical databases. Please use the forum below if you have any concerns.
Using WebSphere MQ Telemetry and Pachube to connect to remote sensors and devices
(Nick Maynard) Pachube and the MQTT protocol with its accompanying broker implementations both offer excellent facilities for aggregating data from remote devices and sensor networks into a common API. However, they do not provide a way to integrate data between the two technologies.
Create Watermark Text on an Image in ASP.NET
(Ankit Nandekar) If you want to protect your images from being reused by others, then the best way to do that is with watermark text on the images.
Using Extended Events to troubleshoot SQL Server issues
(Diana Moldovan) As a DBA, you’ll encounter elusive performance, connectivity and locking problems that you’ll need to troubleshoot. There are many tools that you can use such as Profiler. In addition to these tools, SQL Server 2008 offers extended events (“XEvents”), which you can use as a powerful
Injection Prevention Tips and Techniques
SelecTViews With Stephen Wynkoop Find out about business intelligence trend surveys, MySQL in the cloud…the latest news and your SQL Server BI tip for the day. [Watch the Show] Injection Prevention Tips and Techniques In the last couple of newsletters I have provided some code examples of how to prevent SQL Injection. The short answer was to use strongly typed […]
SelecTViews – Insights from MVP Stephen Wynkoop about cloud appropriateness
Video Programming for IT Professionals
How Secure is Secure?
How Secure is Secure? It wasn’t more than a few years ago when Microsoft was the whipping kid when it came to inadequate security measures. Apple, Unix/Linux, Solaris, OS 400, MVS, CMS, etc. were considered more secure because they either didn’t have enough market share, or had less vulnerabilities. Less focus was paid to our own practices in writing code […]
SharePoint Applied: The MasterPage Story in SharePoint 2010
(Sahil Malik) MasterPages were first introduced in SharePoint 2007. Just like in ASP.NET, they allow you to define a base layout, minimum criterion and even some basic logic for all pages that choose to use that master page.
MiniProfiler: Lightweight profiler for ASP.NET web applications
(Gunnar Peipman) I found very cool small profiler that can also be used on production sites to quickly detect bottle necks in web application code. The profiler is called MiniProfiler and in this posting I will introduce you how to use it in your code.