For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He then explains how to run it and what each line does.
Steve Jones comments on a few pieces of interesting SQL Server news this week, including Service Pack 3.
How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.
Implementing a dialog between two services residing in a distributed environment requires the presence of an authentication mechanism. Windows-based Kerberos protocol limits the scope of systems participating in a Service Broker dialog to those residing in the same or trusted Active Directory domains. This article provides an overview of how to eliminate this limitation by employing certificates.
Microsoft updates SQL Server on a pretty regular basis. Its newest version, SQL Server 2008, includes some new features not found in older versions. Here's a list of some of them
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about.
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about.
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Comments posted to this topic are about the item When the Token Meter is...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers