(Troy Coleman) Over the last 10 years, the velocity of change in applications and databases has increased while IT staff has become leaner. This challenges Database Administrators (DBAs) to keep databases optimized and in step with supported applications. Fortunately, there are also tools that provi
Author: SSWUG Research
ZooKeeper fundamentals, deployment, and applications
(Mark Grover) Apache ZooKeeper is a high-performance coordination server for distributed applications. It exposes common services — such as naming and configuration management, synchronization, and group services — in a simple interface, relieving the user from the need to program from scratch.
Data Pump 12c – Pumping Data with the LOGTIME Parameter
(Steve Ries) Since its release, Oracle Data Pump has been a worthy successor to the traditional exp/imp tools. However, one area lacking with Data Pump has been something as simple as the ability to identify how long each step of a Data Pump job actually takes.
Identifying Bloated Index in Oracle
(Anand) Indexes have always been a topic of interest for DBA/Developers. When it comes to index rebuild there have been many opinions floating across internet on when to rebuild these indexes. Many do say when the BLEVEL is > 3 one should rebuild the indexes. I don’t believe in that and i think i ha
Encoding Media in WindowsAzure and Monitoring Progress using SignalR
(Sumit Maitra) Explore how to Encode Media in Windows Azure from our previously built Azure Media Portal in ASP.NET MVC. We’ll also use SignalR to monitor progress.
‘Unraveling Tangled Code’ recording and downloads!
(Jen McCown) Last weekend I gave my “Unraveling Tangled Code” talk at SQL Saturday Oklahoma, and they were kind enough to record and post the session over on UserGroup.TV! You can get the slide deck and demo code here.
Upload and download files using ASP.NET MVC
(Rachel Appel) Uploading and downloading files are common functions you’ll see in most websites and apps. Fortunately, it’s easy to write code to upload and download files using ASP.NET MVC. To start, we need a view and controller pair to upload a file. This is the same HTML and MVC code that you al
ASP.NET and F# (I.) – Creating MVC web applications in F#
(Tomas Petricek) Some time ago, I wrote a couple of examples of developing web applications in F# using ASP.NET. Since then, the F# language and runtime has changed a little bit and there are also new technologies available in ASP.NET, so I thought I’d write a more up-to-date article on this topic.
JSON vs XML: How JSON Is Superior To XML
(Kasia Mikoluk) For a while, XML was the only choice for open data sharing. There were no other open formats available and XML was hailed to be the do-everything solution to data sharing problems. This one format could handle classical data like numbers and text, but it could also manage documents,
Step-By-Step: Creating a SQL Server 2012 AlwaysOn Availability Group
(Edwin Sarmiento) One of the most talked about (and now frequently requested) feature in SQL Server 2012 is AlwaysOn Availability Groups. It brings SQL Server high availability and disaster recovery to a whole new level by allowing multiple copies of the database be highly available and potentially