(Baron Schwartz) With the recent release of Percona XtraDB Cluster, I am increasingly being asked about MySQL’s semi-synchronous replication. I find that there are often a number of misconceptions about how semi-synchronous replication really works. I think it is very important to understand what gu
Other News
Enable Powershell Remoting on SQL Server Instances
(Manvendra Singh) Logging on to each SQL Server instance for daily DBA Administrative tasks can be quite lengthy. Are there any options available in PowerShell to reduce the effort and complexity of managing a SQL Server environment? In this tip, I will describe a step by step process to enable Powe
Implementing resource oriented controllers in ASP.NET MVC
(Pablo M. Cibraro) One common problem with the naming convention and default routing mechanism in ASP.NET MVC is that we tend to group actions in a controller for sharing an URL space. This basically leads to complex controllers with a lot of unrelated methods that break the SOLID principles.
Refreshing an MV on a Prebuilt Table
(Hemant K Chitale) I had earlier demonstrated creating an MV on a Prebuilt Table. A few days ago, I had a question on refreshing such an MV.
MySQL Performance: Overhead of Optimizer Tracing in MySQL 5.6
(Dimitri) Last week I was faced to a strange problem while benchmarking MySQL 5.6: some of my user sessions become “frozen” periodically and finally my whole test was not valid.
More advanced SQL analysis
(Ember Crooks) So the basics of analyzing SQL on db2 are in my post on Analyzing SQL. I wanted to go a bit beyond the basics.
PERFMON Counters Available via Extended Events (XEvents) in SQL Server 2008 R2 SP1
(Mark Weber) The interdependence between a RDBMS and the Operating System (OS) is significant. When involved with performance analysis on SQL Server it is sometimes helpful to know what is happening in the operating system at the same time. This can provide insight into both the query/batch (e.g.
$get And $find ASP.NET AJAX Functions
(Davin Martyn) Ajax (Asynchronous JavaScript and XML) is a new web development technique for interactive websites. AJAX assists in the development of web applications and can retrieve small amounts of data from a web server. AJAX is a different type of technology.
Accidental Programmer
SSWUG TV With Stephen Wynkoop and Sam Brace Watch this edition for interviews with DotCloud’s CEO Solomon Hykes and IT Career Coach Laura Rose. Catch the Show Accidental Programmer One of our favorite topics here at SSWUG is the issues facing the Accidental DBA. This is the person who, for one reason or another, ends up supporting and sometimes developing […]
SQL Server 2008 and 2008 R2 Integration Services – Sort Transformation
(Marcin Policht) SQL Server 2008 R2 Integration Services offer a wide range of pre-built components, which deliver generic functionality commonly required when performing extraction, transformation, and loading tasks. While most of them are fairly straightforward to deploy in their basic form, typic