(Jen Stirrup) In this segment, we will look at the most basic unit of the database: tables. We will look at their implementation in SQL Server and also in Hive.
Author: SSWUG Research
Generic Dynamic SQL Stored Procedure
(Kenneth Fisher) Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle dynamic SQL. Honestly I found the idea interesting and coming up with a solution rather fun.
Creating a Rolling Date Range Named set in MDX
(Mike Davis) One Client I was working with wanted a named set that would give them the last 5 years. Of course this needed to be a rolling 5 years so it automatically moved the years up every January.
Postgres 9.2: monitoring temp files generation in real time
(Denish Patel) With other great new features, PostgreSQL 9.2 makes DBAs life easy by providing more metrics in statistics collector views. Out of those , pg_stat_database caught my eyes because it provides a lot more details compare to Postgres 9.1 and other previous versions.
Lazy Loading Image With AngularJS
(Ben Nadel) At InVision, we deal with a lot of image assets. Not only does loading these images consume concurrent HTTP requests, it greatly increases the weight of the page. As such, I’ve been trying to implement lazy-loading techniques that offer a quicker loading experience for the end user.
Using HTTP Post and Public Property in ASP.Net
(Rohatash Kumar) This article describes some of the techniques to pass values from one page to another page in ASP.Net. When you develop any website in ASP.Net containing many pages, you need to provide navigation to move or browse between pages in the website.
Self Hosting WebAPI with Katana
(K. Scott Allen) A few weeks ago we looked at a minimalistic Katana based project to serve a static response from a console application. For more fun we can throw in the WebAPI with only a little more work. The first step is adding a package that forms a bridge between the OWIN/Katana host and the W
How The Semantic Web Changes Everything. Again!
(David Amerland) The “semantic Web” is hugely important to tomorrow’s business. Do not underestimate its significance: It truly changes everything. Embrace it, or risk extinction.
Escaping XML with Groovy 2.1
(Dustin Marx) When posting source code to my blog, I often need to convert less than signs () to their respective entity references so that they are not confused as HTML tags when the browser renders the output.
Handling Windows Processes using Windows PowerShell for SQL Server
(Manvendra Singh) Often when managing SQL Server you need to review and change Windows process information for SQL Server processes. In this tip I will introduce a few PowerShell cmdlets related to accessing and handling Windows processes and I will explain how to use these Windows PowerShell cmdle