SQL Server Management Studio is rich with features. So rich, in fact, that after almost 3 years I am still finding new tools in the application that afford me more control over my databases and the methods for supporting them. Recently I found myself needing to script out a database and its objects for reviewing a problem offline.
2008-06-09
3,758 reads
Steve Jones talks about IT Project Failure and how you should re-evaluate things are you move forward.
2008-06-09
43 reads
Steve Jones talks about IT Project Failure and how you should re-evaluate things are you move forward.
2008-06-09
50 reads
Learn how using the OUTPUT clause in SQL Server 2005 queries simplifies T-SQL code and returns results of rows changed by an INSERT, UPDATE or DELETE SQL command.
2008-06-09
4,349 reads
Having separate databases for each client? It's a common problem and Steve Jones wonders if this might be a feature coming in SQL Server at some point.
2008-06-07
46 reads
Having separate databases for each client? It's a common problem and Steve Jones wonders if this might be a feature coming in SQL Server at some point.
2008-06-07
41 reads
Having separate databases for each client? It's a common problem and Steve Jones wonders if this might be a feature coming in SQL Server at some point.
2008-06-07
50 reads
As much as we're SQL Server folks here, sometimes we do need to connect to other data stores. Hai shares some of his experiences doing so. Might come in handy someday.
2008-06-06 (first published: 2004-04-14)
46,230 reads
This paper introduces Service Broker, a new feature in Microsoft SQL Server 2005. With Service Broker, internal or external processes can send and receive guaranteed, asynchronous messaging by using extensions to Transact-SQL.
2008-06-06
2,967 reads
KPIs or Key Performance Indicators are one of the most important entities in driving business decisions. It can be defined as a (quantifiable) measurement used to define and measure an organization's progress in achieving business goals. KPIs for an organization are decided upon by giving careful thought to how each goal and the progress towards these goals should be measured.
2008-06-06
2,088 reads
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
SQL Server 2025 introduces native support for vector data types and external AI models....
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
hi everyone I am getting an error when I add a variable to a...
Comments posted to this topic are about the item How to Use SQL Server...
Comments posted to this topic are about the item Choosing an AI in Sept...
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers