Webcasts this week – wc 20131118
I’ve been a bit lapse in posting what I am up to recently. For example, I completely missed blogging about...
2013-11-19
714 reads
Blog Posts
Windows Azure Views
It’s kind of fun to see Azure development artifacts on display. I’ve posted about them before, a couple of times....
2013-11-19
877 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 4
Previously, on REAL-SQL-Guy…
We were introduced to two SQL queries to obtain database login permissions, one for SQL Server 2000, one...
2013-11-18
1,053 reads
Connection options in SSMS
When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know...
2013-11-18
1,669 reads
Fill Factor, Why Do You Taunt Me? Part 2
So Friday we were discussing the idea of an idea. I think... or an idea of an idea's idea. What...
2013-11-18
1,004 reads
For the Aspiring DBA
Getting started as a data professional is an incredibly daunting task. If you’re not concerned that you’re going to mess...
2013-11-18 (first published: 2013-11-11)
1,489 reads
I’m speaking at SQL Server Saturday #233 – Washington DC!
It’s that time of the year again when SQL Saturday makes its way back to the Washington DC Area. Here...
2013-11-18
591 reads
Last Weeks Top “Reading” Links #58
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-11-18
923 reads
MDX+SSRS #33 – Retrieve manager’s key and fully-qualified member name
A co-worker recently worked on a SSRS report and wanted to use a specific manager’s team for testing. The Manager...
2013-11-18 (first published: 2013-11-08)
2,344 reads
Power Pivot Synonyms
A little gem was included with the latest Office 365 update. After downloading and installing this update you will now find...
2013-11-18
938 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