SQL Server Backups Are A Business Decision
Blog post #3 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
Read more about Tim’s challenge here.
It’s very easy to think of...
2016-03-10 (first published: 2016-03-07)
1,796 reads
The Scary DBA
Speaker of the Month: March 2016
I’m finally getting back out to community events so I should be able to avoid giving this gigantic honor to professional...
2016-03-04
405 reads
Wait Statistics in Azure SQL Database
You need to be aware that you’re going to see differences when you’re working with Azure SQL Database when it...
2016-03-07 (first published: 2016-02-29)
1,727 reads
Query Store and Recompile
One of the many advantages of SQL Cruise is the ability to have enough time during a presentation to be...
2016-02-24
610 reads
Why Is The Server Slow?
This is blog post #2 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel.
If you haven’t been working in SQL Server for very...
2016-02-24 (first published: 2016-02-22)
2,840 reads
Azure SQL Database Error
I was on SQL Cruise where I was scheduled to present a session on Azure SQL Database. I recorded all...
2016-02-18
432 reads
Loading Data into Azure SQL Data Warehouse
Ouch.
Let’s start with the level set. I’m not an ETL expert. In fact, I haven’t done any professional ETL work...
2016-02-15
1,522 reads
Speaker of the Month: February 2016
I’ve been a little remiss on this. I just haven’t been getting out to see people speak for a while...
2016-02-12
452 reads
Positivity
I’m sitting in the classroom of SQL Cruise listening to Tim Ford (b|t) explain mechanisms for monitoring indexes. It’s a...
2016-02-04
549 reads
Learning R: Happy With My Book Choice
This is just a quick update. I wrote about the two books I’m using to learn R. Well, I’m extremely...
2016-02-01
488 reads
Blogs
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...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...