Step By Step configring Windows 2012 R2 fail over cluster
One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage...
2017-03-01
3,017 reads
Ganapathi varma Chekuri
- Interests: SQL Lover
Step By Step configring Windows 2012 R2 fail over cluster
One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage to setup Always on availability. it can be configured...
2017-03-01
14 reads
Performance Dashboard Error: Could not find stored procedure
In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.
2017-02-27
2,009 reads
Webinar- SQL Server 2016 - Always Encrypted / Security
Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PM
SQL Server has had ways to...
2017-02-23
659 reads
Webinar- SQL Server 2016 - Always Encrypted / Security
Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PMSQL Server has had ways to encrypt data in the past - for...
2017-02-23
8 reads
AlwaysOn Availability Groups: Step by Step Setup
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail...
2017-02-20
78,215 reads
AlwaysOn Availability Groups: Step by Step Setup
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of...
2017-02-20
20 reads
vCenter Server fails to start, Purge and Shrink Vcenter SQL Database
One of my client vCenter Server fails to start as below shown error in event logs.Could not allocate space for...
2017-02-17
651 reads
vCenter Server fails to start, Purge and Shrink Vcenter SQL Database
In this article, you will learn how to troubleshoot If your vCenter Server fails to start and and manually purge the Vcenter database if required.
2017-02-16
8,470 reads
Upcoming list of webinars
SQL folks, upcoming list of webinars from SQL PASS.
Webinar title / Registration link / more infoSpeakerDate / Time"Why Your Data Type Choices Matter" https://attendee.gotowebinar.com/register/4226815545680860675Andy...
2017-02-15
253 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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