What’s the CPU usage on the server? Use #Powershell!!
We have here an easy, handy-dandy way to find out how much CPU is in use on your server. Of...
2014-02-10
559 reads
Blog Posts
Winning From Within: a book review and a new attitude
See that guy there? He’s not winning. This picture was taken in July of 2013, and at that exact moment,...
2014-02-10
512 reads
World Excel Championship 2014
Hey Guys!
I have come across this amazing EXCEL Championship being organized by dezyre.com. They are offering an amazing cash prize!
from...
2014-02-10
325 reads
5 Things Series – Output Clause
In this series I’m going to detail the 5 T-SQL Commands that review in my 5 T-SQL Commands I’ve been...
2014-02-09
669 reads
Installing Metal Tech Red Eye Bumper on Toyota FJ Cruiser #4×4
Toyota may have plans to end production of the FJ Cruiser but the aftermarket continues to bring out new off...
2014-02-09
573 reads
Now Tech Leaders Are Really Sucking Up to Satya Nadella #microsoft
Satya Nadella’s appointment as the new CEO of Microsoft, coupled with the news that Bill Gates would step down as...
2014-02-09
375 reads
R is 15th of top programming languages in latest RedMonk ranking #r #bigdata #analytics
Analyst firm RedMonk periodically publishes rankings of the Top 20 programming languages, as measured by activity on StackOverflow and number...
2014-02-09
884 reads
Released: Management Pack for SQL Server Analysis Services 2008 and 2012
This week, we released Management Packs for SQL Server 2008 and 2012 Analysis Services. The corresponding downloads are available at:
System ...
2014-02-09
685 reads
SSIS Appetizer
Madeira’s excellent course on SQL Server Integration Services starts in March, but you can get a head start here! Take...
2014-02-09
268 reads
Basic Cloud Computing Patterns for Application Development
Over the past few years, the cloud evolution has answered all questions on the cloud being the right strategy. The...
2014-02-08
822 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers