Powershell day 2
Day 2 Introduction to Windows Powershell. Windows Powershell is a very powerful shell script to interact with windows. Using windows...
2011-04-02
1,472 reads
SSMS Tips & Tricks – Scripting Multiple Objects
This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office,...
2011-04-02
1,366 reads
If you fire that trigger, make sure you have the correct ID
G’day,
I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the...
2011-04-02
576 reads
A SQL Server Hardware Nugget A Day – Day 1
Well, I apparently did not learn my lesson last year, when I did a month long series called “A DMV...
2011-04-02
429 reads
T-SQL LOWER(): Change an all uppercase string to lower case
The T-SQL LOWER() command allows you to change an uppercase string to a lowercase string.
For example, it will allow you to change the word...
2011-04-02
902 reads
SQLServerCentral.com Track at Orlando SQL Server Connections
This past week, about 1,200 developers, IT professionals, and DBAs spent three days attending DevConnections at the J.W. Marriott Resort...
2011-04-01
784 reads
SQL in the City: Free SQL Server Events in London and Los Angeles
Red Gate Software has announced two free, full-day SQL Server events, called “SQL in the City”. Both events will provide...
2011-04-01
773 reads
April Question: Which high availability option(s) do you employ for SQL Server instances, and why did you choose them?
As DBAs, we are responsible for the protection of our organization’s data, and we have many different options to protect...
2011-04-01
599 reads
A 22 Hour Layover
I joked about having a 22 hour layover in Denver yesterday and a few people were wondering what airline screwed...
2011-04-01
852 reads
Changing Directions
I See Dead Tech….
Knowing when a technology is dying is always a good skill to have. Like most of my...
2011-04-01
921 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