SSIS - Single Package Deployment from BIDs
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
2009-12-28
1,523 reads
Articles
TSQL Challenge 20 - finding repeating digits on Fibonacci sequence numbers
Can you generate repeating digits in a Fibonacci series?
2009-12-28
2,168 reads
Importing SharePoint ULS and IIS Logs into SQL
Importing data into SQL Server is one of the strengths of the platform. However it can require a bit of work for a DBA to make this an automated process. New author David Jansen brings us a technique for importing Sharepoint and IIS logs into SQL Server for later analysis.
2009-12-24
3,931 reads
2009-12-24
742 reads
Introduction to SQL Azure
Learn how to get started working with SQL Azure and migrating SQL Server databases to SQL Azure.
2009-12-24
3,433 reads
MySpace Using SSDs
Glenn Barry (blog, twitter) posted a note about MySpace using Fusion-IO PCi-E cards to replace hard drives in their systems....
2009-12-24
1,917 reads
Twas the Night Before Christmas - SQL Style
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
2009-12-24
1,592 reads
Twas the Night Before Christmas - SQL Style
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
2009-12-24
1,954 reads
Twas the Night Before Christmas - SQL Style
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
2009-12-24
1,770 reads
CLR Table-Valued Function Example with Full Streaming (STVF / TVF)
SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and easy method. Solomon Rutzky brings us an article that givse you an example you can extend to your environment.
2009-12-23
13,491 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers