Partitionswitching over filegroups!Normally there is a concept of partitioning which uses the RIGHT method of partitioning. If there is the need to move partitions from one filegroup to anothe...
Auto document your work with SQL-Server!Problem: Have you ever wrote tens or hundreds of stored procedures where you use a lot of functions, Tables, other Databases and stuff like this? Probably th...
Parsing a Logfile date in SSIS with the help of C#recently I had a problem parsing the following date with SSIS: “Fri 01Jul16 00:02:59” as you would write it with python coding would be easy as pie:
Check if oozie is running properly with an example!Hi guys, If you have oozie installed or it was installed on a instance where you are working with it is always nice to make sure that everything is properly ...
Tokenize your SQL!If you ever went from SSIS to TSQL you might miss the cool tokenize function which gives you the stringpart that you are interessted in when you splitted a s...
Use Formatmessage to make it simple!When you know several programming languages like python for example you know about the power of formatting a string with relative ease with the help of the s...