Have you started looking at what issues you might have migrating your existing applications to SQL Server 2005? If not then maybe as a first step, you should consider looking into what the SQL Server 2005 Upgrade Advisor can do for you. This article will discuss what the Upgrade Advisor is and how to use it.
2006-04-14
2,172 reads
You have many SQL Servers to administer and you just want to know when the last backup was taken for each database on each instance. This stored procedure will help.
2006-04-13
4,271 reads
What is the most efficient way of generating a range of values? SQL Server guru David Poole takes a look at a few different methods, both procedural and set based, and gives you some performance results.
2006-04-12
10,510 reads
Learn about SQL Server security techniques including the principle of least privilege, controlling metadata visibility, separation of users and schemas, and more.
2006-04-12
2,475 reads
2006-04-11
2,617 reads
2006-04-11
2,980 reads
Data warehousing is a foreign concept to many DBAs since it is not used very widely in SQL Server. However it can be a very useful tool for your business and new author Vincent Rainardi brings us the first in a series of warehousing articles, this one looking at an operational data store.
2006-04-11
11,341 reads
A new book from a former SQL Server team member looking at 2005. Read the sample chapter.
2006-04-10
4,667 reads
It's been 5 years that this community has been live and Steve Jones takes a short look back at the community as well as announcing a few prizes.
2006-04-10
2,981 reads
Miguel De Icaza has been a major mover of Mono, the open-source framework for .NET since the get-go. These days he shepherds Mono along from within Novell Inc. At Novell's BrainShare conference, he discussed the latest doings with writer Paul Ferrill.
2006-04-07
1,567 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt. Dasar, 1, 9...
Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18, Sunter Agung, Kec. Tj....
Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5, Ancol, Kec. Pademangan, Jkt...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers