|
|
Browse by Tags
All Tags » sql server ( RSS)
-
|
When users migrate from SQL Server 2000 to SQL Server 2005, not all databases are set to Compatibility Level 90 which is required to make use of the newly available functions There are many methods to know the Compatibility Level of a database using queries...
|
-
|
Here it is first post in the year 2009, still I would like to visit the good old advice of securing your SQL Server environment. For any user in IT, Security must be a top priority in order to ensure their PC or environment is secured. You might have...
|
-
|
How many times you have faced the problems in installing SQL Server client tools? Have you ever tried to install latest version of SQL Server tools on previous version? Recently I have run into such a problem when installing SQL Server 2008 client tools...
|
-
|
set nocount on select space ( 7 - len ( replicate ( char ( 42 ), no )))+ replicate ( char ( 42 ), no * 2 - 1 ) from ( select top 5 row_number () over ( order by name ) as no from sysobjects ) as t union all select space ( 5 )+ replicate ( char ( 124 ...
|
-
|
Make information archival a component of your SharePoint content lifecycle management strategy Organizations are generating large volumes of mission-critical information on Microsoft SharePoint. As hundreds of gigabytes or even terabytes of unstructured...
|
-
|
In many case within the forums and newsgroups I still see many questions from the users asking about SSIS (SQL Serve Integration Services) and here few bits I'm covering on basics on this important service in SQL Server arena. SSIS is a key part of...
|
-
|
During the Microsoft Tech-Ed North America conference Windows Communication Foundation (WCF) is one of the interesting topics I would like to go about, it provides a unified framework for rapidly building service-oriented applications that makes it easy...
|
-
|
You may have seen the sp_replwriterovarbin - New SQL Server Injection-Based Attack Found vulerability about the new public reports of a vulnerability that could allow remote code execution on systems with supported editions of SQL Server 2000, 2005, 2005...
|
-
|
Another security vulnerability or rather call in the sense of security experts that " A zero day vulnerability has been reported in SQL Server "! Though its a not serious flaw or problematic loophole to worry but still its a security flaw in...
|
-
|
From the Are you ready for SP3 and SQL2005SP3_WorkStarted posts here, it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to test and apply on your SQL Server 2005 instances. The Official SQL Server News...
|
-
|
Replication and Database Mirroring are the ones which can provide high availability option without an extra cost what it implies on a Clustering setup. So in this scenario Database mirroring can be used in conjunction with replication to provide availability...
|
-
|
Here is another update on Books Online (BOL) for SQL Server 2005 - Download an updated version of the documentation and tutorials, to see what kind of updates are updated in the documentation once you downloaded & install see the " Additional...
|
-
|
Since the CTP of SQL Server 2008 there has been much of traffic going around talking LINQ is a replacement of TSQL etc. etc. As you may see that LINQ which is a .NET related language integrated query kind of project that is initiated to standardise data...
|
-
|
How do I view the script of the DDL triggers? The answer is not sp_helptext 'DDL trigger' Because DDL triggers are defined at database / server level and not at any table level So they are not stored in a system objects like sys.objects and the...
|
-
|
THANK YOU. PASS Summit 2008 was a rousing success and it's not over yet... Peruse the information below to see how you can keep your SQL Server education moving along. The 2008 PASS Community Summit drew 2,445 attendees and 1,143 pre-conference registrations...
|
More Posts Next page »
|
|