SQL Server 2012 AlwaysOn Presentation Given at Vermont PASS SQL Server User Group Last Week
This past Wednesday evening, 11th Dec, I braved the snowy roads down from Montreal to Winooski (Burlington area) to join...
2013-12-16
1,333 reads
This past Wednesday evening, 11th Dec, I braved the snowy roads down from Montreal to Winooski (Burlington area) to join...
2013-12-16
1,333 reads
The other morning I was commenting during our regular meetings amongst fellow DBAs on where to read up on installation...
2013-12-11
5,023 reads
LinkedIn has matured over the past decade and I can
sincerely say it is well worth the time setting up your...
2013-10-09
1,254 reads
This will not be a typical post, just a dive right away into Data Access Language Code, which provides a...
2013-09-10
3,728 reads
Since I changed organisations in January this year, I asked one of my colleagues to export his SQL Server Management...
2013-08-01
1,800 reads
For those Database Administrators seeking to lock-down security related to a Service Account(s), there is an option starting with Windows...
2013-06-21
2,225 reads
Most Server Administrators, whether Database Administrators or not, are quite familiar with the Remote Desktop Connection (a.k.a. RDP) tool, which...
2013-02-25
2,564 reads
One of the great features available since SQL 2008 is Row and/or Page Compression. However, even for those of you on SQL...
2013-02-08
2,766 reads
Since the last guide was quite popular (over 4k distinct views for SQL Server 2008 R2), I've uploaded to SkyDrive...
2013-01-11
19,265 reads
I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for...
2012-12-26
1,494 reads
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
I want to add a condition in the joining columns part of the merge...
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
I'm trying to figure out a how to do average costing over time in...
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers