Tag: SQL Server

Technology - How to Get the Version of a SQL Server Database

How to Get the Version of a SQL Server Database

When working with SQL Server, you may wonder how to get the version number of a database instance. Thankfully, there are a number of ways to get the database’s version number. These methods can be used in FileCabinet CS, SQL Server Management Studio, and even T-SQL. These steps will help you find out the exact version number of your database. Read on to learn how. Getting the version number in FileCabinet CS If you want to use SQL for your file sharing applications, you must know how to get the version number of a SQL Server database from FileCabinet CS.

Continue reading

SQL Server Length Function Equivalent

The purpose of the Length function in SQL The SQL LENGTH function returns the number of characters in a string. The LENGTH function is available in many Database Management Systems (DBMS). The LENGTH Function Syntax LENGTH(string) LENGTH Function Notes If the input string is empty, the LENGTH returns 0. If the input string is NULL, the LENGTH returns NULL. Length Function Across Databases When working as a technical consultant, one has to work with customer’s databases and as you move from one database to another you will find that the function commands may vary–assuming the database has an equivalent function.

Continue reading

Technology – Denodo Data Virtualization Project Roles

A Denodo virtualization project typically classifies the project duties of the primary implementation team into four Primary roles. Denodo Data Virtualization Project Roles Data Virtualization Architect Denodo Platform Administrator Data Virtualization Developer Denodo Platform Java Programmer Data Virtualization Internal Support Team Role To Project Team Member Alignment While the denodo project is grouped into security permissions and a set of duties, it is import to note that the assignment of the roles can be very dynamic as to their assignment among project team members.  Which team member who performs a given role can change the lifecycle of a denodo project. 

Continue reading

denodo Virtualization – Useful Links

Here are some denodo Virtualization references, which may be useful. Reference Name Link denodo Home Page https://www.denodo.com/en/about-us/our-company denodo Platform 7.0 Documentation https://community.denodo.com/docs/html/browse/7.0/ denodo Knowledge Base and Best Practices https://community.denodo.com/kb/ denodo Tutorials https://community.denodo.com/tutorials/ denodo Express 7.0 Download https://community.denodo.com/express/download Denodo Virtual Data Port (VDP) https://community.denodo.com/kb/download/pdf/VDP%20Naming%20Conventions?category=Operation JDBC / ODBC drivers for Denodo https://community.denodo.com/drivers/ Denodo Governance Bridge – User Manual https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Governance%20Bridge%20-%20User%20Manual Virtual DataPort VQL Guide https://community.denodo.com/docs/html/browse/7.0/vdp/vql/introduction/introduction Denodo Model Bridge – User Manual https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Model%20Bridge%20-%20User%20Manual Denodo Connects Manuals https://community.denodo.com/docs/html/browse/7.0/denodoconnects/index Denodo Infosphere Governance Bridge – User Manual https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Governance%20Bridge%20-%20User%20Manual

Continue reading

SQL Server – how to know when a stored procedure ran last

This week I needed to know if a stored procedure was running when expected during our batch.  So, here is a quick couple of SQL to answer the question: When a Stored Procedure was run last This version of the SQL gives the date for the last time the Stored Procure was run: select distinct   top 1     s.last_execution_time from  sys.dm_exec_query_stats s cross apply sys.dm_exec_query_plan (s.plan_handle) p where  object_name(p.objectid, db_id(‘<<DATABASE_NAME>>’)) = ‘<<STORED_PROCEDURE_NAME>>’ Order by s.last_execution_time desc Get a list of when Stored Procedure has been run This version of the SQL provides a list of dates of when Stored Procure has

Continue reading

SQL server table Describe (DESC) equivalent

Microsoft SQL Server doesn’t seem have a describe command and usually, folks seem to want to build a stored procedure to get the describe behaviors.  However, this is not always practical based on your permissions. So, the simple SQL below will provide describe like information in a pinch.  You may want to dress it up a bit; but I usually just use it raw, as shown below by adding the table name. Describe T-SQL Equivalent Select *   From INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME = ‘<<TABLENAME>>’; Related References Microsoft SQL Server – Useful links SQL Server – Basic SQL Server Object Naming

Continue reading