Reblog: June 28 to July 4
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-07-05
414 reads
Blog Posts
SQL Saturday Orlando: LAST CALL for Speakers
Hello Dear Reader! I just wanted to write to Thank All of you for the submissions to SQL Saturday 232...
2013-07-05
766 reads
SQLCMD –Quick Copy of Files – Using Robocopy
The requirement is to move the files to different server programatically and hence I’ve decided to use Robocopy in SQLCMD.
Robocopy...
2013-07-05
1,993 reads
Try out SQL Server 2014 CTP1 on Windows Azure
When SQL Server 2014 CTP 1 was announced last week, I was on it and getting ready to download within a...
2013-07-05
1,160 reads
Connecting Ruby 1.9.2 to Microsoft SQL Server on Windows
Ok, before I continue to next step, I really want to put down something about it. Especially about ‘how to...
2013-07-03
9,156 reads
freedom
I was thinking back fondly of my Dad - who passed away during Hurricane Sandy - this past Father's Day. Of the...
2013-07-03
563 reads
Install Windows Server 2012 on VMWare Workstation 8
Sometimes we try an do things that just shouldn’t work. Maybe they aren’t supported or there technology isn’t designed for...
2013-07-03
1,225 reads
SQL Server – How to connect to SQL Server when ‘sa’ account is disabled
If you have lost the password for sa account or does not have any administrative account and you are locked...
2013-07-03 (first published: 2013-07-01)
4,178 reads
SQL Server: Part 4 : All About SQL Server Statistics : Auto Update Statistics Threshold - Importance of Manual statistics maintenance
In the last post, we have discussed about the auto create and auto update property of the statistics. Do we really need to do manual statistics maintenance to keep...
2013-07-03
66 reads
First steps with Extreme Transaction Processing – Hekaton
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
A few hours...
2013-07-02 (first published: 2013-06-25)
3,870 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
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
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers