T-SQL Tuesday #36 - SQL Community (Guest Post)
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2012-11-06
628 reads
Kendal Van Dyke
2012 PASS Elections Letter Of Recommendation From Ed Watson
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
1,023 reads
2012 PASS Elections Letter Of Recommendation From Jes Borland
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
625 reads
2012 PASS Elections Letter Of Recommendation From Stacia Misner
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
647 reads
2012 PASS Elections Letter Of Recommendation From Karen Lopez
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-05
1,052 reads
2012 PASS Board of Directors Elections - It's Time To Vote!
It's time once again to vote for the 3 candidates we feel will best represent the SQL Server community with...
2012-10-03
1,185 reads
PowerShell Split-Path Bug And A Workaround
Split-Path is a cmdlet built into Windows PowerShell that returns a specific part of a path, e.g. a parent directory...
2012-09-05
2,453 reads
PASS Update #1 - January 2012 Recap
When I ran for the PASS Board of Directors last year I committed to providing a monthly update on PASS...
2012-08-07
954 reads
PASS Update #2 - February 2012 Recap
During the January board meeting we were told that attendance at the 2011 Summit exceeded expectations and as a result...
2012-08-07
621 reads
Time Flies When You're Having Fun (Déjà Vu Edition)
Writing - be it a technical language like T-SQL, C#, PowerShell, etc. or blogging - is like exercise. When you do it...
2012-08-06
1,524 reads
Blogs
5 Free Data Analysis Books to Kickstart Your Career
Dreaming of a data analyst career but feeling a little lost? Already playing with...
PostgreSQL error in Fabric Pipelines – No pg_hba.conf Entry for Host
I came across a bit of a weird error when I was trying to...
How I Effortlessly Dockerize Python-Based AWS Lambda Functions
As a Software Engineer, i would like to learn how to dockerize my Python...
Forums
Is Perfect Software Attainable?
Comments posted to this topic are about the item Is Perfect Software Attainable?
Contained Availability Groups - Failover Questions.
Hi I am considering creating Contained Availability Groups in my production environment. Thinking I...
Question of the Day
Multi-Database Marked Transactions
I run a marked transaction across multiple databases with this code:
BEGIN TRAN onemorenewdbTran WITH MARK 'mark from 3 dbs' USE sandbox2 INSERT dbo.AddressTable (AddressID, AddressValue, AddressPostal) VALUES (12, '123 three St', '4444') GO USE sandbox3 INSERT dbo.Logger (logdate, logmsg) VALUES (GETDATE(), 'tran message') GO INSERT sandbox4.dbo.logger (uid) VALUES (700) COMMIT TRAN onemorenewdbTran GOHow many marks are inserted into msdb.dbo.logmarkhistory? See possible answers