(Derek E Wilson) SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1 of float datatype. To create a random number execute Select Rand(), in my example it returned .0131039082850364.
Tag: sql server
General facts of SQL SERVER – part 5
General facts of SQL SERVER – Part 5 Classifying SQL SERVER opportunities SQL SERVER offers several options which can support an individual to increase the effectiveness of database formation. The SQL SERVER MANAGEMENT STUDIO (SSMS) is a system which aids in building plus retaining database’s different objects. The SQL SERVER BUSINESS INTELLIGENCE DEVELOPMENT STUDIO is an additional system which aids...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Displaying Power Pivot Calculated Measures in Alphabetical Order
(Melissa Coates) Sharing a quick tip I got the other day from Meagan Longoria…
SQL – Split delimited columns using XML Or UDF function
(Prashanth Jayaram) The requirement is to convert the delimited column into rows
How to resolve connection errors when loading data in SSAS Tabular project
(Paul Turley) This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar fashion. The multidimensional design experience is different but the mechanics of the SSAS engine are essentially the same.
Multiselect, Filtering And Functions In Power Query
(Chris Webb) If you’re a Power Query enthusiast you’re probably already comfortable with creating functions and passing values to them. However in some scenarios you don’t want to pass just a single value to a parameter, you want to pass multiple values – for example if you are filtering a table by
5 Things You Didn’t Know About SQL Agent
(Thomas LaRock) Microsoft SQL Server comes with a boatload of additional components. One component is the SQL Agent service. The purpose of the SQL Agent is to serve as a job scheduler. Many experienced DBAs use jobs running inside the SQL Agent to perform routine tasks such as backups, updating sta
Using Power BI to access on-premise data
(James Serra) The following blog describes how to use certain cloud-based Power BI for Office 365 products (Power View and Q&A) on a Power BI Site that will reference data on-premises. To do this you will use certain on-premise Power BI products (Power Pivot and Power Query) to gather the data.
Reports In SSISDB
(Chris Yates) I was approached with an in shop issue where a group could not view the execution reports in the SSISDB. The reason for this was due to the security standards in place at the shop; the user could not be allowed to have the SSIS_Admin role.
SQL Server Index Column Order
(Derik Hammer) At times I am in a position to advise development teams on their practices. What I have learned from this experience is that there is always a demand for me to reduce what I tell them to developer terms. Before the developers reading this go grab their torches and pitch forks, I am no