(Dominic Brooks) A reminder about sql logic required to deal with express datetimes to the nearest x mins – for example, this particular question come up on an internal forum last week where the poster wanted to aggregate data per quarter hour.
Other News
Visual Studio 11 – Awesome New Features for Web Developers
(Sumit Maitra) The Visual Studio 11 Beta along with the latest .NET framework 4.5 has been out for about two months now and there are a slew of really good features that aligns with Microsoft’s goal of ‘Developer Happiness and Productivity’. In this article we will focus on the Web Developer specifi
Writing asynchronous HTTP Module in ASP.NET 4.5
(Brij) Today again, I am going to discuss , one of the new features that got enhanced in ASP.NET 4.5. And It is Asynchronous HTTP Module . And it’s going to be very useful if used meticulously.
Using LogMiner to find out who dropped a table
(Mike Dean) I recently ran into a situation where some tables were accidentally dropped from a production database. I was able to restore the data pretty easily and afterwards, the obvious question came up: Who did it? If Database Auditing were enabled and configured, then likely I could have answer
ASP.NET basics: the page life cycle
(Tony Patton) ASP.NET is a powerful platform for building Web applications. With any platform, it is important to understand what is going on behind the scenes to build robust applications. The ASP.NET page life cycle is a good example to explore so you know how and when page elements are loaded and
IBM DB2: Moving into the Era of Big Data
(Conor O’Mahony) Back in the 1970s, a team of IBM researchers sought to create a new architecture for storing, managing and interacting with digital data to free application developers from the burden of having to know the details of how data was managed.
New T-SQL Features in SQL Server 2012
(Dinesh Asanka) Paging is a big issue for developers as it is required for many applications but entails many performance problems. Developers have used different workarounds to support paging.
New Cache-Related Counters in the Query Subcube Verbose Event
(Chris Webb) I was studying a Profiler trace run on a SSAS 2012 Multidimensional instance today, and I noticed some new information was being returned in the Query Subcube Verbose event relating to caching.
Hierarchical Queries with Common Table Expressions
(Damon Armstrong) I wanted a simple example of a hierarchical query using a common table expression in SQL Server. MSDN had an example called Recursive Queries Using Common Table Expressions, but it relied on the Adventure Works database and was joining across three different tables.
ODBC drivers replacing OLE DB? Say what?
(Roman Rehak) Recently, Microsoft made an announcement that sounded like a cruel joke. After years of telling users that Open Database Connectivity (ODBC) was an old technology that should no longer be used and would be phased out in favor of Object Linking and Embedding Database (OLE DB), they decl