Advanced XML Processing
Continuing on with his series on XML, Jacob Sebastian looks at some more advanced XML techniques in SQL Server 2005.
2008-09-25 (first published: 2007-05-09)
29,498 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,027 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,135 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,791 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
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers