Promised Links from SQL Saturday 119 Presentations
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,122 reads
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,122 reads
Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals...
2011-05-27
719 reads
Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem...
2011-05-26
753 reads
It should come as no surprise that the first topic I am covering this week is communication because the first...
2011-05-24
1,423 reads
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
687 reads
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
865 reads
I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to...
2011-04-20
716 reads
A week or so ago Aaron Nelson (Blog|Twitter) put out a call for help on Twitter looking for anyone that...
2011-01-20
13,490 reads
Last week Jonathan Kehayias (Blog|Twitter) used his blog to publicly call out Thomas LaRock (Blog|Twitter). I am not going to...
2011-01-11
654 reads
Do you have a favorite line from a holiday movie? Can you change it around slightly to make it SQL...
2010-12-20
761 reads
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Please help and thanks. Package:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has...
Hello SSC! I hope you all had a happy and safe holiday! Apologies if...
I have a table dbo.tblPresentationStatus (sql script attached - table script.txt) I have to...
What is returned from this query?
SELECT ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000 , ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001 , ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;See possible answers