(Michael McLaughlin) Somebody wanted to know how to find any non-unique indexes in information_schema of the MySQL. The query takes a session variable with the table name and returns the non-unique indexes by column names. It uses a correlated subquery to exclude the table constraints.
Other News
How to resolve connectivity issues with SQL Server Availability Groups
(Carla Abanes) After you have completed your AlwaysOn setup and configuration in a multi-subnet environment, you get a number of calls from the application team that they are having intermittent connectivity issues with the database server.
Managing Q&A Synonyms in Power BI for Office 365
(Melissa Coates) Before diving into details, I have a question for you reader: What do you expect to happen with this sequence of events?
Active sessions and block duration
(Derik Hammer) As a DBA, we all need the ability to take a quick glance at the currently active processes on our servers. A lot of times we do this during a problem such as transaction blocking. The first tool that normally comes to mind for this type of investigation is sp_who2. sp_who2 is undocume
A Couple of Database Predictions
(Craig S. Mullins) I usually try to avoid predicting the future because humans, as a general rule, are not very good at it. But when things look repetitive or cyclical, then sometimes a “bold” prediction here and there is worth attempting.
Introduction to Using the PowerShell Command Line with DB2 on Windows
(Ember Crooks) I have worked with DB2 on Windows on and off over the years and have largely not enjoyed it all that much. Most likely because the vast majority of my time is spent on UNIX and Linux systems, so when I end up at a windows command line, my fingers type things like “ls” and “grep” befor
WPF Shapes – Path – Path Markup Syntax
(Richard Carr) The one hundred and thirty-second part of the Windows Presentation Foundation Fundamentals tutorial completes the examination of Paths. This article describes path markup syntax, which provides a shorter way to describe complex paths of lines, arcs and Bézier curves.
Providing State-Transformation Triggers Using $location In AngularJS
(Ben Nadel) When I first started using routes, nested views, and deep linking in AngularJS, I thought that everything in the URL had to be related to the route. As such, I rarely ever used the $location service, except to change the path in order to trigger a new route-change event.
Understanding ASP.NET MVC using real world example, for beginners and intermediate
ASP.NET presented developers with a new framework for website development, in which they would easily distinguish between data layer, business layer and the methodology they would use to render these objects on the screen.
Introduction to WCF
(pramod Thakur) In this article we learn what is WCF, why we use it and what are the features of WCF.