SQL Server 7.0 Log Shipping Frequently Asked Questions
This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0.
This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0.
Ever needed to find the first occurrance of some data. This article looks at T-SQL querying for data in natural order.
Microsoft Corp. today announced that veterans taking tests in the Microsoft® Certified Professional (MCP) program can now use their Department of Veterans Affairs (VA) education benefits to cover examination fees (May 23, 2001).
If you’re running database-intensive code from Visual Basic or ASP, stored procedures can give you a great speed boost. With ADO 2.1, one of the components that makes up MDAC, this technique is easier to implement than ever.
This article shows you how to create multiple converging paths in workflow, and covers the use of a simulated OR constraint, not available directly from within the designer.
Two weeks ago Andy challenged the readers of SQLServerCentral.com to figure out a small puzzle. Come see the results for yourself and find out who won some cash!
An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge
an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.
Learn how to boost the performance of SQL Server by making proper use of filegroups.
With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By adding Internet Explorer 5.0 to the mix and using XSL to convert the XML to HTML, you can lighten the load on your database server. Going still one step further, by using Vector Markup Language you can even create drawings on the fly using the data from your SQL queries.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
I'm trying to restore my database into Azure SQL Managed instance from blob storage...
Last night I spent 45 minutes composing a complicated question here. When I finished...
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers