Executing Stored Procedures and Functions From PHP in Windows
Discover how to call stored procedures and functions in MySQL from PHP using three database extensions: MySQL, MySQLi, and PDO.
Generating Database Objects Scripts in SQL Server 2005
SQL Server Management Studio provides a wizard to generate script out of a database. Learn how to automate the process to generate and store the database script.
Manager of One
Are you a manager of one? Steve Jones say show this might be a good thing to be. You might improve your chances of landing the next job by showing your employer that you can be more productive.
Manager of One
Are you a manager of one? Steve Jones say show this might be a good thing to be. You might improve your chances of landing the next job by showing your employer that you can be more productive.
Manager of One
Are you a manager of one? Steve Jones say show this might be a good thing to be. You might improve your chances of landing the next job by showing your employer that you can be more productive.
SQL Server MVP Deep Dives Early Access Edition Now Available
SQL Server MVP Deep Dives, a new book written by 53 SQL Server MVPs, is now available as an eBook,...
Investing In Your Career
Do you invest in your own career? Should you? Steve Jones asks the question in today's Friday poll.
Configure disaster recovery across SharePoint farms by using SQL Server log shipping
This article describes how to use Microsoft SQL Server 2005 or Microsoft SQL Server 2008 log shipping to create a disaster recovery farm in a geographically distributed data center for Microsoft Office SharePoint Server 2007 with Service Pack 2 (SP2). By using this configuration, you can provide a disaster recovery site that provides current search results when a failover occurs. The article assumes that you are familiar with the concepts and terms presented in Plan for availability (Office SharePoint Server).
Investing In Your Career
Do you invest in your own career? Should you? Steve Jones asks the question in today's Friday poll.
Investing In Your Career
Do you invest in your own career? Should you? Steve Jones asks the question in today's Friday poll.
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers