Primary Keys – why accept the defaults.
G’day,
When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will...
2011-03-22
3,044 reads
Marty
- Interests: Playing Guitar, Music Theory
- Website: http://martincatherall.com/
Internals and Performance class in Dallas
At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...
2011-01-28
2,054 reads
Check that what you expected is actually what you got - DB's and SQLCMD
I feel that it is wise move for a script to actually check itself that the database connection that is...
2011-01-20
1,930 reads
Blogs
Daily Coping 29 Sep 2022
By Steve Jones
Today’s coping tip is to avoid saying “I should” and make time to do...
How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation...
Daily Coping 28 Sep 2022
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
Forums
PASS Data Community Summit
Who's going to PASS Data Community Summit this year? It's been quite a while...
SAP S/4HANA and Microsoft Azure SQL integration and ETL DELTA Process
By Surendra Kumar Reddy Koduru
In this Article I’m going to demonstrate the heterogenous systems integration and building the...
Get addresses that match list of customers
Let's say i have a table with columns: cus_no, address, city, state, zip. How...
Ask SSC