SQL Rally Schedule
Thursday, May 12
BI
DBA
DEV
PD / WILD
CARD
8:30 - 9:30
SQL Server Parallel Data Warehouse - Under the Hood
Brian Mitchell
The Dirty Dozen: PowerShell Scripts for the...
2011-04-05
1,125 reads
SQL Validation Functions - 4 Cool UDF's to have handy
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-05
40,770 reads
Should a DBA be involved in the physical set up of a Database server? Part1
There is always some disconnect between the network admins and the DBA’s regarding hardware set up of a SQL Server....
2011-04-05
1,639 reads
Powershell Day 5
Day 5 Programming in Powershell Part 3 Now as you know all information, in this blog we will look for...
2011-04-05
347 reads
SQL Server Role Membership
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL Server provides a few methods for you to find...
2011-04-05
29 reads
SQL Server Role Membership
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL...
2011-04-05
811 reads
Epsilon Data Breach and Staying Safe
By now, you may have received an email from one of the larger businesses you've given your email address to...
2011-04-05
767 reads
T-SQL UPPER(): Change an all lowercase string to uppercase
The T-SQL UPPER() command allows you to change a lowercase string to an uppercase string.
For example, it will allow you to change the word...
2011-04-05
1,716 reads
SqlSaturday #71–Boston Recap: An Upscale Saturday
I had the pleasure of attending and presenting at SQLSaturday #71 – Boston on April 2nd. Adam Machanic (Blog|Twitter), Mike Walsh (Blog|Twitter), Tom LaRock (Blog|Twitter), Grant Fritchey (Blog|Twitter) and...
2011-04-04
11 reads
Meme Monday: 11 Words or Less
Thomas LaRock (Blog | Twitter) has started a community blog series call Meme Monday.
Here’s my entry:
Community is nice, but displaces work if...
2011-04-04
738 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
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
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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