SQLSaturday Tools
Much has been said about SQL Saturday tools and how PASS is pulling back from development of those tools past...
2018-04-06 (first published: 2018-03-27)
2,634 reads
Jason Carter
Second Year Presenting at SQL Saturday Orlando
Coming up on my schedule is another appearance at SQL Saturday Orlando. Orlando is quite special to me as it...
2014-08-07
664 reads
SQL Downgrades Made Easy
I was reading Kendra Little’s ( b | t ) post on SQL Server Edition Changes and it reminded me of the work...
2014-08-15 (first published: 2014-08-06)
8,843 reads
Export XML Columns to Individual Files
I was reading SqlServerCentral.com Articles Requested forum and saw this request.
Looking for an article that takes data from an XML...
2014-08-14 (first published: 2014-08-04)
9,187 reads
Tampa Code Camp Revivial
If you were to look around Florida at the various cities technology based User Groups, and their accompanying local conferences you...
2014-07-21
740 reads
Powershell Goodies
If you haven’t seen some of the other blog post, or the Microsoft Powershell Blog, Microsoft recently release Script Browser for...
2014-04-25
1,662 reads
Come see me present SQL Saturday Atlanta
Have you seen the schedule for SQL Saturday #285 – Atlanta? Holy cow they have jam packed too many hard decisions...
2014-04-22
570 reads
Mr. Carter, Where Did You Go?
It has been nearly a month since your last blog post Mr. Carter, and frankly your last post was nothing...
2014-04-22
703 reads
SQL Saturday Madison – Recap
A few notes from our trip to Madison for SQL Saturday. We arrived two days early and acted like tourist...
2014-04-01
753 reads
Presenting Orlando Code Camp
I’ve been attending Orlando Code Camp for years now, and they always put on a great event. It was at...
2014-03-11
480 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
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
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