Wednesday May 1, 4PM-5PM BST / 10AM-11AM CDT - In this webinar, you’ll learn how to implement a test data provisioning solution that accelerates your development cycles and meets the needs of data privacy regulations such as HIPAA, SOX and the GDPR.
2019-04-24
Wednesday May 8, 4PM-5PM BST / 10AM-11AM CDT - Discover how transitioning from shared database development to individual development environments is easier than ever thanks to database virtualisation and source control technology.
2019-04-17
Wednesday May 1, 4PM-5PM BST / 10AM-11AM CDT - In this webinar, you’ll learn how to implement a test data provisioning solution that accelerates your development cycles and meets the needs of data privacy regulations such as HIPAA, SOX and the GDPR.
2019-04-17
Wednesday May 8, 4PM-5PM BST / 10AM-11AM CDT - Discover how transitioning from shared database development to individual development environments is easier than ever thanks to database virtualisation and source control technology.
2019-04-12
Wednesday May 1, 4PM-5PM BST / 10AM-11AM CDT - In this webinar, you’ll learn how to implement a test data provisioning solution that accelerates your development cycles and meets the needs of data privacy regulations such as HIPAA, SOX and the GDPR.
2019-04-12
Wednesday April 17, 4PM-5PM BST / 10AM-11AM CDT - The many benefits of having globally, or even locally distributed teams do not come without a trade-off. So how can you ensure that everyone works efficiently and effectively in distributed teams?
2019-04-09
Cathrine Wilhelmsen is presenting a brand new session called Pipelines and Packages: Introduction to Azure Data Factory. If Azure Data Factory is not really your thing, don’t worry! You can choose from 23 other topics, including SQL Server, Power BI, AI, Containers, and even Professional Development.
2019-04-05
Wednesday April 10, 4PM-5PM BST / 10AM-11AM CDT - Discover how you can improve your database development and deployment processes. You'll see a demo of Redgate tools and how...
2019-04-04
Wednesday April 17, 4PM-5PM BST / 10AM-11AM CDT - The many benefits of having globally, or even locally distributed teams do not come without a trade-off. So how can...
2019-04-04
The SQL in the City Summits are back for 2019, and we’ve got more scheduled than every before. You can see the complete list on our event page, and I’m lucky to be invited to all of them. Here’s the schedule.
2019-03-30
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...
A while into install I get a Microsoft OLE DB Driver for SQL Server....
Comments posted to this topic are about the item More Funny SELECTs
Comments posted to this topic are about the item Reducing the Cycle Time
What does this code return?
SELECT
( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2011'
AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2012'
AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2013'
AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;
GO See possible answers