Sorting a String as a Number with T-SQL and SSIS
I was working on a Cube in Analysis Services for a client recently and needed to sort on a field...
2012-01-23
3,825 reads
Mike Davis SQL
How to hide Calculated Members in MDX SSAS
With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used....
2011-10-28
2,525 reads
Setting up SSIS Auditing Part 2
Auditing in SSIS can be a real headache. In this two part series blog I am going to try to...
2011-10-20
3,592 reads
Setting up SSIS Auditing Part 1
Auditing in SSIS can be a real headache. In this two part series blog I am going to try to...
2011-10-16
1,733 reads
Using Configuration Tables in SSIS 2008/2005
SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations...
2011-10-03
1,271 reads
Creating your first Data Mining Structure and Model
Data mining is a great way to help your company make decisions and predict future values. The Data Mining Algorithms...
2011-09-30
8,702 reads
SSIS For Each Column in a Data flow
Previously I wrote a blog on how to do a for each loop to look through each col in an...
2011-09-29
1,255 reads
Getting Previous Row in SSIS Data Flow
There is no native function built in to SSIS to get the previous row in the data flow. But with...
2011-09-29
1,768 reads
SSIS Merge with Duplicate Rows
The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The...
2011-09-28
1,329 reads
SSIS Child Errors in Parent Package
If you have a parent package that is looping through a set of files and calling child packages and want...
2011-09-27
2,737 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers