Connecting to the Hortonworks Sandbox v1.3 through IP 192.168.56.101
I recently downloaded the Hortonworks Sandbox v1.3 Hyper-V VM and had a hard time connecting to the included web interface...
2013-08-08
1,651 reads
Blog Posts
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
965 reads
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,479 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,464 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
679 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,553 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
553 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
671 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
672 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers