Checking Azure SQL DB service tier via T-SQL
If you have to manage or work with an Azure SQL database and want to know what service tier the database is currently operating, but you don't have access...
2020-07-20
136 reads
Eduardo Pivaral
Administration Basics: Point in time recovery
Nowadays, data is a precious asset for companies today. If you are a database administrator (by decision or by mistake) or simply you are the "IT guy," you have...
2020-04-08 (first published: 2020-03-30)
380 reads
Introduction to StudyYourServer
I made a video (in Spanish) on how to use and which features offer my open-source project StudyYourServer
You are free to collaborate, fix it and add new functionalities!
The...
2020-02-04
18 reads
New Youtube Channel
Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...
2020-01-31
25 reads
T-SQL Basics: using OUTPUT
You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...
2020-01-09 (first published: 2020-01-03)
1,031 reads
Xmas tree in T-SQL
This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...
2019-12-27
37 reads
Refreshing dependent views after a DDL change
When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...
2019-08-02 (first published: 2019-07-15)
605 reads
SQL Engine basics: Caching data
SQL Server engine does an excellent job to optimize query performance and it has different methods to achieve this goal, one of these methods is the data caching.Data caching...
2019-07-16 (first published: 2019-07-05)
946 reads
Embed Azure Data Studio Notebooks in your website
Notebooks are a functionality available in Azure Data Studio, that allows you to create and share documents that may contain text, code, images, and query results. These documents are...
2019-05-07
160 reads
Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS
Using Azure Feature Pack for Integration Services to access Blob storage from Azure into SSIS packages
2019-04-23 (first published: 2019-03-26)
1,332 reads
Blogs
VMworld 2020 SQL Server session preview
By kleegeek
Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...
A new malware attack on SQL Server
Tencent Security has released a report (written in Chinese) describing a new malware attack by...
Azure Synapse Analytics overlooked features
By James-Serra
There are some options in Azure Synapse Analytics that are not obvious that I...
Forums
SQL Agent error history
Is there a way to capture 2 things, when did the job failed and...
Import csv file into existing table where 1st row has sep=,
Hi, I have a csv file that has the value "sep=," in the first...
Inserts not propagated in transactional replication
Hello, I have a transactional replication configured which subscription fails to sync to often...
Ask SSC