Extracting Data From Multiple Files with Power Query
In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time...
2013-08-08
957 reads
Blog Posts
How implicit data type conversion slows down your query
Implicit data type conversion is one of those things you hardly think about or notice when writing your queries. But...
2013-08-08
1,474 reads
SQL Server Crossword #5
When there’s something worth celebrating, such as a birthday or achieving the Microsoft Certified Master (MCM) SQL Server certification, I like...
2013-08-08 (first published: 2013-08-06)
1,463 reads
Survey: Are you a SQL Server Professional and running on Mac?
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
I know a...
2013-08-08
1,156 reads
Be Cautious When Critizing About Guidance
I recently posted some comments about some guidance offered by Microsoft when talking about the CXPACKET wait type. Nothing I...
2013-08-07
677 reads
Connect to SQL Server When Window account Locked Out || Sql authentication(Sa) not configured
Hello Friends,
It’s being a many days I haven’t written anything. But there was lot of stuff I was thinking to...
2013-08-07
1,550 reads
Normalisation
The purpose of normalisation is to remove redundancy and prevent conflict. 1st Normal Form (1NF) – Every field can have only...
2013-08-07
549 reads
Presentations slides for Best Practices to Deliver BI Solutions
Thanks to everyone who attended my session “Best Practices to Deliver BI Solutions” for Pragmatic Works. The abstract for my session...
2013-08-07
670 reads
Register for the SQL Server Live! Conference in Orlando Through TheSQLPro.com and Receive a $500 Discount
The SQL Server Live! Conference in Orlando is between November 18-22, 2013. There is a discount code provided for those...
2013-08-07
658 reads
SQL Server – Automating Backup Files Cleanup Task Using Maintenance Plans
Cleaning/deleting the old backup files is equally important as taking the backups. Doing so we can (i) Avoid overhead cost for...
2013-08-07
1,004 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers