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
33 reads
SQL Guatemala
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
43 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
11 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,076 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-03
15 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
276 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
6 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)
1,287 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-07-15
5 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)
1,120 reads
Blogs
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Forums
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
The Mythical Bus Accident
Comments posted to this topic are about the item The Mythical Bus Accident
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers