Azure SQL Database Compatibility with SQL Server
A long time ago, in early days of the Azure SQL Database in 2015, I wrote this article in which I tried to compare the SQL Server and Azure...
2020-10-02 (first published: 2020-09-27)
1,836 reads
A long time ago, in early days of the Azure SQL Database in 2015, I wrote this article in which I tried to compare the SQL Server and Azure...
2020-10-02 (first published: 2020-09-27)
1,836 reads
I’ve spent my whole career working with databases which is over 20 years and counting. I work for a great company and I love what I do. The job...
2020-08-28 (first published: 2020-08-17)
191 reads
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
101 reads
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
12 reads
Connect() is a yearly, Microsoft-hosted developer event that is broadcast live from New York City to developers worldwide.
The Connect(); 2017...
2017-11-13
262 reads
External USB drives should be safely detached from Windows instead of just unplugging them from the computer. Most of us...
2017-11-01
372 reads
It’s official: the next version of SQL Server, planned to be released this year, will be called SQL Server 2017....
2017-04-19
3,363 reads
It’s quite easy to hit the PrintScreen key and capture the whole screen. But how do we quickly capture a...
2017-04-07 (first published: 2017-03-22)
2,382 reads
About two years ago I wrote my first blog post.
About a year ago I paused my blogging activity. That’s when...
2017-03-21
289 reads
Here’s a new feature that I like very much: Limiting exposure of sensitive data like user emails, phone numbers, addresses,...
2016-03-04 (first published: 2016-02-29)
2,066 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers