Introduction to Azure Database Services
Azure SQL database is a cloud based Database as a Service provided by Microsoft Azure platform. This service is based on the traditional SQL Server(more...)
2021-05-02
17 reads
Blog Posts
Fix The “can’t start MySQL in XAMPP” Error in a Simple Way
XAMPP is an essential support software for website administrators and programmers, but installing XAMPP is not easy. Most of the time during the installation process, users often encounter an error...
2021-05-01
15 reads
Fix The “can’t start MySQL in XAMPP” Error in a Simple Way
XAMPP is an essential support software for website administrators and programmers, but installing XAMPP is not easy. Most of the time during the installation process, users often encounter an error...
2021-05-01
821 reads
Recent updates on my work with Data Vault and Azure Data Factory
(2021-May-01) My first time working with a Data Vault modeling was in 2018, where I started and continued my journey to explore this approach or creating a scalable mechanism to...
2021-05-01
519 reads
Cool Stuff in Snowflake – Part 11: RESULT_SCAN
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2021-04-30 (first published: 2020-02-04)
501 reads
Daily Coping 30 Apr 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-30
12 reads
Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)
I am very passionate about having a disaster recovery architecture, plan and strategy. This is very important for business continuity. I will be walking you through a journey on...
2021-04-30 (first published: 2020-02-01)
383 reads
Remote Work
This is going to be the first time I’m working remotely today in over a year. I’m in Omaha, and while I’ve gone to a few cities, I haven’t...
2021-04-30
12 reads
Daily Coping 29 Apr 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-29
11 reads
Modernizing Your T-SQL: String Aggregation
This is another in a group of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. SQL Server 2016 gave us the STRING_SPLIT()...
2021-04-29 (first published: 2020-02-18)
1,240 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers