|
|
-
|
|
When working on development projects, one may need to restart servers and/or workstations often. When working from remote locations or on virtual machines hosted on the network, this often becomes a challenge. Today, I will show how to shutdown or restart a local or remote machine via the command prompt....
|
|
-
|
|
Do you have the experience of getting errors for sort for grouped data in Excel? One of problems that most complained during the retail data analytics is further computations on grouped data. While the retail data stored in Excel, it could be time-consuming and fussy with computations on grouped data, especially when there are a lot of groups. Check this articles for my solution....
|
|
-
|
|
Here I’ll share you how to put logging in your C++ application using QT 5.0 framework. It is very easy to implement, first you need to setup message handler once in application then it will return pointer to previous message hander defined. The message ...
|
|
-
|
|
You can do conditional aggregation like SUM(CASE WHEN .. THEN 1 ELSE 0 END),....etc to find a count for a particular match. This type of conditions are useful when you want to write a CROSS-TAB/PIVOT Query. You can also make use of COUNT(CASE WHEN .. TH...
|
|
-
|
|
A database rename operation in Microsoft SQL Server may fail due to multiple reasons - the most common of all being an open connection to the database. Often this is because of the SSMS itself. In this post, I present a simple script that can be used to rename a SQL Server database if open connections are preventing the operation....
|
|
-
|
|
This week, I resolved one issue which I received continuously which is noting but exactly displayed in post title. The issue occurred when I ran ssis package with batch file or scheduled job and same error message raised. Source: Start Exe...
|
|
-
|
|
In this post, we take a look at the Dynamic Management Vies, functions and Catalog Views related to AlwaysON! - the High Availability & Disaster Recovery [HADR] enhancements introduced in SQL Server 2012....
|
|
-
|
|
One of my friends asked me if it is possible to load multiple resultsets returned from a stored procedure into a temporary table for some analysis purpose. The answer is "It depends". If all the resultsets return same number of columns then it is possib...
|
|
-
|
|
When recovering from a database crash, an understanding of the backup timeline and restore sequence is essential. Full, differential and transaction log backups need to be restored in a specifc order. The system stored procedure sp_can_tlog_be_applied helps administrators in determining the restore sequence for transaction logs....
|
|
-
|
|
When I first started working on WCF three years ago, it was an entirely new paradigm for me. I had earlier worked on VB6, C# WinForms and ASP.NET to some extent. I had created some DLLs as well. But working with WCF was entirely a new thing. On top of i...
|
|