sql prompt

Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database developers work, and goes on to describe some of the features he'd like to see in it

2010-04-09

4,030 reads

RE: Agile Development with Scrum

by richardd

Redgate

"The customer lists all the features they want in priority order."And how often can your customers tell you exactly what they want, let alone as a prioritized list?If you are lucky enough to get a feature list, and it doesn't change half-way through, everything will be top priority. If you make the decision for them, […]

2005-05-18

RE: UPDATE a table using results of a UNION query

by Prasad-Bhogadi

Redgate

You can create a view to hold the output of the two queries as CREATE VIEW MYUNIONDATE AS(SELECT Name, MaxOfDateQC FROM vw_vendor_current_mech UNION ALL SELECT Name, MaxOfDateQC FROM vw_vendor_current_elec)GOUPDATE TblVendors SET TblVendors.Vendor = 1 WHERE TblVendors.Name IN (SELECT [Name] FROM MYUNIONDATE)Thanks

2005-05-18

Disable use of SQL Enterprise Manager

by Robert-W-Alexander

Redgate

Topic

I want to remove the ability of some of my users to connect to a database using SQL Enterprise Manager. I would still like the users to have the ability to use Query Analyzer. What access rights do I need to remove from a login to achieve this?

2005-05-18

2 reads

CSV Rendering

by Prasad-Bhogadi

Redgate

Topic

I have a report which takes lot of time to render, rather the stored procedure returning the data to the report consumes good amount of time because of the number of records and conditions in the stored procedure, So what I need to implement is when the report is invoked I am displaying different rendering […]

2005-05-18

2 reads