Follow me !
Search this blog
-
Recent posts
Tags
- AIX
- Apple
- automation
- backup
- best practices
- Bootcamp
- cloud
- cursor
- db2
- db2 compression
- db2 hadr
- db2 performance
- db2 tuning
- db2 v9.5
- db2 v9.7
- db2move
- db2pd
- indexes
- install
- iPad
- iPhone
- linux
- Macbook
- memory
- NULLID
- Oracle
- package
- performance
- restore
- runstats
- script
- shell script
- sql
- SQL805N
- SQL Server
- stored procedure
- tablespace
- time machine
- tuning
- ubuntu
- ubuntu 9.04
- upgrade
- Windows on Mac
- wordpress
Disclaimer
The posts here are solely my personal views and opinion. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with technical support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. I do not represent any vendor or product.
Category Archives: how to
SQL Server Replication status
Few days back I had to query to my production sql replication server to find what all publications are running and what is the status for each of those. A search on the web found me this (unfortunately I don’t … Continue reading
Posted in database, how to, sql server
Tagged distribution, publication, replication, sql replication, subscriber
Leave a comment
Find SSRS reports that are run
WITH RankedReports AS (SELECT ReportID, TimeStart, UserName, RANK() OVER (PARTITION BY ReportID ORDER BY TimeStart DESC) AS iRank FROM dbo.ExecutionLog t1 JOIN dbo.Catalog t2 ON t1.ReportID = t2.ItemID ) SELECT t2.Name AS ReportName, t1.TimeStart, t1.UserName, t2.Path, t1.ReportID FROM RankedReports t1 … Continue reading
Drill your data on hadoop cluster using Apache Drill
I have been working on MapR and Cloudera big data distribution for the past year. I have been fascinated by its capability. One of my favorite is Apache Drill, a schema on read SQL interface to HDFS file system. Its … Continue reading
Posted in BigData, hadoop, how to
Leave a comment
How to setup ssh keys
I was trying to setup ssh keys on my linux servers and found this link to be very useful https://www.digitalocean.com/community/tutorials/how-to-set-up-ssh-keys–2 Credit goes to: Etel Sverdlov of digital ocean on explaining