Database Health
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
Extending SSIS Part 2 - SSIS Programmatically / Dynamically Building Packages
We bring you part 2 of a series on SSIS programming from Ira Whiteside and Actuality Business Intelligence. This article shows you how to dynamically build a package using code.
Database Encryption in SQL Server 2008 Enterprise Edition
This white paper compares TDE with these other encryption methods for application developers and database administrators. While this is not a technical, in-depth review of TDE, technical implementations are explored and a familiarity with concepts such as virtual log files and the buffer pool are assumed.
Parent-child dimensions in SQL Server 2005
Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using Analysis Services MDX.
Project Management Management
The state of project management for technology projects doesn't seem to be keeping up with technology itself. Steve Jones talks a little about what might be wrong.
Scheduling SSIS Packages - SQL School Video
In this new SQL School video, MVP Brian Knight shows how you can schedule your SSIS packages to execute at a specific time or on a recurring schedule.
XML Import Solution
This article explores how we can import XML into SQL Server using a powerful open source tool called XMLStarlet
Database Health
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
Database Health
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
Database Health
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Dancing Robot Goes Rogue
Comments posted to this topic are about the item Dancing Robot Goes Rogue
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers