Create video presentations
I recorded my first video presentation and demo using the screen recording and video editing software called Camtasia Studio for Windows.
It’s...
2013-11-19
583 reads
Blog Posts
Microsoft SQL Server 2012 SP1 Cumulative Update 7
Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 7, which is Build 11.0.3393.0. This CU has 47...
2013-11-19
2,391 reads
My favourite online references
There is a wealth of information about SQL Server online. Absolutely hundreds of blogs, white papers, editorials, the list goes...
2013-11-19
428 reads
SQL Server 2008 Service Pack 3 Cumulative Update 14
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 14, which is build 10.00.5848. This Cumulative Update has...
2013-11-19
1,189 reads
SQL Server NorthEast – New Usergroup!!
SQLBits in Nottingham was where it all began. A short conversation on whether there were any plans for a SQL...
2013-11-19
830 reads
SYS.PARTITIONS: Better Than X-Ray Vision
Originally posted 2011-09-09 21:27:00. Republished by Blog Post Promoter
Over the past few months, I’ve been doing a lot of work...
2013-11-19 (first published: 2013-11-09)
2,005 reads
The week that was: PASS #SQLRally EMEA 2013
I feel really bad that I’ve not been able to blog recently. My draft area is littered with half written...
2013-11-19
732 reads
T-SQL Tuesday #48 Roundup
A big thanks to everyone who participated in this month’s T-SQL Tuesday (link) blog party. This month’s topic was to give your thoughts on Cloud. Lots of interesting reads...
2013-11-19
19 reads
T-SQL Tuesday #48 Roundup
A big thanks to everyone who participated in this month’s T-SQL Tuesday (link) blog party. This month’s topic was to give your thoughts on Cloud. Lots of interesting reads...
2013-11-19
8 reads
T-SQL Tuesday #48 Roundup
A big thanks to everyone who participated in this month’s T-SQL Tuesday (link) blog party. This month’s topic was to...
2013-11-19
807 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
BCA KCU MOJOKERTO Hub 0822 2531 3145
WA CS 082225313145 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
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