A Graphical View of the Physical Allocation of a Database
First saw information about a tool called SQL Internals Viewer in a blog post here at Kalen Delaney's blog. The...
2007-07-20
1,648 reads
Blog Posts
More Navigation
I've looked at the daily newsletter for a year now and I've wondered about the table of contents. It seems...
2007-07-19
1,395 reads
Tampa Code Camp - Again
This turned out to be a nice event, better venue than last year. Well organized is always appreciated even at...
2007-07-18
1,364 reads
New version of SQL Server 2005 Best Practices Analyzer available
If you haven't seen the announcement, a new version of the SQL Server 2005 Best Practices Analyzer is available for...
2007-07-17
1,711 reads
New MySQL Entry Level Certification
Last week I received an email indicating that MySQL had made available an entry level certification, the Certified MySQL Associate....
2007-07-16
1,551 reads
QOD Day
Quite a few complaints on the QOD section from last week, mostly justified. A couple I had to defend, which...
2007-07-16
1,579 reads
The meaning of Database Administrator
In two blogs I follow, Andy Leonard's blog on SQLBlogs.com and Sheeri Kritzer's The MySQL She-BA, the question of what...
2007-07-16
1,558 reads
SQL Server Reporting Services (SSRS) Templates and Styles
Ever wanted to change the default template and style for the Reporting Services Wizard? Just think how much time this...
2007-07-15
8,267 reads
Beta Testing
I'm not big on beta testing, or at least haven't been for a number of
years because I can't afford the...
2007-07-13
1,379 reads
Buy a $10 Raffle Ticket to Help Katie
Not a happy story, but if you've got a child I suspect it will be easy to decide to buy...
2007-07-12
1,383 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
how to keep report from running automatically when no params are required
Hi I'm standing up a report with 9 visible cascading params , none of...
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',...