Using the File System Task - SQL School Video
In this video, MVP Brian Knight shows how you can use SSIS to work with files on your drive: renaming them, moving them, and more.
Building a SQL Server Data Dictionary with the Extended Properties and Third Party Tools
When the database is small, developers often use built-in SQL Server tools and scripts to create the data model. However when the data model grows into an enterprise level data model with all of the associated complexities, the management and maintenance grow as well. So what options are available to manage and build the data model?
How Productive Are You?
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
How Productive Are You?
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
How Productive Are You?
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
Compare Dates in an iterative manner for a particular set of records
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
Fix the Little Things
There are any number of small, annoying or tedious things in SQL Server and Steve Jones makes a case for getting them fixed.
Invoking Stored Procedures through a One Line Native .NET Method Call
Calling stored procedures from your application should be easy. Mark Frishman of ActiveDB talks about what he's done to help you build applications quicker.
Restore Transaction Logs for Point in Time Recovery
This article shows how a database can be restored to achieve point in time recovery
Twitter Your Issues
Twitter is one of those interesting Web 2.0 ideas that is hard to analyze. Is it valuable? Steve Jones might have an idea for how it could be used by DBAs.
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
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...
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