Master Data Services (Second Edition) – Review
For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day...
2014-01-31
1,926 reads
Blog Posts
My Visual Studio crashed and I didn't know why!
Recently I had to develop a simple ETL task with the help of SSIS to transfer an Excel data file...
2014-01-31
1,320 reads
PowerShell – Memory Details GUI Tool
This Powershell Memory GUI tool is used to fetch memory information from a computer. In the screen that follows, enter...
2014-01-31 (first published: 2014-01-27)
2,667 reads
Powershell in a Month Day 14 – WMI
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-01-31
1,749 reads
Reblog: January 24 to January 30
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-01-31
1,393 reads
See Consolidated Data About SQLSaturday (Events, Sponsors, And Speakers)
Yesterday Kendal Van Dyke posted a file to Skydrive with consolidated information from all the events published so far. He...
2014-01-31
1,157 reads
SQL Prompt – new features in version 6.x
I’ve been using SQL Prompt for years. In September 2013, version 6 was released (quickly followed by 6.1 in late...
2014-01-31 (first published: 2014-01-27)
3,077 reads
2013 with You & SQL Server
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2014-01-30
1,129 reads
Database Project Versioning
SSDT 2010, 2012 with TFS integration brought about a couple of different options when you are looking to version your...
2014-01-30
2,076 reads
Final Day for Power BI Voting, Can I Have Your?
Today is the final day for the Power BI Contest voting and I could use your help to move on...
2014-01-30
1,331 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