(blakhani) How many times you have been into a situation where you need to run one query across many servers? I have asked his question from one of the DBA and his answer was I will create a linked server and then modify the query to refer linked server. Well this needs modification to server config
Other News
JavaScript patterns simplified
(Igor Vigdorchik) JavaScript language exists since 1995 (if I am not mistaken) and it was always a language of choice for the web client-side development. The language is very simple to learn and start writing code but it’s not easy to become an expert.
Opening up Visual Studio and .NET to Every Developer, Any Application: .NET Server Core open source and cross platform, Visual Studio Community 2013 and preview of Visual Studio 2015 and .NET 2015
(S. Somasegar) Visual Studio and .NET have been two bedrocks of the Microsoft developer ecosystem for over a decade. With over 1.8 billion installations of .NET and over 7 million downloads of Visual Studio 2013 in just the last year, Visual Studio and .NET are enabling millions of developers to bu
Finding SQL with Performance changing over time
(Carlos Sierra) I upgraded my database a couple of weeks ago and now my users complain their application is slower. They do not provide specifics but they “feel” it is running slower. Sounds familiar?
MySQL compression: Compressed and Uncompressed data size
(Peter Zaitsev) MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it comes to tables that employ compression.
Big Data: Model or Not Model?
(Michelle A. Poolet) Big data dudes and dudettes, and those folks who starting to assemble big data stores: Are you faced with issues of how to wrangle database design and data modeling in their big data world?
Always Trigger The $destroy Event Before Removing Elements In AngularJS Directives
(Ben Nadel) If you’re building custom AngularJS directives, you will inevitably find yourself in a situation where you have to clone elements, create new scopes, remove elements, and destroy old scopes.
Removing Scalability Bottlenecks in the Metadata Locking and THR_LOCK Subsystems in MySQL 5.7
(Dmitry Lenev) The MySQL Server 5.7.5 Development Milestone Release, which was published recently, contains some significant changes to the metadata locking (MDL) subsystem and to the usage of the THR_LOCK manager for InnoDB tables.
ORA-01951, ORA-01952 and ORA-01045
(Andrew Reid) I saw a strange question on a forum and decided to reproduce it in an Oracle 12.1 database. First I created a user:
Using PerfMon for SQL Server Reporting Services Performance Management
(Scott Murray) How can I manage and evaluate the performance of my SSRS report server? Do you recommend any native SQL Server tools?