Flying high on the Big Data hot-air
Today Phil Factor talks about Big Data, and all the hype that's in the news.
Baselining with SQL Server Dynamic Management Views
When you're monitoring SQL Server, it's better to capture a baseline for those aspects that you're checking, such as workload, Physical I/O or performance. Once you know what is normal, then performance tuning and resource provisioning can be done in a timely manner before any problems becomes apparent. We can prevent problems by being able to predict them. Louis shows how to get started.
SQL Saturday #236 St Louis, MO
SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there.
How to understand NoSQL Databases
Today we have a guest editorial from Phil Factor that looks at NoSQL databases.
Some Relevant PowerShell Books
Phil Factor leafs through a few of his PowerShell books in his library, and considers which are his favorites
SQLServerCentral Webinar #24: Prepare for When Disaster Strikes
Steve Jones presents some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.
Using Lookup Function to Bridge Datasets in Report Builder
The report function, lookup, can be used to link two independent datesets.
VMware High Availability in SQL Server
With the massive number of servers running SQL Server within virtual machines (VMs), it's critically important for DBAs to understand the high availability options available when SQL Server is running within a VM.
Configuring Database Mirroring
This article contains a set of instructions for configuring SQL Server mirroring, including pre-requisites. It also includes notes on how to resolve a few issues that I have encountered.
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