Upcoming Presentations
Just a quick note to let you know about a few upcoming presentations I’ll be doing. This week I’ll be...
2013-06-11
619 reads
sqlchicken
Internet Security Advice For The Family
Constant Vigilance!For today’s post I’m channeling my inner Brian Kelley (Blog | Twitter) and talking about security, in particular Internet security....
2013-05-28
988 reads
Business Objects on Linux and SQL Server
This is just a quick post to share a lesson learned while I was on an engagement where the client’s...
2013-05-23
953 reads
Speaking at PASS Summit 2013!
I’m happy to officially announce that I’ll be presenting at this year’s PASS Summit in Charlotte, NC! I’ll be presenting...
2013-05-22
558 reads
Magnify SQL Text with SSMS 2012
This is just a quick tip to help with folks who present SQL code at events such as SQL Saturday....
2013-05-16
817 reads
SQLSaturday #209 – Rochester
Welcome to the Roc!
Just a quick note that I’ll be presenting this weekend, Saturday May 11th, at SQLSaturday in Rochester,...
2013-05-08
786 reads
Necromancing the Chicken
First off, I’m sorry this space has been dead for so long. I’m sure I’ve dropped off many an RSS...
2013-04-16
859 reads
24 Hours of PASS Fall 2012
Do you like training? Do you like FREE training? Then make sure you check out the 24 Hours of PASS...
2012-09-20
1,279 reads
How To Prevent SELECT * The Evil Way
SELECT * FROM…when administrators see that from developer code, we generally tend to cringe. Why? In a nutshell, it’s terrible on...
2012-07-27
1,879 reads
Identify and Alert for Long-Running Agent Jobs
Being a DBA is like being a train conductor. One of the biggest responsibilities is making sure all jobs are...
2012-07-09
11,245 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