Error: Unknown Property ismemoryoptimized
If you’re starting the process of moving your databases in Azure SQL Databast to v12, you need to do one...
2015-04-07
2,054 reads
The Scary DBA
Constraints and SELECT Statements
I’ve posted previously about how a foreign key constraint can change how a SELECT query behaves. Logically that just makes...
2015-04-16 (first published: 2015-04-06)
7,503 reads
Speaker of the Month: April 2015
One of my favorite events of the year is the SQL Saturday in Silicon Valley. They’ve had four of them...
2015-04-03
603 reads
PASS Board Update: March 2015
Hello all,
It’s been a while since my last update. Sorry. I’ve just been traveling and presenting and working on books...
2015-03-31
1,090 reads
Does the New Cardinality Estimator Reduce Bad Parameter Sniffing
No. Next question.
Although, that answer can be slightly, ever so slightly, nuanced…
Parameter sniffing is a good thing. But, like a...
2015-04-06 (first published: 2015-03-30)
7,263 reads
Toshiba Portege Z301-A Review
Last year I purchased a Lenovo W530. Nightmares then ensued. Nice laptop if you just want to use it as...
2015-03-25
603 reads
Simple Parameterization and Data Types
Simple paramaterization occurs when the optimizer determines that a query would benefit from a reusable plan, so it takes the...
2015-04-02 (first published: 2015-03-24)
6,967 reads
How To Speak At SQL Saturday Events
The PASS SQL Saturday events are meant to be a place to grow the pool of speakers, provide a mechanism...
2015-03-16
831 reads
Speaker of the Month: February & March 2015
It’s not a question of scheduling. I just haven’t been to lots of community events in the last several months...
2015-03-13
571 reads
Monitoring for Timeouts
The question came up at SQL Rally, “Can you use Extended Events to monitor for query timeouts?”
My immediate response was...
2015-03-20 (first published: 2015-03-12)
7,590 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
Forums
FARE LABS Pvt. Ltd. is an Indian proficiency testing laboratory.
The greatest facility for proficiency testing in India is Fare Labs. We use particular...
display bytea image
I moved a table from MsSql to Postgresql that had a field defined as...
When trying to use a LocalDB, I get an error
I tried to find an appropriate forum to post the question. This one seems...
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers