Execution Plan Cost Estimates
It’s been emphasized over and over that the costs of operations within an execution plan, and the estimated costs of...
2013-09-11
1,731 reads
The Scary DBA
New Windows Azure Virtual Labs
Getting started with new technologies can be a pain. That makes all the new labs that Microsoft just posted extremely...
2013-09-10
590 reads
Developers Rate Azure One of Their Favorite Tools
Yeah, Azure.
How we program, what we program and where we program is changing. All the time. This excellent article lays...
2013-09-09
1,269 reads
Speaker of the Month: September 2013
This is my second post in what I hope will be an ongoing series. You can see the rules for...
2013-09-06
863 reads
sp_executesql, Parameters and Parameter Sniffing
I’m honestly not crazy about dynamic T-SQL within stored procedures. There are just a few too many opportunities to mess...
2013-09-05
1,529 reads
Azure Capabilities Expand
But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog...
2013-09-04
625 reads
My Next Phone May Be a Nokia
I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...
2013-09-03
544 reads
One for My SQL Sisters
Women, for the entire male half of the population, I apologize.
Those who know me well recognize, pretty easily, that I...
2013-08-30
1,786 reads
Windows Azure SQL Database and Throttling
When I present on Windows Azure SQL Database, one of the biggest concerns comes up around throttling. Just the concept...
2013-08-29
1,532 reads
Learn Query Tuning in Dallas
I am excited to be able to tell you about an all day seminar that I’ll be putting on prior...
2013-08-28
639 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers