(Pascal Ganaye) The documentation of T-SQL Rand() says: Repetitive calls of RAND() with the same seed value return the same results.

(K. Brian Kelley) I was recently trying to determine what version of SQL Server was installed on a particular server. I found this tip to determine the version and tried to execute the code in the command. However, I do not understand what all the information means. Could someone explain it? Check

(Buck Woody) Developing in Windows Azure is at once not that much different from what you’re familiar with in on-premises systems, and different in significant ways. Because of these differences, developers often ask about the specific process to develop and deploy a Windows Azure application – more

(Brian Swan) This is a short post to shareexciting news: Jooma! 2.5, which shipped earlier this week, now has support for SQL Server! Of course, this release contains lots more goodies, but the addition of a database abstraction layer that supports multiple databases is a huge step (support for othe

(Ravi Shankar and Soumya Ranjan Das) SQL Server integration Services (SSIS) is the de-facto standard for data migration and ETL (Extract, Transform and Load) operations in the Microsoft BI suite of technologies.

(Pinal Dave) Recently one of my friend sent me email that he is having some problem with his very small database. We talked for few minutes and we agreed that to further investigation I will need access to the whole database.

(Paresh Prajapati) Earlier we have seen for the Delete file using Script Task and files deletion using File System Task in SSIS. We have directly wrote the logic to get the files and delete from specified folder in the script for the Script Task. For File System Task we have Used Foreach Loop Contai

(Rob Garrison) The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from having to specify string length came at a cost. Rob attempts to give a final answer as to

(Dattatrey Sindol) I am a BI developer and have been moved recently to a DBA role. Among the many tasks that I am responsible for, two major ones are: monitoring the SQL Server Agent Jobs running on a set of servers by creating a few standard SSRS reports and creating a Reference Manual/One Stop Gui

(Leslie Vail) Sometimes it comes up that we need to change the name of the SQL Server. Below is a quick and dirty checklist on how to accomplish this task. I feel certain there are several iterations of this all over the Internet – now there is one more .