Book Review: Success Is A Choice
I just finished reading Success Is A Choice: Ten Steps to Overachieving in Business and Life. Written by Rick Pitino,...
2009-05-28
2,155 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
Give Us TRIM()!
If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL...
2009-05-28
1,933 reads
Sometimes, code comments are informative and helpful
... and other times, they are stop-you-in-your-tracks funny. Here's an example of the latter:
http://msmvps.com/blogs/brianmadsen/archive/2009/04/21/funniest-code-comment-ever.aspx
2009-05-19
698 reads
The Windows 7 RC0 Experience
Over the past 2 days, I’ve gone full bore into Windows 7. I’ve installed RC0 on 2 of my laptops,...
2009-05-12
652 reads
Four new SSIS Videos on JumpstartTV.com
I've got four new SSIS videos published on JumpstartTV.com:
Expression Language Basics
Secure FTP File Transfer in SSIS
SSIS Lookup Transformation Basics
SSIS...
2009-04-20
2,201 reads
SQL Saturday Pensacola - Schedule published
The event schedule for SQL Saturday Pensacola has been published. This event will be held on Saturday, June 6 at...
2009-04-16
790 reads
Using the Script Component With Multiple Outputs
This article demonstrates the use of the SSIS Script Component to create multiple outputs from unconventional data files.
2009-04-15
10,868 reads
Never Delete Data
Should you ever delete data? In a production environment, do the benefits of deleting old data outweigh the possible risks?
Data...
2009-04-07
1,667 reads
SQL Saturday Jacksonville call for speakers
If you’re available and are (or can be) in the Jacksonville FL area the first weekend of next month, check...
2009-04-02
751 reads
Gone Dark
This afternoon was quite interesting around the office. A strong thunderstorm moved through the area, a common occurrence in Texas...
2009-03-25
1,398 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers