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,452 reads
SQL Guatemala
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
10 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
148 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
14 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,626 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
10 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
155 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
10 reads
Understanding and working with NULL in SQL Server
Graphic representation of the difference between 0 and NULL
Image taken from 9gag.comAccording to database theory, a good RDBMS must implement...
2019-01-30
1,418 reads
MSSQLTips.com Rookie of the year 2018
You need a lot of hard work for success!
2018 was a good year for me in a lot of areas of my life both personal and professional (the birth...
2019-01-21
11 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers