Creating logins and users in Azure Database
Azure Database is the PaaS solution for SQL Server databases, on a previous post we have discussed how to create one.On this post, I want to show you how...
2019-04-11
18 reads
SQL Guatemala
Quick tip: Zoom in Azure Data Studio
If you finally have given a try to Azure Data Studio, and if you use it on a regular basis, maybe you want to customize it to suit your...
2019-03-13
24 reads
Quick tip: Zoom in Azure Data Studio
If you finally have given a try to Azure Data Studio, and if you use it on a regular basis,...
2019-03-13
2,455 reads
SQL Saturday 828 - T-SQL Basics: Coding for performance
A great experience!
Thanks to all the atendess to my session about T-SQL, for being my first time as a speaker for a SQL Saturday it was good!As I promised,...
2019-02-17
14 reads
SQL Saturday 828 - T-SQL Basics: Coding for performance
A great experience!Thanks to all the atendess to my session about T-SQL, for being my first time as a speaker...
2019-02-16
150 reads
Quick tip: Speeding up deletes from SSIS execution log
If you have SQL Server Integration Services installed on your server, and you left the default configurations a table named sysssislog is created on MSDB database, it contains logging entries...
2019-02-11
21 reads
Quick tip: Speeding up deletes from SSIS execution log
If you have SQL Server Integration Services installed on your server, and you left the default configurations a table named...
2019-02-26 (first published: 2019-02-11)
3,630 reads
I am speaking at SQLSaturday Guatemala 2019
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday #828 event in Guatemala city!This will be my first time as a speaker...
2019-02-05
14 reads
I am speaking at SQLSaturday Guatemala 2019
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday #828 event in Guatemala...
2019-02-05
161 reads
Understanding and working with NULL in SQL Server
Graphic representation of the difference between 0 and NULLImage taken from 9gag.com
According to database theory, a good RDBMS must implement a marker to indicate "Missing or inapplicable information".SQL Server...
2019-01-30
13 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers