Window Function Basics - PARTITION BY
This article looks at the basics of the OVER() clause and how the PARTITION section works.
2023-12-08
7,285 reads
This article looks at the basics of the OVER() clause and how the PARTITION section works.
2023-12-08
7,285 reads
This is a short look at a technique that I discovered recently in Management Studio (SSMS). The technique is to compare two graphical execution plans in the tool to understand what they are doing and how two different queries might affect a particular system, both with the image and with the properties' data behind the […]
2023-11-24 (first published: 2021-03-30)
9,805 reads
This article shows how you can randomize dates in T-SQL, but keep the month and year the same while the day varies.
2022-06-24
1,689 reads
One of the lesser used functions is COALESCE(), used to allow you to return one value from a list of those that are potentially NULL. This short pieces gives a few examples where this is useful?
2021-08-16
4,225 reads
With the addition of Python to Machine Learning Services in SQL Server 2017, you can now execute your Python code inside of SQL Server.
2020-11-13 (first published: 2019-04-18)
36,701 reads
Learn how you can create a database in the serverless tier in Azure.
2020-06-29
9,652 reads
Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, […]
2019-10-24
7,862 reads
Transparent Data Encryption (TDE) has been around for a long time. It first appeared in SQL Server 2008, and after a rocky start with some bugs, it has become a regularly used feature for many organizations. While not perfect, it does provide some protection and auditors like to see physical protection features being used. It's […]
2019-08-29
14,616 reads
By Steve Jones
lookaback– n. the chock of meeting back up with someone and learning that your...
Regarding managing databases in the cloud, security should never be an afterthought. That’s where...
By Steve Jones
In a couple of weeks, I’ll be in New York City for the Redgate...
Comments posted to this topic are about the item Deleting a Database
Comments posted to this topic are about the item Data Analyst AI tool
Comments posted to this topic are about the item Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers