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
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
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
650 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
789 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,711 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,650 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
750 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
Building Reports, 2.0 Style
I’m getting my first taste of the new SQL Report Builder 2.0, and so far I’m enjoying the upgrade. Report Builder 2.0 is a standalone product, shipped as separate download from the SQL Server and Visual Studio suites. It allows users to develop and run reports locally, in addition to permitting the publication of these reports to SQL Server Reporting Services.
2009-03-10
5,694 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
Count of Total Appointments within 30 days of each Appointment Date
Good Afternoon. I have a Table where each Record: 1) Represents an Appointment. 2)...
Reporting Services in Managed Instance
Hi , one of my on-premises servers one server is having databases and one...
EXTENDED EVENTS Track What's Logging In
Simple one looking for a script that can track what's logging in from where...