This video covers the basics of creating a view in SQL Server. Views allow you to treat a query as a table and simplify your query writing. This view covers the Query Designer in Management Studio.
2008-07-31
5,926 reads
MVP Brian Knight covers the basics of creating stored procedures in SQL Server. Stored Procedures are ways of encapsulating a section of code inside of a function, and this video shows how you to convert your queries to stored procedures.
2008-07-29
11,347 reads
If you're like Brian Knight, you probably have dozens if not hundreds of DTS packages running around that you're terrified to touch. SQL Server 2005 has some interesting methods to upgrade your packages to SSIS with minimal effort. This article shows you a few ways that you can use to upgrade and some of the drawbacks.
2008-05-23 (first published: 2005-12-27)
66,059 reads
There's no security role to prevent or allow users to creating DTS Packages. Find out how to lock down DTS on your system.
2008-02-15 (first published: 2001-04-21)
8,290 reads
Renaming a server can be a mystery in SQL Server. The symtoms that SQL Server displays after you rename a server makes it look like you made a bad mistake.
2008-02-15 (first published: 2001-04-11)
63,242 reads
In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.
2008-01-18 (first published: 2002-07-12)
155,099 reads
Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering.
2007-10-02 (first published: 2001-07-02)
68,274 reads
On February 24th, 2005, Microsoft announced the new editions and pricing of SQL Server 2005. There have been quite a few changes and MVP Brian Knight has put down a comparison as well as details about which features are included with each. Read about the 4 new additions and see which one might be right for your next project.
2007-10-02 (first published: 2005-02-28)
65,189 reads
Last time, we discussed how to create your first report in Microsoft SQL Server Reporting Services. The report we created was a status report on SQL Server Agent jobs. The report we created was from the template and was very crude looking because of that. In this short article, we are going to look at improving that report and answer a common newsgroup question I see. This week, we are going to set the rows of the report to alternate colors.
2007-10-02 (first published: 2004-07-06)
67,586 reads
Trying to get past the Microsoft SQL Server Reporting Services learning curve? Well never fret, this article is a first in a series of tutorials to walk you through creating a practical report for your company to monitor your SQL Server databases. In this sample report, we are going to create a job monitoring system. Specifically, we are going to connect to our SQL Server and report if the jobs succeeded or failed the last time they ran.
2007-10-02 (first published: 2004-06-28)
71,302 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers