Data Farming
Another spy story involving data that's not true, and perhaps not plausible, but it makes Steve Jones think about data shadows.
2008-10-11
76 reads
Articles
Creating Functions for Stored Procedures
With the advent of so many new technologies in the Microsoft space, a DBA needs to learn more and more about many of them that aren't a part of SQL Server. Alex Grinberg brings us a technique he has used to create ADO functions for your stored procedures.
2008-10-10
13,674 reads
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.
2008-10-10
18,473 reads
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.
2008-10-10
2,702 reads
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.
2008-10-10
3,842 reads
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.
2008-10-09
5,506 reads
XML Import Solution
This article explores how we can import XML into SQL Server using a powerful open source tool called XMLStarlet
2008-10-09
10,699 reads
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.
2008-10-09
71 reads
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.
2008-10-09
94 reads
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.
2008-10-09
71 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers