SQL Server – List SQL Agent Jobs

Recently, I had a need to list the SQL agent jobs, owner names and whether each job was enabled or not. Here is the result:

SELECT 
    j.name AS AgentTaskName,
    SUSER_SNAME(j.owner_sid) AS JobOwner,
    CASE
    WHEN (j.enabled = 1) THEN 'True' ELSE 'False' END AS Enabled
FROM msdb.dbo.sysjobs j
LEFT OUTER JOIN MASTER.DBO.syslogins l ON j.owner_sid = l.sid
ORDER BY j.enabled DESC, j.name

And, the results

image

Posted in SQL, SQL Server | Leave a comment

T-SQL Tuesday #66: Monitoring

T-SQL Tuesday

Topic today is monitoring. Catherine Wilhelmsen (b|t) is hosting this month’s T-SQL Tuesday blog party. The party was started by Adam Machanic (b|t) in December of 2009.

I’ve been looking a lot of SQL Server installations over the past year. If there are reports of performance issues, the challenge is finding them.

One way is instrumenting the Server and SQL Server to help identify potential bottlenecks. I really like a new utility called Performance Monitor. OK, I jest. Its been around since NT 4. The nice thing, it is readily available on every server.

Here my approach, capture the key performance counters to a log file, every 5 minutes for a 24 hour period. Once the sampling period is complete, review.

To start, download the following XML file locally

http://1drv.ms/1EATsIU

Save it with the following name: SQLPerformanceV3.xml

Start perfmon.exe

From Data Collector Sets > User Defined, Right click Create a new data collector set, and give it a name”

image

Click Next, then Browse (for a custom template), select the SQLPerformanceV3.xml file saved in the previous step. Click OK

image

Then, click Next

Change the root directory to a drive with available free space

image

Click Next, then Finish

Back to Performance Monitor, there should be a User defined data collector set named SQLPerformance. Right click that set, and select properties. Select the Stop Condition tab

image

Change the overall duration to 1 day. Click OK.

Now, starting it (Right Click > Start ) will create a folder for the performance log file with the Computer name, and a date time entry.

From Performance Monitor, once you are done collecting data and have stopped the trace. Import the log file:

image

Click Performance Monitor, then click second icon from the left

image

Choose, log file, then Add… select the log file that was captured. Then click OK.

Now you can analyze your trace, adding and removing counters as needed. The full extent would be enough for another blog post! I’ve found this to be a very effective method to help identify performance issues.

Lastly, as you make changes to help improve performance, run another 24 hour perfmon capture and compare the results.

Posted in SQL, SQL Server, SQL Server 2012, SQL Server 2014, SQLTuesday | Leave a comment

Microsoft Ignite 2015 – Download Videos and Slides

https://gallery.technet.microsoft.com/office/all-the-Ignite-Videos-and-b952f5ac

Posted in Microsoft | Leave a comment

ConfigMgr 2012 R2 CU5 released

 

Description of Cumulative Update 5 for System Center 2012 R2 Configuration Manager
https://support.microsoft.com/en-us/kb/3054451

Posted in ConfigMgr | Leave a comment

Intune Wiki and FAQ

Collaborative WIKI made available on Intune, MDM, FAQ and more:

http://social.technet.microsoft.com/wiki/contents/articles/28280.microsoft-intune-frequently-asked-questions-faq.aspx

Posted in Intune | Leave a comment

MSI installation based software

Recently I needed to demonstrate ConfigMgr 2012 R2 Software Center for a client. Of course, I needed some demo *.MSI files to import as applications.

One Twitter message later, and I had lots of great suggestions. (Thank you) I’ve compiled a partial list of the downloads here. In part, it might help someone else, and I’ll likely use this as a future reference.

First the suggestions for Free MSI installers:

From codeplex: DBViewSharp, DiffMerge, Expresso, SharpDevelop, StyleCop, XmlExplorer, XPathVisualizer

From Microsoft: XMLNotepad, ReportBuilder, RDCMan, Skype

Others: 7-Zip, Flash, Tweetdeck, Adobe readers/players, trial software from TechSmith.

Now Micro Right Click Tools

ConfigMgr toolkit, ConfigMgr support center, ConfigMgr client center, FileZilla

ConfigMgr console, ConfigMgr PowerShell library

Download links:

Adobe Downloads

ftp://ftp.adobe.com/

Microsoft® SQL Server® 2012 Report Builder

From <http://www.microsoft.com/en-us/download/details.aspx?id=29072>

Remote Desktop Connection Manager 2.7

From <https://www.microsoft.com/en-us/download/details.aspx?id=44989>

XML Notepad 2007

From <https://www.microsoft.com/en-us/download/details.aspx?id=7973>

TechSmith Product Trials and Downloads

From <https://www.techsmith.com/download.html?gclid=CPeS-5SujcUCFYVFaQodU70AtQ>

System Center 2012 R2 Configuration Manager Toolkit

From <http://www.microsoft.com/en-us/download/details.aspx?id=36213>

System Center 2012 Configuration Manager Support Center

From <http://www.microsoft.com/en-us/download/details.aspx?id=42645>

Client Center for ConfigurationManager

From <https://sccmclictr.codeplex.com/>

Posted in ConfigMgr, MSI, Software Center | Leave a comment

New Intune features for Android

Interesting update:

New Intune standalone (cloud only) features that will be made available as part of this update include:

  • Management of Office mobile apps (Word, Excel, and PowerPoint) for Android tablets. (Management of Office Mobile app for Android phones made available in February 2015)
  • Ability to restrict access to Exchange on-premises for Exchange ActiveSync clients on Android devices
  • Ability to create WiFi profiles with pre-shared keys (PSK) for Android devices
  • Ability to resolve certificate chains on Android devices without the need to deploy each intermediate certificate individually
  • Deployment of .appx bundles to Windows Phone 8.1 devices (Support for .appx files made available in March 2015)
  • Managed Browser app for iOS devices that controls actions that users can perform, including allow/deny access to specific websites (Managed Browser app for Android devices made available in December 2014)
  • Management of Work Folders app for iOS devices
  • Updated Endpoint Protection agent for managing Windows PCs
  • Ability to manage Windows Defender on Windows 10 PCs running Windows 10 Technical Preview without need for separate Microsoft Intune Endpoint Protection agent to be installed
  • Combined Microsoft Intune Company Portal websites for PCs and mobile devices to provide a more consistent user experience across platforms
  • Added Windows and Windows Phone Company Portal apps to the Microsoft Download Center to provide an additional option for accessing these app downloads
  • Enhanced user interface for overview pages within Intune admin console

Source: http://blogs.technet.com/b/microsoftintune/archive/2015/04/17/new-intune-features-coming-over-the-next-week-for-android-and-more.aspx

Posted in Android, Intune | Leave a comment