Mahadevan Business Intelligence
Labels
ASP.NET
(1)
Data Model
(1)
Django
(1)
MDX
(15)
Python
(3)
Redshift
(3)
SSAS
(15)
SSRS
(3)
T-SQL
(29)
Monday, 25 November 2013
Convert Unix Timestamp to Date Format
SELECT DATE_FORMAT(FROM_UNIXTIME(TimeStamp), '%d-%m-%Y %h:%i:%s') AS LogDate
FROM dbo.reportlog
ORDER BY Timestamp DESC
LIMIT 10
Friday, 23 August 2013
T-SQL to Diable all Jobs in SQL Agent
USE MSDB;
GO
UPDATE MSDB.dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1;
GO
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)