Speaker at Music City Tech 2019
I’m very happy to announce that for the first time, I will be participating as speaker at the Music City Tech 2019 in Nashville. Here are the details of...
2019-09-03
13 reads
Carlos Robles
- Tagline: Just another witchcraft and wizardry site and DBA tips,
- Interests: SQL Server, Linux, Databases
- Blog: http://dbamastery.com
- Website: http://dbamastery.com
- LinkedIn: https://www.linkedin.com/in/croblesdba/
Modern migration tour 2019 – Guatemala
SQL Server 2008 end of support for SQL Server 2008 is fast approaching, so it’s time to take flight and build your migration plan. As announced during the...
2019-06-24
23 reads
Managing SQL Server containers using Docker SDK for Python - Part 1
There are multiple ways to interact with the Docke...
2019-06-13
4,324 reads
Creating Aliases for Docker Commands in Linux
In this article you will learn how to create and use alias commands for Docker, to make Docker's command line experience easier and more productive.
2019-05-20
20,575 reads
Availability group error message 19405
Availability groups (AG’s) is one of my favorite features of SQL Server, despite some DBA’s catalogue them as “too complex” to implement, configure, manage and maintain … I just...
2019-05-13 (first published: 2019-05-01)
750 reads
Speaker at SQL Saturday’s Colorado Springs 2019
I’m very happy to announce that for the first time, I will be participating as speaker at the SQL Saturday# 830 in Colorado Springs Here are the details of...
2019-04-05
53 reads
dbatools for the accidental DBA
dbatools is a very well known tool within the SQL Server community, and probably most of the production DBA’s are...
2019-04-04 (first published: 2019-03-18)
2,281 reads
Speaker at 24 Hours of PASS – 20 Years of PASS
I’m very happy to announce that for the very first time I will be participating as speaker in the 24 hours of PASS event. This specific instance of 24...
2019-04-03
15 reads
Speaker at SQL Saturday’s Guatemala city 2019
I’m very happy to announce that for the second year in a row I will be participating as speaker in...
2019-02-15
173 reads
Multi-server scripts with SSMS using SQLCMD mode
SSMS is the most common tool used by SQL Developers or DBA’s but unfortunately there are some features that are...
2019-01-30 (first published: 2019-01-16)
3,153 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
How do you keep track of the purpose for SQL Logins?
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers