At Last! No need to convert SQL Scripts from one dialect to another. Although SQL is a simple language, it can be tedious, inaccurate and frustrating when developing equivalent SQL scripts for multiple database servers. This product handles the conversion for you. (Not Reviewed)
Hopefully you've heard by now that we're publishing a book consisting of our best content from 2002. Sign up for the book is going well, but we could still use a few more. This update answers some of the questions we've received so far.
Dinesh is back with another article on user defined functions, giving some more great examples. If you haven't read the first one, definitely go back and read it first.
Need more templates for Proc Blaster? LockwoodTech Software has partnered with Harjai Software Consultants to develop templates for Proc-Blaster, a development tool for ASP Code Generation.
So how many servers do you have in your environment? In this review of AppDetective by Brian Knight, he shows you how AppDetective helped him find SQL Servers he didn't even know about in his environment.
Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. (Not Reviewed)
New author! Dale discusses the differences between network computing and client server. Do you know where SQL fits into that? It's good reading, covers the topic at a high level.
Andy takes us through a recent troubleshooting session that includes a call to PSS. Ever run agent from the command line? Have a good idea of what justifies a call to PSS? Read this to learn more.
We asked Chris to put together some information on how he uses VSS, a subject that comes up a lot as we have articles and discussions that involve change management. Change management isn't easy, you definitely need a pattern to work from. This two part article gives you a pattern you can start with and customize to your needs.
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
The post Lukáš Karlovský: I got the green light from management and built Fabric...
Comments posted to this topic are about the item The Pervasive Nature of Open...
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding...
What is wrong (if anything) with this code?
SELECT *
FROM Sales.SalesOrderHeader AS soh
WHERE customerid IN (SELECT soh.CustomerID
FROM Sales.Customer AS C
WHERE soh.CurrencyRateID = 1
ORDER BY c.ModifiedDate)
See possible answers