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,957 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,360 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,096 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,296 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,263 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,201 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,299 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,359 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,623 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,338 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Dear Folks, Restore jobs in my SQL2022 Standard edition replication were failing on a...
hi, just to get this part out of the way, if my intended target...
Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers