MCITP 1 Down 3 To Go
Yesterday I posted a quick blurb about my certification plans this year. Well, ok not full blown plans , but you get the gist. I announced that I would...
2011-05-20
11 reads
MCITP 1 Down 3 To Go
Yesterday I posted a quick blurb about my certification plans this year. Well, ok not full blown plans , but you...
2011-05-20
714 reads
Managing Data Change
Often DBAs receive requests to manually manipulate production data. Ideally, all data changes should be performed through the appropriate application...
2011-05-20
1,882 reads
Busy is as Busy Does
I am, as they say, one busy little bee.
I just got back from SQLRally last week (here are my SQLRally...
2011-05-20
559 reads
Watch out, Visual Studio 2010 does not support BI
When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up...
2011-05-20
1,029 reads
SQL Lunch Returns: MVP Max Trinidad (Let’s Talk about SQL Powershell)
I know you have missed the crazy antics, but after taking a short hiatus from my community contributions, the SQL...
2011-05-20
1,129 reads
Re-blog – May 13-19
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-05-20
441 reads
Microsoft SQL Server 2008 R2 SP1
AdvertisementsMicrosoft SQL Server 2008 R2 SP1 CTP
SQL Server 2008 R2 SP1 10.50.2418.0 CTP is available now. You may download and test it.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=15dcfec2-abb8-409d-91ff-c7c8e18c8409
2011-05-20
1,059 reads
Quickly Find Your DDL Triggers with PowerShell
As a consultant I spend much of the first day or two at a client site discovering everything I can...
2011-05-20
1,322 reads
Replicating XML Columns
One caveat that’s worth mentioning is replicating the XML data type in
SQL Server using Merge Replication. Sometimes, when replicating...
2011-05-20
1,421 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