Natively Compiled Procedures and Execution Plans
The combination of in-memory tables and natively compiled procedures in SQL Server 2014 makes for some seriously screaming fast performance....
2014-06-05
1,363 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Add an Instance to SQL Server Azure Virtual Machine
How do you add an instance to your local SQL Server installation? You run the executable that you probably downloaded...
2014-05-19 (first published: 2014-05-13)
1,489 reads
Carolina Cruise
I’m going to speak at three user groups in three days in North and South Carolina. Evidently this is known...
2014-05-09
494 reads
Speaker of the Month, May 2014
Whoa! Another month gone by already? I guess I better pick a speaker of the month then. I went to...
2014-05-02
1,198 reads
Microsoft Azure Automation
Microsoft just announced a new mechanism for managing your Azure resources, Automation. You can check out the documentation on it...
2014-04-24 (first published: 2014-04-16)
1,783 reads
Azure Automation
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available...
2014-04-23
1,379 reads
I Am Better Than You
That is a patently false statement and total BS. It sure does crawl up your spine though doesn’t it? Why...
2014-04-22
934 reads
SQL Server First Aid
If you take basic first aid, say a CPR course, you’ll learn a handy mnemonic for the primary assessment you...
2014-04-15
1,119 reads
Sharing a Good Idea
I posted earlier about my experiments with Microsoft Curah!. (yes, technically the period should follow the exclamation since the exclamation...
2014-04-14
584 reads
Speaker of the Month, April 2014
I’m really enjoying picking a speaker of the month. It forces me to sit through a lot more sessions at...
2014-04-11 (first published: 2014-04-04)
1,205 reads
Blogs
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers