If You Aren’t Measuring It, You Can’t Manage It
It sounds simple and logical doesn’t it. One could say it is common sense right? How many of us are...
2011-08-08
520 reads
Tim Radney
I Am Going to Be a Big Brother #sqlpass #firsttimers
Well at the PASS Summit at least. The Summit is trying to make sure that all of our first timers...
2011-08-05
1,116 reads
Register for 24 Hours of PASS NOW! #sqlpass
Do you need to perfect your SQL Server skills? Would you like to get 24 hours of free SQL Server...
2011-08-03
570 reads
I deem September 2011 – SQL Server Month
If you haven’t visited the SQL Saturday website you should take a look. There are SEVEN events planned during September around...
2011-08-02
548 reads
Spoke at #sqlsat81
I presented two sessions this weekend in Birmingham AL at SQL Saturday 81. I was in the first slot of...
2011-07-31
1,448 reads
Build a schedule for SQL Saturday
A new feature has been added to SQL Saturday. Now when you register for an event you can build your...
2011-07-29
1,426 reads
Thank you PASS Community
This has been a great week for me. I had a lot of new faces come out for the Columbus...
2011-07-29
1,513 reads
Preparing for #sqlsat81
SQL Saturday 81 is coming up this weekend in Birmingham AL. This will be my 5th SQL Saturday to speak...
2011-07-27
583 reads
What is the hardest part of planning a SQL Saturday?
For me so far it has been the speaker selection. Getting sponsors didn’t prove to be difficult, we have a...
2011-07-27
516 reads
Get count of folders using Power Shell
More on my recent PowerShell project. I recon I have taken on the challenge to handle this entire request using...
2011-07-25
551 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
SSIS package works in VS but failed in SSMS
Please help and thanks. Package:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has...
Need a list of stored procedures that execute multiple stored procedures
Hello SSC! I hope you all had a happy and safe holiday! Apologies if...
Question of the Day
The Funny SELECTs
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