Journaling
Most of the work I’ve done for the past couple years doesn’t require taking much in the way of notes....
2018-12-28 (first published: 2018-12-04)
2,678 reads
Most of the work I’ve done for the past couple years doesn’t require taking much in the way of notes....
2018-12-28 (first published: 2018-12-04)
2,678 reads
Just received an email from Meetup with some news on enhancements and one of them was interesting to me – the...
2018-12-26
238 reads
Yesterday I posted about journaling with my goal being to track the time I spend on SQLOrlando (I’ll exclude time...
2018-12-24 (first published: 2018-12-05)
1,624 reads
Orlando Code Camp is March 30. 2019 in Lake Mary (same location as SQLSaturday Orlando) and we’re hoping to have...
2018-12-22
245 reads
We use Meetup for SQLOrlando. We have enough members that we have to pay for the service and it works...
2018-12-18
238 reads
Part of having 501c(3) status is figuring out where and how it might make a difference. Applying for non profit...
2018-12-11
233 reads
Part of the decision of setting up a non profit is committing to a bit more than minimal effort when...
2018-12-07 (first published: 2018-11-26)
1,717 reads
I’ve always been in favor of trying to use the PASS tools and web site as much as possible, but...
2018-12-07
746 reads
Notes:
19 attendees out of 44 registeredSQLGrease sponsoredSolid hour of networking before the meeting started, managed to get everyone talking to...
2018-12-06
284 reads
On Monday I wrote about journaling and while any pen will do, I think having a pen dedicated (as it...
2018-12-06
242 reads
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
Hi everyone, I have been asked to investigate storing Excel files in Sql Server...
My agency has been using the combo of on-premises SQL Server for the back...
Development Environment I am learning how to use pyodbc and accessing database in SQL...
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, 4137); -- B SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); -- C SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);See possible answers