Reblog: March 8 to March 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-15
713 reads
StrateSQL
Pragmatic Works Webcasts This Week #passwit
Every week, Pragmatic Works offers up its “Training on the Ts” webcast series and this month, in honor of Women’s History Month,...
2013-03-11
565 reads
Last Weeks Top 20 “Reading” Links #23
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-11
558 reads
Reblog: March 1 to March 7
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-08
627 reads
Index Analysis March Update
In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure...
2013-03-07
711 reads
That’s Actually A Duplicate Index
As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with...
2013-03-06
2,432 reads
March 2013 – Monthly SQL Server Checklist
It’s the first Monday of the month, do you know where your servers are?
Hopefully, they are still in your data...
2013-03-04
803 reads
Last Weeks Top 10 “Reading” Links #22
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-04
585 reads
Reblog: February 22 to February 28
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-01
924 reads
Presentation Materials “A Function is a Function”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of...
2013-02-28
1,275 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...