One More PASS Board Update for 2015

Remember that post I wrote about taking on SQLSaturday events as my new PASS portfolio?

Never mind.*
Instead, it seems I’ll be...

Can we get a license for DDL Triggers?

There are several types of triggers.
Logon triggers – Fired when someone tries to connect to the instance.DML triggers – Fired after...

Picking a Clustered Index

A Clustered Index is not another term for Primary Key, and more thought should be put into the key columns...

Quick Tip: Why Can’t I Pin an Excel Range to a Power BI Dashboard?

So two new exciting capabilities were announced recently in Power BI.  One involved Excel and the other SSRS, but they...

SQL Server – Check the status of active Trace Flags

Hi friends, few days back I was exploring data masking features introduced in SQL Server 2016. I got stuck in...

SQL Server tips ,SQL Server tutorials, database tips- Indiandotnet: Step by Step Merge transformation control in SSIS ...

SQL Server tips ,SQL Server tutorials, database tips- Indiandotnet: Step by Step Merge transformation control in SSIS ...: In the Series...

Step by Step Merge transformation control in SSIS TIP #122

In the Series of Zero to hero in SSIS  this is another post. In this post we are going to...

SQL to generate Asset Information – Configuration Manager SCCM 2012

SELECT   DISTINCT  s.Netbios_Name0 AS ComputerName,  
            s.Operating_System_Name_and0 AS OSName,  
            pr.Name0 AS ProcessorTypeSpeed,  
            pr.Manufacturer0 Manufacturer, 
            pr.NumberOfCores0 Cores, 
            pr.NumberOfLogicalProcessors0 LgicalProcessorCount, 
            case when pr.DataWidth0=64 then '64 bit'else'32 bit' end DataWidth, 
            m.TotalPhysicalMemory0/1024.00 AS MemoryMB,  
            GS1.TotalVirtualMemorySize0 VirtualMemory, 
            GS1.TotalVisibleMemorySize0 VisibleMemory, 
            ip.IPAddress0,  
            T1.COL AS TotalDriveSize, 
            LastBootUpTime0, 
            DATEDIFF(Day,GS1.LastBootUpTime0, GETDATE()) AS [Days since last boot]           
FROM v_R_System_Valid s  
       INNER JOIN v_GS_PROCESSOR pr ON s.ResourceID = pr.ResourceID 
       INNER JOIN v_GS_COMPUTER_SYSTEM gs ON s.ResourceID = gs.ResourceID  
       INNER JOIN v_GS_NETWORK_ADAPTER ON s.ResourceID = v_GS_NETWORK_ADAPTER.ResourceID  
       INNER JOIN v_GS_X86_PC_MEMORY m ON s.ResourceID = m.ResourceID 
       INNER JOIN v_GS_NETWORK_ADAPTER_CONFIGURATION ip ON s.ResourceID = ip.ResourceID 
      -- INNER JOIN v_GS_LOGICAL_DISK AS ld ON s.ResourceID = ld.ResourceID  
       INNER JOIN  
       ( SELECT RESOURCENAME,  
       col 
FROM  
(  
        SELECT DISTINCT TAB.Netbios_Name0 RESOURCENAME,  
            (  
            SELECT COL.deviceid0 +' '+ cast(COL.Size0/1024.00 AS varchar(20))+' ' 
            FROM v_GS_LOGICAL_DISK COL   
            WHERE   
                COL.ResourceID = TAB.ResourceID AND COL.DriveType0=3 
             FOR XML PATH ('')  
            ) COL  
FROM v_R_System_Valid TAB  
 )T  
 where T.COL is NOT NULL  
 ) T1 on T1.RESOURCENAME=s.Netbios_Name0 
       INNER JOIN V_GS_OPERATING_SYSTEM GS1 on GS1.ResourceID=s.ResourceID 
WHERE  
            s.Operating_System_Name_and0 LIKE '%Windows NT Server%' 
     AND  
       ip.IPAddress0 IS NOT NULL AND ip.DefaultIPGateway0 IS NOT NULL        

Advent of Code

I ran across this site after reading a post from Jeremiah Peschka. It’s an interesting idea, and since I’m trying...

SQLSaturday #465 - Providence, RI - Another East Coast Event!

Upcoming this Saturday 12/12/2015, SQL Saturday #465, taking place in the more modest Providence, Rhode Island venue, comes a great...