SQL Server

SQLServerCentral Article

Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)

  • Article

Setting up High Availability in SQL server has some prerequisites. One of these is that the database servers must be members of the same Windows Server Failover Cluster. In this article I show how to succesfully set up WSFC and activate Cluster Aware Updating

5 (1)

You rated this post out of 5. Change rating

2024-06-28

2,052 reads

SQLServerCentral Article

SQL Window Functions Series: NTILE()

  • Article

Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.

4.67 (3)

You rated this post out of 5. Change rating

2024-02-03 (first published: )

4,250 reads

SQLServerCentral Article

Creating a Hyperscale Database in Azure Using the Azure Portal

  • Article

One of the most effective ways to fully utilize your data is to create an Azure Hyperscale database. The principles of Azure Hyperscale databases have been discussed in this article, including their cost-effectiveness, worldwide accessibility, automatic scaling, and reliable performance.

5 (1)

You rated this post out of 5. Change rating

2023-12-22

1,232 reads

SQLServerCentral Article

SQL Window Functions Series: LAG() and LEAD()

  • Article

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

5 (3)

You rated this post out of 5. Change rating

2023-12-11

6,144 reads

External Article

Profiler and Server Side Traces

  • Article

Profiler is a GUI based tool that runs a SQL Server trace to capture the metrics listed above as well additional data. This data can then be used to determine where your SQL Server performance issues are related to your TSQL code. Running a trace without using Profiler is known as a Server Side Trace. You can create and start the trace using TSQL commands instead of having to use the GUI.

2023-09-29

Blogs

T-SQL Tuesday #180: Good enough is perfect

By

How can you achieve good enough without compromising the process/product? In the world of...

How to Convert FileTime to DateTime

By

One of my customers recently wanted to rename each of the SQL audit files...

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Read the latest Blogs

Forums

Closest to ProcDate

By boehnc

Not sure I have this 2nd left join correct. I need to grab the...

How to use a date range to open up a report?

By NineIron

The report that I want to open has an "ExamDate". I am trying to...

SQL estate future planning

By goodtimecharlie

Morning all, I've inherited a small (on prem) SQL estate.  I'm a DBA, used...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers