The New Leader - Database Weekly (Sept 29, 2008)
A new SQL Server system has claimed the top spots in the TPC-E benchmark, but Steve Jones doesn't think it's that impressive.
2008-09-26
535 reads
Articles
Making SSIS Connections Dynamic - SQL School Video
Integration Services is an ETL programming environment that gives you a tremendous number of options. In this video, MVP Brian Knight shows how you can change your connections dynamically.
2008-09-25
6,034 reads
Profiler - Logging Results to a Table
Profiler is a fantastic tool for SQL Server DBAs to enable them to examine how batches and code is submitted to the server. Expert SQL Server trainer, Andy Warren, brings us a new article that exaamines how you can log that data in another SQL Server table for later analysis.
2008-09-25
4,150 reads
Check your SQL Server using Windows PowerShell – Part 5
This fifth installment of the “Check your SQL Server using Windows PowerShell” series illustrates how to access SQL Server instance properties and SQL Server configuration details using Windows PowerShell.
2008-09-25
2,762 reads
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
2008-09-25
76 reads
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
2008-09-25
55 reads
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
2008-09-25
74 reads
The Baker's Dozen: 13 Tips for SQL Server 2008 and SSRS 2008
SQL Server 2008 gets new developer features, and SQL Server 2008 Reporting Services gets a facelift and new architecture that no longer requires Internet Information Services.
2008-09-25
3,509 reads
The FILESTREAM Data Type in SQL Server 2008
There is a new data type in SQL Server 2008 that might help you deal with all those music, image, and other media files in SQL Server. FILESTREAM allows you to store these files in the file system, but access them from within SQL Server. New author Deepa Gheewala brings us a look at setting a table for FILESTREAM.
2008-09-24
12,806 reads
Changing the default SQL Server backup folder
Is it possible to change the default directory for backups, so it does not need to be specified each time I run a backup?
2008-09-24
4,477 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers