Copy Only Backups - SQL School Video
This video examines a new feature in SQL Server 2005: the copy only backup. MVP Steve Jones covers the implications of using this feature and how it can help you avoid broken backup chains.
2008-08-19
2,637 reads
Articles
2008-08-19 (first published: 2008-03-17)
45 reads
Data Lineage: The Next Generation
Bill Lewis describes the benefits of an application development environment in which all data dependencies begin and remain clearly, precisely and explicitly defined.
2008-08-19
1,941 reads
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
2008-08-19
79 reads
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
2008-08-19
47 reads
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
2008-08-19
70 reads
How to use OUTPUT clause result in SSIS 2005 / 2008 (RC0)
The OUTPUT clause was a new feature in SQL Server 2005 that can prove very handy in many situations. New author Gennadiy Chornenkyy brings us a look at how you can add this code to your SSIS packages and retrieve ID values back from the database.
2008-08-18
9,464 reads
Check your SQL Server using Windows PowerShell – Part 4
Earlier installments of this series illustrated how to ping the host, how to check all of the windows services related to SQL Server and how to check the hardware and operating system information. Part 4 of this series demonstrates how to get hard disk and network adapter information from the host machine.
2008-08-18
2,906 reads
Configure Filestream in SQL Server 2008
SQL Server 2008 offers a wide variety of features and FILESTREAM is one of the most anticipated. This article describes how to configure the FILESTREAM feature.
2008-08-18
3,256 reads
Epidemic Priority
As IT becomes more and more important to not only businesses but governments, what does that mean in the event of a disaster?
2008-08-18
63 reads
Blogs
SQL Server is Slow, part 3 of 4
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
AI Model Size, Parameters and Download
By Steve Jones
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...
SplashFlag - Building an IoT Swimming Notification Device from Scratch
By Bert Wagner
After setting up dozens of Internet of Things (IoT) smart home devices, I started...
Forums
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Vector Datatype
Comments posted to this topic are about the item Vector Datatype
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers