Attaching and detaching databases isn't rocket science, but if you have a lot of databases to attach it's pretty boring. Andy has written some VB code that uses SQL-DMO to speed up the process. But DMO isn't the only way - can you write a TSQL script to do the same thing? Fame and fortune await!
The SQLParser object - mostly undocumented - gives you an easy way to convert a TSQL string into a colorized RTF string. Andy started with that and wrote some code to change it to HTML. Useful? Never know! Code and demo program included with the article.
The User_Defined_Functions.exe file contains the User-Defined Functions white paper. The User-Defined functions white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create your own Transact-SQL functions to extend the programmability of Transact-SQL.
Amir Netz is one of the true OLAP and SQL Server gurus at Microsoft. If you ever get the chance to see him speak, go. This is one of his articles examining OLAP services.
What skills do you need to be a DBA? Lots of different ones, but people often forget there are non-technical skills that matter. This article by David Poole examines some of the softer skills
that can help your career.
In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.
In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.
Robert Vallee has announced that he will release the source code to SQL Insider early to September 15th. On that date, members will be able to download the source code and make modifications to the program.
Give this test to your boss...only if he has a sense of humor!
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Comments posted to this topic are about the item Having a Little Fun at...
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers