(Keith Fiske) One of the easiest ways to monitor slave lag when using streaming replication is to turn hot standby on your slave and use pg_last_xact_replay_timestamp() and/or the other recovery information functions. Here’s an example query to run on the slave systems to get the number of seconds b
Author: SSWUG Research
SSWUGtv News: floating Google demo centers, false Apple unbreakable encryption, and Windows through the years.
Video Programming for IT Professionals
OData Scaffolding
(Kirthi) With the release of Visual Studio 2013 RTM, we added support for scaffolding OData controllers with Entity Framework. In this blog topic we will cover the following topics
Preloading Data Before Executing ngInclude In AngularJS
(Ben Nadel) Earlier this week, I looked at loading AngularJS components with RequireJS after your application had been bootstrapped. While interesting, I disliked the fact that my calling code needed to know about the lazy-loading behavior. What I really wanted to do was centralize the lazy-loading
WPF Base Classes – ItemsControl
(Richard Carr) The thirty-fifth part of the Windows Presentation Foundation Fundamentals tutorial describes the ItemsControl class. This is a base class for WPF controls that display a collection of related items, including one layout control.
IBM Information on Demand 2013, Wednesday
(Craig S. Mullins) Today’s blog entry from Las Vegas covering this year’s IOD conference will be my final installment on the 2013 event.
T-SQL Command Line Options – Part 5 – SQLPS
(Derik Hammer) SQLPS, like SQLPSX, is a set of extensions to Powershell for interacting with SQL Server. SQLPS first appeared with SQL Server 2008 in the form of a mini-console called SQLPS.exe. This mini-console was based on Powershell V1.0 and did not change with the newer version, 2008 R2.
Monitor SQL Server Replication Jobs
(Yaniv Etrogi) The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job)
sp_executesql, Parameters and Parameter Sniffing
(Grant Fritchey) I’m honestly not crazy about dynamic T-SQL within stored procedures. There are just a few too many opportunities to mess it up with dire circumstances to your server and your data.
Disk Space Monitoring: How To
(Michael K. Campbell) Keeping tabs on available disk space on your SQL Servers is something that every DBA should do—because once SQL Server runs out of disk on the underlying host, then everything obviously comes to a crashing halt.