SQL In The City: Austin
So, No SQL Saturday in Austin This Year.
I know a lot of folks were disappointed that we (POSSE) weren’t able to pull together in...
2012-09-25
1,039 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
Demystifying SQL Server Differential Database Backups
Odd Man Out
SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.
Let’s...
2012-09-10 (first published: 2012-09-06)
2,779 reads
Free Tools for Testing SQL Sever
You Need To Test Your SQL Server!
Its like screaming “TEST THE BREAKS ON YOUR CAR!” If you don’t have the...
2012-08-16
2,242 reads
Speaking at PASS Summit 2012
It’s Not A Repeat
Speaking at the PASS Summit last year was one of the highlights of my career. I had...
2012-08-14
736 reads
SQL Rally 2012 Recap
Much Learning Was Had By All
SQL Rally 2012 had a diverse group of speakers and something for all levels of...
2012-05-14
844 reads
Speaking In April #SQLSat111 and #SQLSat107
All Quite on the Western Front
It is going to get noisy soon though! I”m speaking at SQLSaturday #111 in Atlanta...
2012-04-10
958 reads
Solid State Disks and SQL Server
An interesting result from a recent test of SSDs in SQL Server by Wes Brown. A surprising discovery is important for anyone thinking about using SSDs to know.
2012-03-09 (first published: 2010-04-08)
36,175 reads
2011 What A Great Year
What A Diffrince A Year Makes
In January I posted up my new years list basically, stuff I wanted to learn in...
2011-12-22
1,025 reads
SQLSaturday 97 Speaker Recap
Great Content + Great Speakers = Awesome Event
All the evaluations have been tallied, its official SQLSaturday #97 was a hit! As a...
2011-11-22
793 reads
SQL Server 2012 RC0 Is Here
SQL Server 2012 Release Candidate 0, Time To Get Serious
With the release of RC0 Microsoft has signaled that the release...
2011-11-21
1,524 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
identify consecutive records greater than 1
Hello I need help identifying all records that have consecutive hours (time in order)...
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...
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 OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers