Stored Procedures Reconsidered
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
Stored Procedures Reconsidered
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
Stored Procedures Reconsidered
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005
James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.
Lazy Developers - Database Weekly (2008/07/28)
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
The More Things Change ...
Steve Jones talks about how IT hasn't changed very much over the years and how your career might not be that different in ten years.
Loading XML data into SQL Server 2008
This article provides a step by step guide on how to create and configure an SSIS package which can be used to import XML data
The July Car Update (2008)
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
The July Car Update (2008)
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
The July Car Update (2008)
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers