DataBase

SQL Programming: Saving/Listing each row in a SQL SELECT query results set

Posted on

While debugging various enterprise management software’s that ship with a data hosted on SQL database, systems engineers requires to run various SQL queries to get the underlying information. While debugging the results returned from the query, one need to be able to observer each row returned by the SQL query. Here is quick way to run your any DQL query and verify the results at each row. This will be essentially handy when you want to inspect the temporary data in your SQL program. Advertisements

Advertisements
DataBase

SQL Programming: Convert UTC Time to Local Time

Posted on

Most of todays enterprise software’s get data gathered from workstations located various parts of the world that run in different time zones. To ensure the data integrity and proper processing of events/information, software’s rely on saving the date  data in UTC and then convert them at run time for reporting. When you have to run queries manually, you need to take care of this note and as well need to convert the date data into your local time and here is a quick trick that can help you. .

DataBase

Symantec Endpoint Protection (SEP) Reporting: SQL Stored Procedure to Generate Monthly Reports

Posted on

It’s the security officers responsibility to overview the firm’s infrastructure risk exposure and trends in real time. Unfortunately, none of the industry leading security products has a feature to create a consolidated risk report that can help the top security officers to review and keep track with risk events. As I’ve great exposure into SEP DB schema, I’ve developed a SQL query that generates a consolidated report in a high level format classifying the risk events into below categories: SQL Stored procedure SEP_generate_monthly_reports: