Correct SQL Server Transactional Replication Issues with T-SQL and SSMS
Learn how to address SQL Server transactional replication issues with these easy-to-follow steps using T-SQL and SSMS to troubleshoot and fix issues.
2024-03-18
Articles
The difference between BIN2 and Case-Sensitive collations in SQL
Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.
2024-03-15
1,374 reads
Automating BCP with PowerShell
I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, creates the inserts and schema files
2024-03-15
SQL Server to PostgreSQL Database Schema Conversion
In this tip, I will demonstrate how to migrate an existing database schema from SQL Server to PostgreSQL.
2024-03-13
Power BI Auto Detect Relationship Failure
Power BI doesn't always detect relationships, and this article explains a bit about the problem.
2024-03-11 (first published: 2024-03-08)
1,223 reads
Will AI end with SQL, Is this the end of SQL?
An experienced DBA asks an AI to perform some common tasks. Read to see how it fairs and if an AI will impact DBA jobs.
2024-03-11
7,374 reads
Why Test-Driven Development? (Part 2)
As discussed in Part 1, by segregating our focus on developing code that behaves as expected from the focus on developing code that will be well structured, we have achieved the ability to eliminate wasteful and error prone manual chores.
2024-03-11
SSRS 2022 Install, Setup and Configuration
This article includes all of the steps you need to take to install and configure SQL Server Reporting Services 2022.
2024-03-08
Top-Down and Bottom-Up Approaches in Microsoft Fabric
Nikola Ilic, best known as Data Mozart, published a great article and video about how to make semantic model data available in Microsoft Fabric. This allows the data to be used in lakehouses or data warehouses. One major question that arises is, “should we use a top-down or bottom-up (or both) approach in Microsoft Fabric?
2024-03-06
Evolving Role of Data Professionals in Artificial Intelligence Era
Generative Al tools like Gemini and GPT promise to automate and augment knowledge-based work. Data professionals must adapt to this transformation by acquiring new skills and playing a central role in their organization's AI-driven future. Data preparation, curation, ethical sourcing and labeling, and collecting user feedback become crucial as high-quality data is essential for effective LLM based application.
2024-03-04
2,541 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
Check sequential order of status of items
There is a table tblItems with below structure ( i cannot change the below...
Calling Invoke-Sqlcmd from powershell and passing an object containing a '-'
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
Question of the Day
Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers