SQL Server 2005 Service Pack 2 is Out
Microsoft has finally release service pack 2 for SQL Server 2005. Read a short commentary and get the links to download it now.
2007-02-21
8,833 reads
Administration
2007-02-20
1,544 reads
2007-02-15
1,155 reads
2007-02-13
2,755 reads
2007-02-12
1,274 reads
SQL 2005 Maintenance Wizard Part 1
The SQL Server 2005 Maintenance Plan Wizard offers many core tasks and options for database housekeeping. In addition, the wizard will roll all of your selected tasks into a reusable and customizable package. Read on to learn more.
2007-02-09
2,723 reads
2007-02-08
1,329 reads
The Dedicated Administrator Connection
New to SQL Server 2005 is the Dedicated Administrator Connection (DAC), which provides a way to ensure you can always connect to your server. No more getting locked out of a busy server as could occur in prior versions. Wayne Fillis brings us a short tutorial on this handy new feature.
2008-05-05 (first published: 2007-02-06)
7,671 reads
2007-02-05
1,121 reads
SQL Server 2005 Command Line Tool "SQLCMD" – Part I
This series will illustrate the various ways of using the SQL Server 2005 command line utility “SQLCMD”.
2007-01-31
2,990 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
A Strange Query
Comments posted to this topic are about the item A Strange Query
Primary and Secondary Filegroup
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
Import data from json file with special characters
I am using the following script to import data from a json file. This...
Question of the Day
A Strange Query
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers