Get all active SPIDs for a database
SELECT d.name , CONVERT (SMALLINT, req_spid) AS spid FROM master.dbo.syslockinfo l , master.dbo.spt_values v , master.dbo.spt_values x ,
using google-gdata to build a simple picasa photo album slide show to integrate in your website
There is a very good sample libraries available by google. [google-gdata][1] You can go through all these example, but for my scenario, I have need only 3 assembles from the core project. 1. Google.GData.Client.dll 2. Google.GData.Extensions.dll
Get all decedent records in SQL Server using CTE
Below is a simple **CTE (Common Table Expression)** Example to retrieve all descendant categories from Category table. WITH Categories AS ( SELECT C.ParentCategoryID , C.CategoryID ,
Recovering a Lost Azure VM Admin Password
- Run Windows PowerShell ISE in administrator mode. - Enter and run the following PowerShell cmdlets hitting enter after each line:
SQL Server Cursor Basic Example
DECLARE @CustomerId int , @Email VARCHAR(500) DECLARE db_cursor CURSOR FOR
